• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 20. Analyzing Data: PivotTables! > Manipulating and Analyzing PivotTabl...

Manipulating and Analyzing PivotTables

Half the fun of working with PivotTables lies in the way you can quickly manipulate them to show different data. You can not only rearrange data, but you can create new fields, change how fields are grouped, and so on. By creating new fields and rearranging data, you gain a larger understanding of the data and can make better strategic decisions based on what you learn from the different views of the data. In the following sections you learn several methods for changing your PivotTables.

Using the PivotTable Toolbar

To control PivotTables easily, use the PivotTable toolbar shown in Figure 20.12. After you build a PivotTable, the PivotTable toolbar should automatically be visible. If it doesn't appear on-screen, right-click inside the toolbar area and select PivotTable. Table 20.2 shows you what each PivotTable toolbar button does.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint