O'Reilly logo

Microsoft® Office® Professional 2013 Plain & Simple by Katherine Murray

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating PivotTables

PivotTables are powerful tools that can help you analyze your data in a variety of ways and from a variety of perspectives. You specify to Excel 2013 how you want to display the data in the PivotTable and then—here’s the pivot part—you can easily change the data to display the information in different ways within the same table.

  1. Click a cell within the range that you want to summarize.

  2. Click the Insert tab.

  3. Click Recommended PivotTables.

  4. In the Recommended PivotTables dialog box that opens, click the PivotTable that you want to create.

  5. Click OK.

image with no caption

Tip

The great thing about adding a ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required