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