A PivotTable is the fastest way to turn thousands of rows into a summary report without a single formula. The source must be a proper data set (ideally an Excel Table, Ctrl+T, so new rows are picked up on refresh).
Creating one
- Click inside the data → Insert → PivotTable.
- Drag fields into the areas: Rows, Columns, Values, Filters.
- In Values choose the calculation: sum, count, average, max…
- A one-dimensional pivot has only rows; a two-dimensional one has rows and columns.
- Drill down — double-click a total to open a sheet with the source records.
- A PivotTable doesn’t recalculate by itself: Analyze → Refresh (Alt+F5).
Build a PivotTable in the builder below and answer the questions using its data.