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

Creating a PivotTable

To create a PivotTable from an existing list, start with Excel's PivotTable Wizard. In this simple three-step process, Excel prompts you for basic details about the PivotTable you want to create, including the location of the data source and where you want the PivotTable to appear. After you finish with the wizard, you'll be able to lay out your data directly on the worksheet.

Note

The capability to create and edit a PivotTable layout directly on the sheet is an enormous improvement over the same feature in earlier versions of Excel, which required that you edit PivotTable layouts in a dialog box. On slow machines or with extremely large lists, you may prefer to use this older technique, because it doesn't actually begin rearranging data until you click OK. To open the Layout dialog box, click the Layout button in Step 3 of the PivotTable and PivotChart Wizard.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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