Excel Pivot Tables & Dashboards: Basic to Advanced
Go from your first Pivot Table to the Data Model, DAX, automated Power Query reports and a one-page Retail KPI dashboard, with practice files, a hands-on assessment and quiz for every module and a final capstone.

What you’ll learn
- Prepare clean data and build Pivot Tables with confidence
- Summarize and compare data with Value Field Settings and Show Values As
- Make reports interactive with slicers, timelines, search and cross-filtering
- Add calculated fields, calculated items, conditional formatting and sparklines
- Connect Pivot Tables to other workbooks, CSV, web, PDF and multiple sheets
- Build one pivot from several related tables with the Data Model, relationships and DAX measures
- Report YTD, previous-year and YoY % results with DAX time intelligence
- Automate refreshable reports with Power Query: unpivot cross-tabs and combine a folder of monthly files
- Compare GROUPBY and PIVOTBY formula pivots with PivotTables and fix the most common Pivot Table errors
- Build a sales report, an expense tracker, a multi-page sales dashboard and a one-page Retail KPI dashboard
A practical route to better work.
A complete, project-based Pivot Table course in 16 modules. Start with clean data and Pivot Table basics, then master Value Field Settings, sorting, filters, slicers, timelines, grouping, calculated fields, layouts and styles, Pivot Charts, infographic charts, Pivot Table options, GETPIVOTDATA and AI-assisted analysis. Connect Pivot Tables to tables, other workbooks, CSV files, websites, PDFs and multiple sheets with Power Query, then build a sales report, an expense tracking dashboard and a multi-page interactive sales dashboard from scratch. Module 14 adds the Data Model: one pivot from four related tables, DAX measures with CALCULATE, DIVIDE, DISTINCTCOUNT and ALL, and time intelligence (YTD, previous year and YoY %). Module 15 automates your reports: unpivot cross-tab data, combine a folder of monthly files that refreshes itself, compare GROUPBY and PIVOTBY formula pivots with PivotTables, and fix the eight most common Pivot Table errors. Modules 1-12, 14 and 15 each end with a hands-on assessment on a realistic US business workbook with a self-marking Checks sheet, a 10-question quiz and a full solution walkthrough video, and the course closes with a final capstone: a one-page Retail KPI dashboard powered only by PivotTables. Every lesson includes the practice workbook used in the video.
Inside the course
16 modules · 132 lessonsMODULE 01Welcome and Pivot Table Foundations+
MODULE 02Value Field Settings+
MODULE 03Sort, Filter, Slicers, Timelines and Grouping+
MODULE 04Calculated Fields and Items+
MODULE 05Layouts, Styles and Formatting+
MODULE 06Pivot Charts+
MODULE 07Advanced and Infographic Charts with Pivot Tables+
MODULE 08AI and Pivot Table Options+
MODULE 09Advanced Interactivity+
MODULE 10Connect Pivot Tables to Data Sources+
MODULE 11Multiple Tables, Sheets and PDF with Power Query+
MODULE 12Projects: Sales Report and Expense Tracking Dashboard+
MODULE 13Capstone: Multi-Page Interactive Sales Dashboard+
MODULE 14Data Model, Relationships and DAX+
MODULE 15Power Query Automation, Formula Pivots and Troubleshooting+
MODULE 16Final Capstone: Retail KPI Dashboard+
Practice files
61 downloadable practice workbooks to follow along with the lessons.
Video lessons
101 step-by-step video lessons (11h 51m), streamed securely.
A practical assignment
Apply your learning, submit your work and explain your approach.
A knowledge check
Test your understanding with clear feedback and explanations.
Certificate of completion
Complete the course to download a certificate of completion with a unique certificate ID.
Is this course for you?
- Working professionals who prepare recurring Excel reports
- Analysts and students who want to build dashboards in Excel
- Managers and small-business owners who make decisions from Excel data
Before you start
- Basic Excel navigation and simple formulas
- Microsoft Excel 2016 or later for Windows (Microsoft 365 recommended for the AI, Power Query and Data Model lessons; required for GROUPBY and PIVOTBY)
About your instructor

Priyendra Kumar (PK)
Founder, NextGenTemplates · Creator of PK: An Excel Expert
A business intelligence consultant, educator and template creator with more than 20 years of real-world experience in Excel, Power BI, Google Sheets, dashboards and business reporting.
PK has shared Excel tutorials on YouTube since 2017. In this course he teaches the same practical way: understand the idea, work through a business example, and build something you can use.
More about PKGood to know
How do I buy a course, and which payment methods can I use?+
Choose a course, select Add to cart and complete checkout. With an Indian billing address you pay in INR through Razorpay, using UPI, cards or net banking. From any other country you pay in USD through PayPal, including debit and credit cards. It is a one-time payment, and the course appears in My Learning as soon as payment is confirmed.
Can I learn at my own pace?+
Yes. Lessons are organized into modules, and signed-in learners can save their progress and resume where they left off.
Are practice files included?+
Yes. Practice files are included with each paid course and can be downloaded from the course once you are enrolled. They are for your personal learning and your own internal work.
Will I receive a certificate?+
Yes. When you complete all required lessons (and any knowledge check or assignment in the course), you can download a certificate of completion with a unique certificate ID. It confirms course completion; it is not an academic or professional accreditation.
How long will I have course access?+
You get lifetime access: you can use the course for as long as NextGenTemplates Academy operates and offers it, as described in the Course Access Policy. There is no subscription or renewal fee.
Can I get a refund?+
Courses are digital content with immediate access, so purchases are generally non-refundable. Limited exceptions are explained in the Refund Policy.
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.
