Excel Pivot Tables
Pivot tables are the single most powerful data-analysis feature in Excel. Drag-and-drop summaries, filters, groupings, and calculated fields — no formulas required. This hub links every guide, sub-guide, and how-to post for mastering them.
What's on this page
Complete Guide
Start here. One comprehensive pillar covering the full lifecycle of a pivot table — from creation through refreshing, calculations, formatting, slicers, and troubleshooting.
Sub-Guides
Focused deep-dives into specific pivot-table skills. Each builds on the pillar.
Getting Started with Pivot Tables
First pivot table in under 5 minutes — source data rules, Insert PivotTable dialog, dragging fields into Rows/Columns/Values/Filters, and understanding what Excel is doing under the hood.
Sub-GuidePivot Table Calculations
Summarize by (Sum, Count, Average, Max, Min, Product), Show Values As (% of Total, Running Total, Difference From, Rank), and Calculated Fields vs Calculated Items.
Sub-GuidePivot Table Formatting
Report layouts (Compact, Outline, Tabular), subtotals and grand totals, number formats that stick, banded rows, custom PivotTable styles, and preserving formatting after refresh.
Sub-GuidePivot Table Slicers & Timelines
Click-to-filter slicers, timelines for date fields, connecting one slicer to multiple pivots, slicer styling, and dashboard patterns built around them.
Sub-GuidePivot Table Troubleshooting
Why your data isn't refreshing, "cannot overlap" errors, blank values showing, numbers formatted as text, missing fields, broken source ranges, and field name conflicts.
How-To Posts
Step-by-step tutorials for the most common pivot-table tasks.
Comparisons
Related Clusters
Pivot tables, built from plain English
Describe what you want to see ("sales by region by quarter, with % of total") and Excel Wizard creates the pivot table, applies the calculations, and formats it — no dragging required.
Install Excel Wizard →