Excel pivot tables in 15 minutes
Written by LitCareer · 12 Oct 2026 · 2 min read
Summarise thousands of rows by month, region or product with a few clicks, and the common mistakes to avoid.
What a pivot table does
A pivot table summarises a large table of data without formulas. In seconds you can answer questions like "total sales by region and month" or "number of complaints by product".
Prepare your data first
- One header row with a unique name for each column.
- No blank rows or merged cells.
- Each row is one record, such as one order or one employee.
- Convert the range to a table (Ctrl+T) so new rows are included automatically.
Build your first pivot table
- Click anywhere in the data and choose Insert → PivotTable.
- Drag a category, such as Region, into Rows.
- Drag a number, such as Sales Amount, into Values. It will sum by default.
- Drag another category, such as Month, into Columns for a cross-table.
- Drag a field like Product Category into Filters to filter the whole report.
Useful tricks
- Change the calculation: right-click a value → Summarize Values By → Count, Average, Max.
- Show as percentage: Show Values As → % of Grand Total.
- Group dates by month, quarter or year: right-click a date → Group.
- Slicers: Insert → Slicer for clickable filter buttons.
- Pivot charts: turn the summary into a chart with one click.
- Refresh after the source data changes (Data → Refresh All).
Common mistakes
- Numbers stored as text, which are counted instead of summed. Convert them to numbers.
- Forgetting to refresh after adding data.
- Using a fixed range so new rows are missed; use a table instead.
Practise
Take a sales or attendance sheet and answer five questions with pivot tables in under 15 minutes.
Your next steps
- Clean data into one header row with no blanks
- Use a table (Ctrl+T) as the source
- Group dates by month and add slicers
- Remember to refresh after data changes
General guidance for learning, not professional, legal or financial advice. Want help for your own situation? Book 1:1 career help.


