PivotTables

Use pivot tables in Excel for stronger data analysis. This Excel pivot table tutorial also helps you summarize data.

Pivoting data

One of the best things about PivotTables is that they can quickly pivot—or reorganize—data, allowing you to look at your worksheet data in different ways. Pivoting data can help you answer different questions and even experiment with the data to discover new trends and patterns.

In our example, we used the PivotTable to answer the question: What is the total amount sold by each salesperson? But now we'd like to answer a new question: What is the total amount sold in each month? We can do this by simply changing the field in the Rows area.

To change the row:

  1. Click, hold, and drag any existing fields out of the Rows area. The field will disappear.


    Screenshot of Excel 2013Removing a field
  2. Drag a new field from the Field List into the Rows area. In our example, we'll use the Month field.


    Screenshot of Excel 2013Adding a field
  3. The PivotTable will adjust—or pivot—to show the new data. In our example, it now shows the total order amount for each month.
    Screenshot of Excel 2013The updated PivotTable

To add columns:

So far, our PivotTable has only shown one column of data at a time. In order to show multiple columns, you'll need to add a field to the Columns area.

  1. Drag a field from the Field List into the Columns area. In our example, we'll use the Region field.
    Screenshot of Excel 2013Adding a field to the Column area
  2. The PivotTable will include multiple columns. In our example, there is now a column for each region.
    Screenshot of Excel 2013The PivotTable with columns