CellWorks

Microsoft Excel · Expert

Advanced functions, modelling and dashboards.

Lessons

  1. 1Dynamic Arrays: FILTERAnswer pipeline questions from a CRM export with FILTER, Boolean logic and if_empty results.Not started20 min
  2. 2SORT & UNIQUERank customers and build distinct lists from an order log with SORT, UNIQUE and INDEX.Not started20 min
  3. 3Multi-Criteria LookupsPrice merchandise by product and size with concatenated XLOOKUP and Boolean INDEX/MATCH.Not started20 min
  4. 4Weighted Scoring with SUMPRODUCTScore suppliers with weighted criteria and count results with SUMPRODUCT.Not started20 min
  5. 5Readable Formulas with LETBuild a wholesale quote formula with named intermediate values using LET.Not started20 min
  6. 6Tiered Rates & IFSApply tiered commission rates with approximate-match lookups and label tiers with IFS.Not started20 min
  7. 7Loan Modelling with PMTModel a mortgage: monthly payment, total cost, interest and a rate-rise scenario.Not started20 min
  8. 8Date-Based AnalysisAnalyse subscription customers by tenure, renewal date and quarter with DATEDIF, EOMONTH and date-range SUMIFS.Not started22 min
  9. 9Scenario ModellingBuild a switchable pessimistic/base/optimistic profit model with INDEX, CHOOSE and break-even analysis.Not started22 min
  10. 10Troubleshooting Broken FormulasAudit and repair an expense claim sheet with an unlocked rate, a circular total and a broken average.Not started22 min
  11. 11Operational KPI CalculationsCalculate production KPIs — defect rates, best shift output and threshold breaches — for a factory dashboard.Not started24 min
  12. 12Final Assessment: Production Mix DecisionPractical assessment: decide which products deserve scarce machine time using profit, constraint analysis, dynamic arrays and lookups.Not started30 min