Skip to content

Level 2 · Intermediate

Modules

  1. Advanced Formulas (SUMIFS/COUNTIFS/AVERAGEIFS)
  2. PivotTables Deep Dive
  3. Advanced Charting & Dashboards
  4. Data Validation Advanced & Form Controls
  5. Power Query Basics
  6. Array Formulas & Dynamic Arrays
  7. What-If Analysis
  8. Working with Multiple Sheets & Workbooks
  9. Intro to Recording Macros
  10. Project — Interactive Sales Dashboard