Insert a Pivot Table in Excel

Question

How to insert a pivot table in Excel?

Answer

1. When the data is ready, place the cursor anywhere in the data.
2. Then, on the Insert tab, in the Tables group, click PivotTable. The Create PivotTable dialog box opens.
3. A table or range is already selected for you. The Table/Range box shows the range of the selected data.  
4. New Worksheet is also selected for you as the place where the report will be placed (you can click Existing Worksheet if you don't want the report placed in a new worksheet). Click OK.  
5. When you first create your pivot table you should see two different tables.  The first is the Pivot Table.  The Pivot Table will appear on the left side of your screen.  The second is the Pivot Table Field List. This will appear on the right side of your screen.                                

Notice that PivotTable Tools appear on the Ribbon, including the Analyze and Design tabs.

For more information about Pivot Tables in Excel, please view the full tutorial from the CTL here: Excel Part 4

If you need further assistance, please click the CTL Support Request button on this page