Page 689 - Excel 2013 All-in-One For Dummies

Creating Pivot Tables 671
1. Select a cell in the data list for which you want to create the new pivot
table.
Provided that the data list has a row of column headings with contiguous rows of data as described in Book VI, Chapter 1, this can be any cell in the table.
2. Click the Recommended PivotTables command button on Insert tab of the Ribbon or press Alt+NSP.
Excel displays a Recommended PivotTables dialog box similar to the one shown in Figure 2-3. This dialog box contains a list box on the left side that shows samples of all the suggested pivot tables that Excel 2013 can create from the data in your list.
3. Select the sample of the pivot table you want to create in the list box on the left and then select OK.
As soon as you select OK, Excel creates a new pivot table following the selected sample on its own worksheet inserted in front of the others in your workbook. This pivot table is selected on the new sheet so that the Pivot Table Fields task pane is displayed on the right side of the Excel worksheet window and the PivotTable Tools contextual tab is displayed on the Ribbon. You can use the options on this task pane and contextual tab to then cus- tomize your new pivot table as described in the “Formatting a Pivot Table” section later in this chapter.
Figure 2-3:
Creating a new pivot table from the sample pivot tables displayed in the Recom- mended PivotTables dialog box.
Book VII Chapter 2
Generating Pivot Tables