Microsoft Office Tutorials and References
In Depth Information
There are two ways to get pivot tables in Excel 2011. You can either get the Pivot-
Table in the Data ribbon or under the Data menu. See Figure 26.17.
Once you activate the PivotTable it will be inserted by default on a new sheet.
See Figure 26.18.
In our example, as shown above, we will move the Gender field to the Row
Labels area on the left and the Job field to the Column Labels at the top. With Excel
2011 we drag and drop the fields to the appropriate areas in the Pivot Table Builder.
Drag the Gender field to the Row Labels area at the bottom of the Pivot Table Builder
and the Job field to the Column Labels. See Figure 26.19.
The other difference from the other features of the Pivot Table for Excel 2011 is
the way you make changes to the table itself. To complete the example in this chapter
I will drag the Values area in the Pivot Table Builder. The values will be calculated by
default as Sums. See Figure 26.20.
FIGURE 26.16 The PivotTable in Excel 2003 Is under the Data Menu
FIGURE 26.17 The PivotTable in Excel 2011 Is within the Data Ribbon or under the Data