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® Excel® 2010 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.