Home > Sample chapters > Microsoft Office > Excel

Analyzing Your Excel 2013 Data

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.

Create a recommended PivotTable

  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.

    httpatomoreillycomsourcemspimages1532057.jpg

Create a PivotTable

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

  2. Click the Insert tab.

  3. Click PivotTable.

  4. Verify that the proper data range appears in the Table/Range box.

  5. Click OK.

  6. Drag a field to the Values area.

  7. Drag other field headers to the Rows and Columns areas, as needed.

    httpatomoreillycomsourcemspimages1532059.jpg
    httpatomoreillycomsourcemspimages1532061.jpg