PivotTables summarise large amounts of Excel data from a database that is formatted where the first row contains headings and the other rows contain categories or values. The way the data is summarised is flexible but usually the Pivot Table will contain values summed over some or all of the categories.
If you’re new to creating PivotTables, Excel 2013 can analyze your data and recommend a PivotTable for you. Once you’re comfortable with PivotTables you can start from scratch and create your own.
To create a Pivot Table, make sure your data has column headings or table headers and that there are no blank rows. Click any cell in the range of cells or table.
INSERT > Tables > Recommended PivotTables
In the Recommended PivotTables dialogue box that launched, click any Pivot Table layout to get a preview then select the one that works best for you and click OK.
Excel will provide a selection of recommended PivotTables for your data. Excel then places the PivotTable on a new worksheet and shows the field list so that you can rearrange the data to best suit your needs. Again, make sure your data has column headings or table headers and no blank rowsShare