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 overviewExcel Pivot Tables & Dashboards: Basic to Advanced
Free preview lessonExcel Pivot Tables & Dashboards: Basic to Advanced132 lessons · 11h 51m · Certificate of completion
Regular price ₹3,999.00 ₹2,499.00
View course details
MODULE 1 / 16LESSON 2 OF 132

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.

FREE EXCEL LESSONS BY EMAIL

Not ready to enroll yet?

Join the Academy email list for practical Excel and AI tips, free preview lessons and news when a new course opens. Unsubscribe at any time.