Excel Pivot Tables in 10mins (free workbook)
By Chandoo
Community Score: 50% | 157 views | 2d
0 community ratings: null thumbs up, null thumbs down
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): h
Tags: chandoo, chandoo.org, Excel, spreadsheets, Excel pivot tables, data analysis, Excel tips, Excel for beginners, tabular data, excel pivot table, excel pivot, excel crash course, how to add slicer in excel, pivot tables for beginners
More from Chandoo
- 20 AI Terms Explained in Plain English in 20 minutes 🕓 — Score: 50%
- Learn Advance Excel Formulas in an Hour - FREE Masterclass — Score: 50%
- 5 HR KPIs Every Analyst Needs to Master #HRAnalytics #KPIs — Score: 50%
- This simple Excel trick saves me hours on MIS reports 💡 — Score: 50%
- End to End Power Query Data Cleaning Masterclass [FREE Workbook] — Score: 50%
- Here is why I think Excel skills are still relevant in the age of AI — Score: 50%