A. Finding Pivot Table Commands on the Ribbon

If you were accustomed to the PivotTable toolbar in Excel 97 through Excel 2003, you might be frustrated initially by the new Ribbon interface.

This appendix provides a map. If you know where a command was located in a legacy version Excel interface, the tables in this chapter help you find the command in the new interface.

Inserting a Pivot Table

In legacy versions of Excel, the entry point for creating a pivot table was always on the Data menu. After you selected PivotTable and PivotChart Report, you chose either a pivot table or pivot chart in the first step of the wizard.

Excel 2010 includes ...

Get Pivot Table Data Crunching: Microsoft 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.