Creating a Pivot Table

Step 1

Select the Data you wish to turn into a Pivot Table

Screen Shot 2022-03-22 at 12.07.56 PM.png


Step 2

Go to Insert > Pivot Table

Screen Shot 2022-03-22 at 12.08.11 PM.png


Step 3

Select whether you want to open the Pivot Table in your current Sheet, or a new Sheet

Screen Shot 2022-03-22 at 12.08.18 PM.png


Step 4

Move your Pivot Table fields to your desired Filters, Columns, Rows, and Values

Screen Shot 2022-03-22 at 12.09.34 PM.png


Step 5

After adding the fields, your Pivot Table will be created

Screen Shot 2022-03-22 at 2.00.12 PM.png