Pivot Tables

​Pivot Tables

A PivotTable is a powerful tool to calculate, summarize, and analyze data that lets you see comparisons, patterns, and trends in your data.

Create a PivotTable

  1. Select the cells you want to create a PivotTable from.

    NOTE: Your data shouldn't have any empty rows or columns. It must have only a single-row heading.

  2. Select Insert > PivotTable

    PivotTable

  3. Under Choose the data that you want to analyze, select Select a table or range.

    CreatePivotTable

  4. In Table/Range, verify the cell range.

  5. Under Choose where you want the PivotTable report to be placed, select Newworksheet to place the PivotTable in a new worksheet.

  6. Select OK.

Building out your PivotTable

  1. To add a field to your PivotTable, select the field name checkbox in the PivotTables Fields pane.

    NOTE: Selected fields are added to their default areas: non-numeric fields are added to Rows, date and time hierarchies are added to Columns, and numeric fields are added to Values.

    PivotTableFields

  2. To move a field from one area to another, drag the field to the target area.