How To Create A Google Sheets Pivot Table
Let me start by saying what a delight it is to create a pivot table in Google Sheets. Right away, you’ll notice how clean and simple the process feels. It’s natural. It has that signature Google je ne sais quoi.
It’s different when you create a pivot table in Excel. Which, even if you’ve done it a thousand times, feels like it was designed by a surly robot. Not a laid back, easy-going robot. One who likes to watch people suffer as they organize simple data for their boss.
Luckily, Google has made pivot tables approachable and easy to use. But, if you’re reading this article, you’re probably still not sure how to create one in Google Sheets.
So, without further ado…
Here’s how to create a Google Sheets pivot table.
Step 1 Prepare your data
Enter the data you plan on sorting into Google Sheets.
Step 2 Click data, pivot table
Find the pivot table option under the data menu, click it.
Step 3 Add Fields
A new tab will be created that contains your pivot table. Select the fields that you would like to be displayed within your pivot table.
Step 4 Experiment With Your Fields
Now that you know how to insert your pivot table, experiment with sorting your data. The way you do this will depend on your objectives.
So there you have it. That’s how you create a Google Sheets pivot table. Pretty simple, if you ask me. Check back soon for more in-depth advice on what you can do with your Google Sheets pivot tables, now that you know how to create them.