How to Use Pivot Tables in Google Sheets


show more Using pivot tables provides you with in-depth training on Business. Taught by Sally Norred as part of the Google Sheets Essential Training show less
please wait ...

Using pivot tables

A pivot table report in Google sheets is a dynamic tool you can use to interpret the data in your spreadsheet without ever having to enter a formula. Pivot table reports give you a quick way of analyzing a large amount of spread sheet data. Let's look at how to create and use a pivot table report in a Google Sheet spreadsheet. I'll show you how it works in this solar products sales spreadsheet. You'll notice that I've organized my data into columns. It's best to organize your data into columns for pivot tables because column headers will become the fields that you add into your pivot table report.

Once you've opened your spreadsheet, you don't even have to pick a range of cells to add to your pivot table. Google Sheets will automatically detect a range of cells for your pivot table. You can always edit the data range at any point. Start by clicking the data menu and selecting pivot table report. A new sheet named Pivot Table 1 will open in your spreadsheet document. With a ...

Using pivot tables
Video duration: 4m 19s 2h 50m Appropriate for all

Viewers:

Using pivot tables provides you with in-depth training on Business. Taught by Sally Norred as part of the Google Sheets Essential Training

Subject:
Business
Software:
Sheets
Author:
please wait ...