Foundational program
Excel for Analytics
Reliable, auditable analysis in Excel for financial services teams, using modern features and a process you can trust.
The program
What you or your team learns
What you walk away with.
- Confident use of dynamic arrays, XLOOKUP, LET and LAMBDA
- The skills to clean and reshape data with Power Query
- Relational models and measures built with Power Pivot
- Workbooks structured for review with QA built in
1 to 2 days
Course outline
- 1Keyboard mastery and modelling patterns
- 2Modern formulas: dynamic arrays and LAMBDA
- 3Data cleaning with Power Query
- 4Relational models and measures in Power Pivot
- 5Scenario analysis and sensitivity tooling
- 6Documentation and review checklists