A new chapter in practical learning ·Now enrolling: Excel + AI Mastery, Excel Essentials in 2 Hours, Excel Pivot Tables & Dashboards, Excel VBA Basics with AI, Financial Modeling in Excel, Google Sheets Complete Course, Power BI and Project Management in ExcelView the courses ↗
Course roadmap: modules, assessments and the final capstone
Welcome and Pivot Table Foundations · 3 min
Welcome to Excel Pivot Tables & Dashboards. This short video walks you through the course: 16 modules that take you from your first PivotTable to the Data Model, DAX, automated Power Query reports and a one-page KPI dashboard.
How the course is organized
Modules 1-9: PivotTable foundations, Value Field Settings, sorting, filters, slicers, timelines and grouping, calculated fields, layouts and styles, PivotCharts, infographic charts, options, GETPIVOTDATA and interactivity.
Modules 10-11: connect PivotTables to tables, workbooks, CSV, web and PDF data, and combine several tables and sheets with Power Query.
Modules 12-13: projects - a sales report, an expense tracking dashboard and a multi-page interactive sales dashboard.
Module 14: the Data Model, relationships and DAX measures, including time intelligence.
Module 15: Power Query automation (unpivot, a folder of monthly files), GROUPBY and PIVOTBY formula pivots, and a troubleshooting clinic for the most common PivotTable errors.
Module 16: the final capstone - a Retail KPI dashboard powered only by PivotTables.
Assessments and certificate
Modules 1-12, 14 and 15 end with a hands-on assessment workbook on a realistic US business, a 10-question quiz (pass mark 70%) and a full solution walkthrough video; Module 13 ends with a quiz. Every assessment workbook has a self-marking Checks sheet. Complete every lesson, pass every quiz and submit the final capstone to finish the course.
Practice files
Download the files from the Practice resources tab: the workbook used in each lesson, a practice pack for each new lesson, one zip per module assessment, the final capstone and the answer keys. Save a working copy before you start.
What you need
Microsoft Excel 2016 or later for Windows; Microsoft 365 is recommended for the AI, Power Query and Data Model lessons and is required for GROUPBY and PIVOTBY. All business data in the course is fictional.