Module 03
Excel — Analysis
PivotTables, dynamic arrays and the analysis tools. This is where a spreadsheet starts answering questions instead of storing numbers.
7 topics ~27 h estimated learning time
Comes after02. Excel — Formulas & Functions
Sign in to keep your progress.
Ready to start
- 3.1 PivotTables
Core · 5 h
- 3.2 PivotTables beyond the basics
Advanced · 4 h
- 3.3 Dynamic arrays and spill formulas
Core · 4 h
- 3.4 Data validation and protecting a model
Core · 3 h
- 3.5 Conditional formatting
Core · 3 h
- 3.6 What-if analysis and simple modelling
Advanced · 4 h
- 3.7 Describing data honestly in Excel
Core · 4 h