How to Use Pivot Tables in Excel - The Ultimate Playlist!
Simon Sez IT
Open on YouTube (opens in a new tab)Free ebook
Free ebook: Conditional Formatting Mastery
Everything you need to know about Excel's conditional formatting: highlight rules, top/bottom rules, data bars, color scales, icon sets, formula-based rules, managing and debugging rules, and real-world use cases. Hands-on examples throughout.
Get the ebookFree tools
Practice with free browser tools
Formula builder, formula explainer, CSV cleaner, and 7 more — no upload, no sign-up. Try what you learn in the lessons.
Browse free tools=COURSE.PATH
Pivot Tables
Courses for summarizing data, grouping fields, slicers, pivot charts, and practical pivot reporting workflows.
What this path is for
Use this page when you want a guided route through public Excel lessons without searching from scratch. Preview a tutor, open the full lesson on YouTube, and return here for the next option.
Learn
Summarize clean data with rows, columns, values, and filters.
Learn
Use grouping, value settings, slicers, timelines, and pivot charts.
Learn
Turn transaction lists into reusable management summaries.
Suggested course flow
- 01How to Use Pivot Tables in Excel - The Ultimate Playlist!Simon Sez IT - preview available
- 02Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)Excel Campus - Jon - preview available
- 03Pivot Table Excel TutorialKevin Stratvert - preview available
- 04Pivot Table Excel Tips & TricksKevin Stratvert - preview available
- 05Pivot Table Excel | Step-by-Step TutorialKevin Stratvert - preview available
- 06Excel PivotTables: Beginner to AdvancedSimon Sez IT - preview available
Previewable lessons
Showing the first 36 of 45 curated public lessons for this path.
01
02
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
Excel Campus - Jon
Open on YouTube (opens in a new tab)03
04
05
06
07
Advanced Pivot Tables Tutorial in Excel - 2.5 Hour Pivot Table Excel Course
Simon Sez IT
Open on YouTube (opens in a new tab)08
Pivot Table Tutorial - Learn PivotTables in 1 Hour - Excel Crash Course
Simon Sez IT
Open on YouTube (opens in a new tab)09
10
Master Excel Pivot Tables, Excel Slicers and Interactive Excel Dashboards - FULL COURSE!
MyExcelOnline.com
Open on YouTube (opens in a new tab)11
Advanced Pivot Table Techniques (to achieve more in Excel)
Leila Gharani
Open on YouTube (opens in a new tab)12
13
Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!)
Leila Gharani
Open on YouTube (opens in a new tab)14
15
16
17
18
Master Pivot Tables in 10 Minutes (Using Real Examples)
Kenji Explains
Open on YouTube (opens in a new tab)19
Excel PivotTables Made Easy in 2026 (+ What's Changed!)
MyOnlineTrainingHub
Open on YouTube (opens in a new tab)20
Master Pivot Tables in 10 Minutes (Using Real Examples)
Kenji Explains
Open on YouTube (opens in a new tab)21
22
Using Excel Slicers to Filter Data
Technology for Teachers and Students
Open on YouTube (opens in a new tab)23
24
25
Select And Format All Subtotals Rows In Pivot Table (In Tabular Form)
Dollar Excel
Open on YouTube (opens in a new tab)26
27
Use slicers with PIVOTBY, GROUPBY & FILTER in Excel
Excel Off The Grid
Open on YouTube (opens in a new tab)28
Excel Slicers WITHOUT PivotTables? The Disconnected Table Trick
Excel Off The Grid
Open on YouTube (opens in a new tab)29
Table slicers for advanced interactivity in Excel
Excel Off The Grid
Open on YouTube (opens in a new tab)30
How to use Excel Slicers like a PRO: Basics + 5 Advanced Tricks
Chandoo
Open on YouTube (opens in a new tab)31
32
Advanced Excel - Creating Pivot Tables in Excel
Technology for Teachers and Students
Open on YouTube (opens in a new tab)33
Excel Slicer Custom Sorting Hacks - Masterclass!
MyOnlineTrainingHub
Open on YouTube (opens in a new tab)34
35
Excel PivotTables - Percentages - Grand Totals, Row Totals, and Column Totals
Chris Menard
Open on YouTube (opens in a new tab)36
Excel Pivot Table EXPLAINED in 10 Minutes (Productivity tips included!)
Leila Gharani
Open on YouTube (opens in a new tab)Sources we reference — not partners
26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.
Official documentation
Educators and channels
- Chandoo (opens in a new tab)
ExcelJet (opens in a new tab)- MrExcel (opens in a new tab)
- Contextures (opens in a new tab)
MyOnlineTrainingHub (opens in a new tab)
XelPlus (opens in a new tab)
Excel Campus (opens in a new tab)
Wise Owl (opens in a new tab)- Simon Sez IT (opens in a new tab)
Teacher's Tech (opens in a new tab)
YouTube (opens in a new tab)- Edureka (opens in a new tab)
Course platforms
