How to create a pivot table

A pivot table is a helpful way to analyze and visualize data. To create a pivot table, follow these steps: 

1. Navigate to Insert > Pivot table.

2. In the pivot table editor, add your chosen row and column values.

3. Next to Values, click Add, and select your desired value from the dropdown menu (you could also choose from one of the suggested pivot table options).

In the example here, I created a faux data set and used a pivot table to show the average training scores of each department.