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

Part V: Analyzing the Worksheet > Using the Power of Pivot Tables

Chapter 27. Using the Power of Pivot Tables

  • Summarize data in a pivot table

    One of the most useful tools Excel provides for the analysis and summary of data is the pivot table.

  • Filter data in a pivot table with a page field

    Pivot tables allow you to filter data so that you can narrow your view of the data.

  • Create a chart from a pivot table

    Once you create your pivot table, you can easily generate a chart from the data displayed.

Pivot tables enable you to analyze data in lists and tables. Pivot tables do more than just group and summarize data; they add depth to the data. In creating a pivot table, you tell Excel which of the fields (in the list) are to be arranged in rows and columns. You can also designate a page field that seems to arrange items in a stack of pages. You can rearrange the position of pivot table fields in a split second—in effect, twisting the data around. (That's where the word pivot comes in.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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