Excel Pivot Tables — Hub | Sheets & Cells
Home›Excel›Pivot Tables
ExcelHub

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.

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.

How-To Posts

Step-by-step tutorials for the most common pivot-table tasks.

Comparisons

Excel Wizard

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 →