Pivot Tables
3 tutorials written here on pivot tables, plus 45 public pivot tables videos from other channels, filed by level and subtopic.
All articlesOriginal tutorials
3Pivot tables vs formulas for summarising data: which to use?
When a pivot table is faster and more flexible than a formula-based summary, and when formulas are the better fit — a practical guide.
Pivot table report for managers
Design a pivot table report that answers manager questions without overwhelming them with fields and filters.
How to create a pivot table in Excel (step-by-step)
A beginner's guide to building your first pivot table: preparing your data, choosing rows and values, and the mistakes that trip up almost everyone.
Video resources
Every pivot tables video we have filed, published by other channels. All 45 are listed — nothing hidden behind a cap.
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
