How to Make a Simple Pivot Table

Pivot Table is a very useful tool and will transfer your data to a simple way. Please see the steps below to make a simple Pivot Table (click here download sample data):

Step 1: Click anywhere in the dataset (note: please download here for practice);

Step 2: Click "Insert" from Ribbon, then click "PivotTable" command;

Step 3: Excel will automatically select the whole dataset where your cursor is. The default location for the new Pivot Table report will be placed in a new worksheet;

Alternatively, you can change the location to the "Existing Worksheet", but you will need to move your mouse out of the dataset (click any cell that is not in the dataset);

Step 4: Click "OK" at the bottom and you will have a new Pivot Table in the New Worksheet, but it is now blank (your mouse in default should be located in the top-left cell of the Pivot Table);

Step 5: Drag "Region" to the Row Labels box and "Salary" to the Values box;

Step 6: You will get a simple Pivot table similar to the one below.

Step 7: You can add more columns by adding "Gender" to the Column Labels box.

Leave a Reply