3.2.6 Working with pivot tables

Pivot tables are a powerful feature in spreadsheet applications. They allow you to summarize and analyze large datasets quickly and easily by reorganizing and summarizing data.

How to create a PivotTable in Excel for Windows

1. Select the cells you want to create a PivotTable from.

Note:  Your data shouldn’t have any empty rows or columns. It must have only a single-row heading.

1. Select Insert > PivotTable.

1. Under Choose the data that you want to analyze, select Select a table or range.
   1. In Table/Range, verify the cell range.
   2. Under Choose where you want the PivotTable report to be placed, select New worksheet to place the PivotTable in a new worksheet or Existing worksheet and then select the location you want the PivotTable to appear.
   3. Select OK.