Creating a PivotTable

To create a PivotTable from an existing table or list, select a cell in that table or list and click PivotTable, in the Tables group of the Insert tab. Excel prompts you for basic details about the PivotTable you want to create, including the location of the data source and where you want the PivotTable to appear (see Figure 15.29). Then it creates a blank layout and a Field List task pane for you (see Figure 15.24). To fill out the table, drag field headings to the layout or to the boxes at the bottom of the task pane.

Figure 15.29. Select a range or an external data source for your PivotTable.