Advanced Excel Formulas & Functions Masterclass
Two-way and multi-criteria lookups, SUMPRODUCT, array maths, text, date, statistical and financial formulas – 10 hands-on labs ending with a broken report you repair, every cell checked instantly.
The first lesson is free — no account needed.
Lessons
- Advanced Lookups: Two-Way, Multi-Criteria and TiersFree
- Multi-Criteria SUMIFS, COUNTIFS, AVERAGEIFS and MAXIFS Pro
- SUMPRODUCT with Boolean Arrays Pro
- Array Math inside SUM, AVERAGE, MAX and MATCH Pro
- Nested Logic: IFS, SWITCH, CHOOSE and IFERROR Pro
- Text Formulas: FIND, MID, SUBSTITUTE, TEXT and TEXTJOIN Pro
- Date & Time Formulas: EOMONTH, NETWORKDAYS, WEEKNUM, HOUR Pro
- Statistical Formulas: RANK, PERCENTRANK, LARGE and Conditional MEDIAN Pro
- Financial Formulas: PMT, PPMT, NPV and XNPV Pro
- Capstone: Audit and Repair a Broken Report Pro