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

As you highlight each PivotTable button in the options palette, Excel’s Live Preview feature displays a thumbnail of a pivot table that can be created using your table data. This thumbnail appears above the Quick Analysis options palette for as long as the mouse or Touch pointer is over its corresponding button.
5. When a preview of the pivot table you want to create appears, click its button in the Quick Analysis options palette to create it.
Excel 2013 then creates the previewed pivot table on a new worksheet that is inserted at the beginning of the current workbook. This new work- sheet containing the pivot table is active so that you can immediately rename and relocate the sheet as well as edit the new pivot table, if you wish.
Figures 2-1 and 2-2 show you how this procedure works. In Figure 2-1, I’ve highlighted the third suggested PivotTable button in the Quick Analysis tool’s option palette. The previewed table in the thumbnail displayed above the palette shows the salaries subtotals and grand totals in the Employee Data list organized whether or not the employees participate in profit sharing (Yes or No).
Creating Pivot Tables 669
Figure 2-1:
Previewing the pivot table created from the selected data in
the Quick Analysis options palette.
Book VII Chapter 2
Generating Pivot Tables