These instructions are for creating a pivot table in Excel 2013. For Excel 2010 / 2007 instructions, click here.
This tutorial will give you a quick overview of creating a pivot table. For a more detailed tutorial, go to the How to Plan and Set Up a Pivot Table page.
Before you create a pivot table, organize your data into rows and columns, and create an Excel Table. There are instructions here.
In this example the source data contains information about food sales, in two regions.
After your source data is prepared, you can create a pivot table. We'll see which pivot table layouts are suggested by Excel.
A pivot table is created in your workbook, on a new sheet, in the layout that you selected. When you select a cell within the pivot table, a PivotTable Field List appears, at the right of the worksheet.
You can change the layout of the pivot table, after it's been created. We'll add the TotalPrice field to the pivot table.
Click here to see a completed version of a pivot table based on insurance policy data.
The pivot table demonstration is interactive, so you can use the Report Filters, at the top of the pivot table, to limit the amount of data that is being summarized.
Click here to download the zipped sample file
To see the steps for creating a pivot table in Excel 2013, please watch this short video.
Last updated: March 22, 2017 11:17 AM