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

Hour 18. Working with Pivot Tables > Building a Pivot Table

Building a Pivot Table

You can build a simple pivot table with the Data, PivotTable and PivotChart Report option, which displays a series of PivotTable Wizard dialog boxes. The wizard steps you through the process of creating a pivot table, and you get to see a basic breakdown of the data you have in your Excel list or database. A diagram with the labels PAGE, COLUMN, ROW, and DATA appears, and you just drag field buttons onto the diagram. This step tells Excel about the data you want to analyze with a pivot table.

Perform the steps in the following To Do exercise to create a pivot table from an Excel list. Get ready to use the Data Analysis workbook you used in Hour 17, “Analyzing Your Data.”


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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