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.

Excel pivot tables in 15 minutes

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

Build your first pivot table

  1. Click anywhere in the data and choose Insert → PivotTable.
  2. Drag a category, such as Region, into Rows.
  3. Drag a number, such as Sales Amount, into Values. It will sum by default.
  4. Drag another category, such as Month, into Columns for a cross-table.
  5. Drag a field like Product Category into Filters to filter the whole report.

Useful tricks

Common mistakes

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.

More in Digital & tech skills

Keep learning