Description
10 Mins = Pivot Tables ✅
Master Excel pivot tables in under 10 minutes. Learn the exact steps to organize your data and create professional reports today. In this video, I explain how I make pivot tables and show case 4 real-world examples with clear explanation of what a pivot report is, how to format and sort them, how to add extra calculation columns, use report filters, create pivot charts, set up slicers, top 10 filter, group values and answer business questions.
Sample file: https://chandoo.org/wp/wp-content/uploads/2026/06/pivot-tables-2026-data.xlsx
Concepts covered (with timestamps):
0:00 - Learn Excel Pivot Tables in 10 minutes
0:11 - Sample data and tabular format
0:29 - Creating your first pivot table
3:20 - Pivot 2 - Weekday Report (adding a calculation column, refresh)
4:56 - Pivot Charts and Report Filters
6:10 - Pivot 3 - Seeing Top 10 Values and slicing by city
8:37 - Pivot 4 - Answering a business question (grouping values)
Learn more:
Full Excel Course (with me): https://chandoo.org/wp/excel-school-program/
Pivot Table Video Series:
1) Another introduction - https://youtu.be/aofsdpjvK7w
2) How to connect multiple tables - https://youtu.be/SPFQX82X03Q
3) How to make a pivot data in multiple sheets - https://youtu.be/gi-DSWEUC-A
4) How to use slicers - https://youtu.be/ZZ-UGMztoqo
5) Full Masterclass (45 mins) - https://youtu.be/zuSNd1ZMfBI
~
#pivot #Excel