Pivot Tables
Summarizing with PivotTables
The Ultimate Tool for Instant Data Analysis
Imagine you have 5,000 rows of sales data. If you want to know the total sales for each product, you could use complex formulas—or you could use a PivotTable. It "pivots" your data to show it from different angles, summarizing it instantly.
How a PivotTable Thinks
Building a PivotTable is just dragging and dropping fields into four main areas:
The items you want to list down the side (e.g., Product Names).
The numbers you want to calculate (e.g., Sum of Sales Amount).
Items to compare across the top (e.g., Months or Regions).
A master switch to show data for just one specific person or year.
Crucial Rule: The "Refresh" Button
Unlike standard formulas, PivotTables do not update automatically when you change your source data.
If you fix a sales figure in your main list, you must right-click anywhere inside your PivotTable and select Refresh to see the new totals.
📈 PivotCharts: Visual Analysis
A PivotChart is a chart connected directly to your PivotTable. If you use a filter to look at "Last Month," the chart will change its shape instantly to match. This is how professional business dashboards are built!
💡 Skill Eco Pro-Tip: Recommended PivotTables
Not sure where to start? Click a cell in your data and go to Insert > Recommended PivotTables. Excel will analyze your data and offer you 5 or 6 different "pre-built" summaries to choose from.