A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.
To create a PivotTable:
- Select the cells want to create the PivotTable from, or select only one cell to include the whole sheet.
- Windows: Under the "Insert" menu click "PivotTable"; Mac: Go to Data Tab>PivotTable>Create Manual PivotTable
- In the pop-up box:
- Select the table or range - this will be based on the cells indicated at step 1 above, but could be modified.
- Choose where you want the Pivot Table to be placed. It is highly recommended that you select a New Worksheet to place the PivotTable in a new sheet.
- Click OK.