Data AnalyticsBeginner
Excel Advanced Analytics & Power Query
Built for professionals who use Excel daily but know there is more to it than they are currently using. This session goes well beyond VLOOKUP — covering dynamic array formulas, Power Query for automated data transformation, and Power Pivot for business modelling. Applicable to Excel 2019, 2021, and Microsoft 365.
Tools & Technologies
Microsoft ExcelPower Query
Course Curriculum
1
Modern Formulas
- XLOOKUP, FILTER, SORT, UNIQUE
- Dynamic arrays and spill ranges
- Nested logic and complex IF structures
2
Power Query
- Connecting to data sources (CSV, web, databases)
- Cleaning and transforming data with M code basics
- Merging queries and automating refreshes
3
PivotTables & Power Pivot
- Advanced PivotTables and calculated fields
- Introduction to DAX and data models
- Relationships between tables
4
Building an Analysis Workbook
- Charts that update automatically
- Conditional formatting as a communication tool
- Structuring workbooks for others to use
What's Included
Live instructor-led session
Small cohort
Course materials pack (slides, code, datasets)
Certificate of completion
14-day email support
£890Early bird
£595Save £295
per person
7 hours (1 day)
Next: Wed, 11 Mar 2026
9 seats remaining
Beginner level
3/12 seats filled
Completion certificate included