A pivot table turns raw rows into a summary report — no formulas required. Drag fields into rows, columns, and values to slice the data.
Do it with AI insteadSelect the data
Click any cell inside your table so Excel detects the full range.
Insert the pivot table
Go to Insert ▸ PivotTable and choose New Worksheet.
Drag fields
Drop a category into Rows and a number into Values. Excel sums it automatically.
Refine the summary
Add a Columns field or a Filter, or right-click a value to change Sum to Average/Count.
Pivot tables cache data — right-click and choose Refresh after the source changes.