Advanced
Advanced Excel for Business
Go beyond the basics: master Power Query, advanced formulas, pivot tables and dashboard design so you can automate reporting and impress any finance or operations team.
6h 6 lessons Advanced level
Pro membership
Unlock this course and 50+ others
One membership at £4 a month opens every lesson, quiz and certificate on Skillora. Cancel anytime.
- Every paid course in the library unlocked
- Quizzes and verifiable completion certificates
- Career pathways matched to the courses
- Cancel any time — access runs to the end of your billing period
Course content
Module 1: Power Query and data automation
Import, clean and refresh data automatically
- Introduction to Power Query10 min
- Cleaning and combining files12 min
Module 2: Advanced formulas and pivot tables
Lookups, conditional aggregation and pivots
- XLOOKUP and modern lookups11 min
- SUMIFS, COUNTIFS and pivot tables12 min
Module 3: Dashboards and scenario modelling
Interactive reports and what-if analysis
- Building an interactive dashboard13 min
- What-if analysis and goal seek12 min