Excel Power Formulas for Non-Accountants

VLOOKUP, XLOOKUP, IF logic, and dynamic arrays — the formulas that actually matter for marketers, HR, and ops pros. With real-world business examples.

Lessons

1. VLOOKUP vs XLOOKUP: Which to Use and When
2. IF, AND, OR: Building Decision Logic
3. SUMIF, COUNTIF, AVERAGEIF: Conditional Math
4. Dynamic Arrays: FILTER, SORT, UNIQUE
5. Building a Live Dashboard from Scratch

All courses