Google Sheets Essential Training
Illustration by Neil Webb

Using pivot tables


Google Sheets Essential Training

with Sally Norred

Video: Using pivot tables

A pivot table report in Google sheets is a dynamic tool you can use to A new sheet named Pivot Table 1 will open in your spreadsheet document.
Expand all | Collapse all
  1. 4m 44s
    1. Welcome
    2. Importing exercise files to Google Sheets
      1m 29s
    3. What's new in Google Sheets
      2m 29s
  2. 14m 44s
    1. What is Google Sheets?
      2m 31s
    2. Accessing Google Sheets with your account
      2m 3s
    3. Understanding common Google Sheets terminology
      4m 17s
    4. Navigating Google Sheets
      5m 53s
  3. 22m 15s
    1. Creating, naming, and saving a spreadsheet
      3m 28s
    2. Renaming a spreadsheet
      1m 59s
    3. Copying a spreadsheet
      3m 9s
    4. Moving a spreadsheet
      3m 10s
    5. Deleting a spreadsheet
      2m 15s
    6. Importing and converting Excel or OpenOffice spreadsheets
      4m 20s
    7. Importing and converting .csv, .tsv, .tab, and .txt data files
      3m 54s
  4. 28m 46s
    1. Entering and editing cell content
      4m 2s
    2. Inserting, deleting, and clearing rows and columns
      3m 26s
    3. Moving rows, columns, and cells
      2m 25s
    4. Working with multiple sheets
      4m 14s
    5. Using keyboard shortcuts
      3m 43s
    6. Creating a series of numbers or dates
      3m 13s
    7. Using Find and Replace
      2m 30s
    8. Entering hyperlinks
      1m 58s
    9. Inserting images into spreadsheets
      3m 15s
  5. 14m 31s
    1. Using the View menu
      3m 2s
    2. Freezing rows and columns
      1m 58s
    3. Hiding rows, columns, and sheets
      3m 45s
    4. Publishing a spreadsheet to the web
      3m 6s
    5. Printing a spreadsheet
      2m 40s
  6. 18m 46s
    1. Formatting cell, row, and column data
      6m 6s
    2. Google Sheets formatting tips
      3m 35s
    3. Using conditional formatting
      5m 6s
    4. Creating a spreadsheet from a template
      3m 59s
  7. 36m 12s
    1. Sorting data on a spreadsheet
      3m 37s
    2. Using Quick Sum
      3m 14s
    3. Using formulas and functions
      6m 23s
    4. Using IF functions and nested functions
      4m 33s
    5. Referencing data from other sheets
      3m 43s
    6. Creating charts in Google Sheets
      5m 28s
    7. Using filters and creating filter views
      4m 55s
    8. Using pivot tables
      4m 19s
  8. 20m 37s
    1. Sharing a spreadsheet file with other people
      5m 40s
    2. Working with Google Sheets that are shared with you
      4m 19s
    3. Working with spreadsheet revisions
      3m 2s
    4. Commenting on a spreadsheet
      3m 26s
    5. Emailing spreadsheet collaborators
      1m 47s
    6. Collaborating simultaneously and using Google Chat
      2m 23s
  9. 8m 54s
    1. Installing the Google Sheets mobile app
      2m 3s
    2. Navigating the Google Sheets mobile app
      3m 21s
    3. Working with spreadsheets on the Google Sheets mobile app
      3m 30s
  10. 47s
    1. Helpful resources

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now
please wait ...
Watch the Online Video Course Google Sheets Essential Training
2h 50m Appropriate for all Aug 26, 2014

Viewers: in countries Watching now:

Google Sheets is a feature-rich, cloud-based spreadsheet application that allows you to format and analyze all kinds of data. In this course, author Sally Norred shows you how to get the most from Google Sheets. Discover how to get around the interface, enter and work with data, and use formatting and function features, and learn smart ways to make your data work for you. Plus, see how to work with your spreadsheet data on the go with the Google Sheets mobile app.

Topics include:
  • Navigating Google Sheets
  • Creating, naming, and saving spreadsheets
  • Importing files
  • Converting other file formats such as Microsoft Excel to Google Sheets
  • Editing cells
  • Inserting, deleting, and moving rows and columns
  • Adding hyperlinks and images
  • Formatting data
  • Using formulas and functions
  • Sharing spreadsheets
  • Using the Google Sheets mobile app
Sally Norred

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 report editor tool available on the right hand side of the screen. The sheet that is displayed contains an empty pivot table report for your spreadsheet. You can rename the tab if you like.

