Pivot tables use the column headings of a spreadsheet to organize data in a table. Ideally, each column in the spreadsheet should identify a different type of data, such as the name of each salesperson, the sales region he or she works in, and the total amount of sales made, as shown in Figure 9-10.
Before you create a pivot table, you must create a spreadsheet where each column identifies a different set of data.
After you design a spreadsheet with multiple columns of data, follow these steps to create a pivot table:
1. Select the cells (including column labels) that you want to include in your pivot table.
2. Click the Insert tab.
3. Click the PivotTable icon in the Tables group.
The Create PivotTable dialog box appears, as shown in Figure 9-11.
Define the cells to use and a location to place your pivot table.
4. (Optional) Select the cells that contain the data you want to use in your pivot table.
You only need to follow Step 4 if you didn't select any cells in Step 1, or if you change your mind and want to select different cells than the ones chosen in Step 1.
5. Select one of the following radio buttons:
New Worksheet: Puts the pivot table on a new worksheet
Existing Worksheet: Puts the pivot table on an existing worksheet
6. Click OK.
Excel displays a PivotTable Field List pane, as shown in Figure 9-12.
7. Mark (select) one or more check boxes inside the PivotTable Field List pane.
Each time you select another check box, Excel modifies how data appears in your pivot table, as shown in Figure 9-13.
The PivotTable Field List pane lets you choose which data to display in the pivot
Adding column headings increases the information a pivot table displays.