Pivot Table Data Crunching for Microsoft® Office Excel® 2007

Appendix A. Finding Pivot Table Commands on the Ribbon

<feature><title>In This Chapter</title>

• Inserting a Pivot Table 315

• Finding Commands from the Legacy PivotTable Toolbar 316

</feature>

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

This appendix provides a map. If you know where a command used to be in the legacy Excel interface, the tables in this chapter help you find the command in the new interface.

Inserting a Pivot Table

In previous 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. ...