Data AnalysisBeginner
Excel Advanced Analytics & Power Query
Takes you well beyond VLOOKUP. Learn Power Query for data transformation, Power Pivot, advanced formulas, dynamic arrays, and how to build professional analysis workbooks.
Tools & Technologies
Microsoft ExcelPower Query
Course Curriculum
1
Advanced Formulas
- XLOOKUP & dynamic arrays
- FILTER, SORT, UNIQUE
- Nested IF logic
2
Power Query
- Data import & connection
- Transform & clean data
- Merge queries
3
PivotTables & Analysis
- Advanced PivotTables
- Calculated fields
- Data models
4
Power Pivot
- Introduction to DAX
- Relationships
- Business dashboards
What's Included
Live instructor-led online session
Small cohort (max 12 delegates)
Course materials & code samples
CPD accredited certificate
Post-session recording (30 days)
Q&A with your instructor
£395+ VATEnrol Now Book for a team
per person, excluding local tax.
7 hours (1 day)
Next: Wed, 11 Mar 2026
9 seats remaining
Beginner level
3/12 seats filled
CPD accredited · Full refund 14 days before