A pivot table allows you to extract the significance from a large, detailed data set. For this reason, pivot tables are one of Excel’s most powerful features. To insert a standard pivot table in Excel 2013 follow the steps outlined below.
- Click anywhere in the data you want to analyse
- Select Insert (tab) | Tables (group) | Recommended PivotTables (button)
- A list of Recommended PivotTables will appear. Select the picture in the left box to preview the Pivot Table on the right
- Select OK to insert the chosen PivotTable into your document