Microsoft Office Tutorials and References
In Depth Information
Data Analysis with Pivot Tables
Pivot tables by recommendation
If creating a new pivot table with the Quick Analysis tool (described in the
previous section) is too much work for you, you generate them in a snap with
the new Recommended Pivot Tables command button. To use this method,
follow these easy steps:
1. Select a cell in the data list for which you want to create the new pivot
Provided that your data list has a row of column headings with
contiguous rows of data as described in Chapter 11, this can be any cell in the
2. Select 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 9-3. This dialog box contains a list box on the left
side that showing 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 click OK.
As soon as you click OK, Excel creates a new pivot table following the
selected sample on its own worksheet (Sheet1) 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
customize your new pivot table as described in the “Formatting Pivot Tables”
and “Modifying Pivot Tables” sections later in this chapter.
Manually producing pivot tables
Sometimes, none of the pivot tables that Excel 2013 suggests when creating
a new table with the Quick Analysis tool or the Recommended PivotTables
command button fit the type of data summary you have in mind. In such
cases, you can either select the suggested pivot table whose layout is closest
to what you have in mind, or you can choose to create the pivot table from
scratch (a process that isn’t all that difficult or time consuming).
To manually create a new pivot table from the worksheet with the data to
be analyzed, position the cell pointer somewhere in the cells of this list, and
then click the PivotTable command button on the Ribbon’s Insert tab or