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

Chapter 9. Advanced Data Analysis and Macros > Working with the DataPilot

Working with the DataPilot

When you work with large spreadsheets, where the amount of data seems overwhelming, or with spreadsheets where you want to quickly rearrange how the data is displayed or summarized, you can use the DataPilot to create a pivot table. The DataPilot's table cross-tabulates the information into rows and columns, making it easy for you to quickly analyze the data.

Since you can manipulate a DataPilot table even after you've created it, you can view your data in different ways without creating different tables from scratch. The DataPilot table derives its data from your original spreadsheet, so if you delete the DataPilot table, you aren't affecting the original spreadsheet at all.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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