Course contents · PivotTables

Creating a PivotTable

Open the practice in the trainer →

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

  1. Click inside the data → Insert → PivotTable.
  2. Drag fields into the areas: Rows, Columns, Values, Filters.
  3. In Values choose the calculation: sum, count, average, max…

Build a PivotTable in the builder below and answer the questions using its data.

Check yourself

  1. The source data changed. What do you do with the PivotTable?
  2. What happens when you double-click a total in a PivotTable?