11 STEPS
Simple steps in creating a pivot table using Google Spreadsheets shared on iorad with step-by-step instructions:
1
The first step is to open a Google Sheet with your data and Click Data
2
Click Pivot table...
3
For this example, we'll keep it simple by using just Rows & Values.
Click Add next to Rows
Click Add next to Rows
4
Depending on your data, you will have different dropdown options.
For this example, Click Category
For this example, Click Category
5
Let's use Values to show a summary of Values in each Category.
Click Add next to Values
Click Add next to Values
6
We want to see the Amount Column from the spreadsheet.
Click Amount in the dropdown.
Click Amount in the dropdown.
7
Let's see what the average is in one column.
We'll click the dropdown arrow.
We'll click the dropdown arrow.
8
Then we'll Click AVERAGE
9
Let's also add another column to include the Sum for each category.
We'll Click Add next to Values again.
We'll Click Add next to Values again.
10
Again, Click Amount.
It will default to SUM, so you are set!
It will default to SUM, so you are set!
11
That's it. You're done.