I'll rename mine sales pivot table. In the report editor, select the fields that you'd like to have up here in the rows, columns, values or filter categories of your pivot table report. I'd like the date to appear in the rows, and the item type to appear in the columns. I'd also like the amount to appear for the values. You're pivot table report will automatically add the values of each row and column into a grand total. Grand Total summaries will appear at the right, and to the bottom of your pivot table report. Now I can easily see how many chargers, lightbulbs and panels were sold on each of the dates in March, and I can also see the total of all items sold on each date, under Grand Total here.

Furthermore, I can see the total amount of chargers, light bulbs and panels sold in the month of March, along the bottom, as well as the grand total of all items sold, in the bottom right corner. If I want to adjust how data is arranged in the table, I can drag fields to a different category. I'll change this table so that the date is in the columns and the item type is listed in the rows by clicking and dragging their fields in the Report Editor. I can remove a field from my report by clicking the x in the top right of the field.

I'll remove the Amounts field and replace it with the Price field, then I'll change the price to summarize the average price here. Now I can see the average price for each item and the average price for an item sold by date. We can also add a filter to the pivot table report, to view that report editor again, I'll click anywhere in the pivot table. I'll scroll down to add a filter, and I'll click add field. I'll filter on date here, and I'll select only those dates in the first week of March 2014, and click okay.

Now we only see information about those items sold in the first week of March 2014. And there's a couple things that are important to understand about pivot tables. First, notice that you can't edit the cell values by manually typing new values or by changing formulas in the pivot table report, It's not editable. Also you can create multiple pivot table reports from the same set of data. Simply go back to the data source, and create a new pivot table report.

It will create a new pivot table report on a separate sheet, and it won't overwrite previously created pivot tables. Pivot tables created in Microsoft Excel can be uploaded and converted to Google Sheets. And pivot table reports created in Google Sheets can be downloaded and converted to Microsoft Excel format. If you'd like to analyze and interpret your spreadsheet data without creating a bunch of formulas, give pivot tables a try. Pivot table reports can often get you the information you need without taking up a lot of time.

There are currently no FAQs about Google Sheets Essential Training.

Share a link to this course

What are exercise files?

Exercise files are the same files the author uses in the course. Save time by downloading the author's files instead of setting up your own files, and learn by following along with the instructor.

Can I take this course without the exercise files?

Yes! If you decide you would like the exercise files later, you can upgrade to a premium account any time.

Become a member Download sample files See plans and pricing

Please wait... please wait ...
Upgrade to get access to exercise files.

Exercise files video

How to use exercise files.

Learn by watching, listening, and doing, Exercise files are the same files the author uses in the course, so you can download them and follow along Premium memberships include access to all exercise files in the library.

Exercise files

Exercise files video

How to use exercise files.

For additional information on downloading and using exercise files, watch our instructional video or read the instructions in the FAQ .

This course includes free exercise files, so you can practice while you watch the course. To access all the exercise files in our library, become a Premium Member.

* Estimated file size

Are you sure you want to mark all the videos in this course as unwatched?

This will not affect your course history, your reports, or your certificates of completion for this course.

Mark all as unwatched Cancel


You have completed Google Sheets Essential Training.

Return to your organization's learning portal to continue training, or close this page.

Become a member to add this course to a playlist

Join today and get unlimited access to the entire library of video courses—and create as many playlists as you like.

Get started

Already a member ?

Exercise files

Learn by watching, listening, and doing! Exercise files are the same files the author uses in the course, so you can download them and follow along. Exercise files are available with all Premium memberships. Learn more

Get started

Already a Premium member?

Exercise files video

How to use exercise files.

Ask a question

Thanks for contacting us.
You’ll hear from our Customer Service team within 24 hours.

Please enter the text shown below:

The classic layout automatically defaults to the latest Flash Player.

To choose a different player, hold the cursor over your name at the top right of any page and choose Site preferences from the dropdown menu.

Continue to classic layout Stay on new layout
Exercise files

Access exercise files from a button right under the course name.

Mark videos as unwatched

Remove icons showing you already watched videos if you want to start over.

Control your viewing experience

Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.

Interactive transcripts

Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.

Learn more, save more. Upgrade today!

Get our Annual Premium Membership at our best savings yet.

Upgrade to our Annual Premium Membership today and get even more value from your subscription:

“In a way, I feel like you are rooting for me. Like you are really invested in my experience, and want me to get as much out of these courses as possible this is the best place to start on your journey to learning new material.”— Nadine H.

Thanks for signing up.

We’ll send you a confirmation email shortly.

Sign up and receive emails about and our online training library:

Here’s our privacy policy with more details about how we handle your information.

Keep up with news, tips, and latest courses with emails from

Sign up and receive emails about and our online training library:

Here’s our privacy policy with more details about how we handle your information.

submit Lightbox submit clicked
Terms and conditions of use

We've updated our terms and conditions (now called terms of service).Go
Review and accept our updated terms of service.