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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.