Excel for Analytics
Build reliable, auditable analysis in Excel using modern features and robust process.
Outcomes
- Confident use of dynamic arrays, XLOOKUP, LET, LAMBDA
- Clean data with Power Query; build models with Power Pivot
- Structure workbooks with controls, documentation and QA
Outline (1–2 days)
- Keyboard mastery & modelling patterns
- Data cleaning with Power Query
- Relationships, star schemas & measures
- Scenario analysis & sensitivity tooling
- Documentation & review checklists
Audience & tooling
Analysts and finance partners using Microsoft 365. Optional integration with Power BI.