Beginner
Excel Analytics
Pivot tables, formulas and dashboards for real analysis.
1h 12m 9 lessons 4.8 5.2k 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: Clean data foundations
Structure your data so analysis is possible.
- How a good spreadsheet is structured8 min
- Cleaning messy data8 min
- Tables, named ranges and validation8 min
Module 2: Formulas that answer questions
The functions that cover most business analysis.
- Aggregation with SUMIFS and COUNTIFS8 min
- Lookups with XLOOKUP and INDEX MATCH8 min
- Logic, dates and error handling8 min
Module 3: Reporting and dashboards
Turn numbers into decisions.
- Pivot tables in ten minutes8 min
- Charts that communicate8 min
- Building a simple dashboard8 min