When Should You Use a PivotTable?
PivotTables have several advantages over other worksheet models. Using the PivotTable Wizard, it's easy to create a PivotTable that summarizes all or part of a list in dozens of dif ferent ways. Trying to accomplish the same task by entering formulas manually would take days. Also, because PivotTables and PivotCharts do not change your existing data or its arrangement on the worksheet, you can freely experiment with different PivotTable layouts. Use the Undo button to roll back any changes you make in a PivotTable layout. If you want to start over, you can delete the PivotTable page and run the wizard again.
PivotTables are the correct choice when all your data is in a list or in an external database you can ...
Get Special Edition Using Microsoft® Office XP now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
