Free ebook
Free ebook: Pivot Tables from Zero
A complete beginner walkthrough for building your first PivotTable: rows, columns, values, and filters, grouping dates, changing how values summarize, slicers, sorting, and keeping it fresh when your data changes. Real practice data throughout.
Get the ebookCourse path
Turn Pivot Tables into a course path
Pivot Tables strings this into a structured, intermediate-friendly path with a full lesson list.
View course path5 subtopics in this path
Pivot table setup, fields, grouping, calculated fields, slicers, pivot charts, refresh behavior, and source-data habits.
Each item pairs the learning structure with curated public YouTube resources where available, so learners can move from outline to video practice quickly.
Build a pivot from clean data and understand rows, columns, values, and filters.
Simon Sez IT
Open on YouTube (opens in a new tab)
Excel Campus - Jon
Open on YouTube (opens in a new tab)
Group transactions by month, quarter, year, numeric ranges, and custom buckets.
Simon Sez IT
Open on YouTube (opens in a new tab)Switch between sum, count, average, percentages, running totals, and differences.
Add clickable controls that make pivot reports easier to explore.
Connect pivots to charts and keep visuals synchronized with report filters.
Real Excel screenshots showing what this topic looks like in practice.
Simon Sez IT
Public playlist-style learning path for PivotTables from beginner into practical reporting.
Open on YouTube (opens in a new tab)Excel Campus - Jon
Clear beginner entry point from a Microsoft MVP-led Excel channel.
Open on YouTube (opens in a new tab)Kevin Stratvert
Concise practical walkthrough for first-time PivotTable users.
Open on YouTube (opens in a new tab)Kevin Stratvert
Single-video coverage of slicers, grouping, value field settings, and show-values-as patterns.
Open on YouTube (opens in a new tab)
Kevin Stratvert
Clear beginner-friendly walkthrough for learners starting with Excel pivot-table reporting.
Open on YouTube (opens in a new tab)Simon Sez IT
Beginner-to-advanced structure makes it useful as a broad pivot-table course resource.
Open on YouTube (opens in a new tab)Simon Sez IT
Long advanced lesson for learners who know basic pivot tables and want deeper reporting techniques.
Open on YouTube (opens in a new tab)
Simon Sez IT
One-hour crash course gives learners a compact but structured path into pivot-table reporting.
Open on YouTube (opens in a new tab)
Simon Sez IT
Multi-hour beginner format works well for learners who want a complete first course on pivot tables.
Open on YouTube (opens in a new tab)
MyExcelOnline.com
Connects pivot tables directly to slicers and dashboards as a bridge from analysis to reporting.
Open on YouTube (opens in a new tab)
Leila Gharani
Extracted from saved YouTube search results - titled "Advanced Pivot Table Techniques (to achieve more in )", filed under Pivot Tables.
Open on YouTube (opens in a new tab)
Learn Skills Daily
Extracted from saved YouTube search results - titled "Pivot Tables", filed under Pivot Tables.
Open on YouTube (opens in a new tab)26 places we cite for accuracy. We link to them; none has reviewed, endorsed, or collaborated on this site.
Official documentation
Educators and channels
ExcelJet (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)
Teacher's Tech (opens in a new tab)
YouTube (opens in a new tab)Course platforms
