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 4.8 0 learners
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 course in the library unlocked
- Quizzes, projects and verifiable certificates
- Offline downloads for low-data study
- New courses added every month
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