Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll

Intermediate Spreadsheets

Well done!

You have completed Intermediate Spreadsheets!

Sign up for Treehouse Back to Library

Pivot Tables

6:41 with Richard Tillies

In this video, we'll introduce you to pivot tables, a powerful tool used to summarize data.

Google Sheets Changes

  • To add a Pivot Table:
    Insert -> Pivot Table

"Select All" keyboard shortcut

  • Ctrl-A (PC)
  • Cmd-A (Mac)

Pivot Table

  • Summarizes data from a larger table or database using sums, averages, or other useful statistics.
  • Rearranges (or "pivots") data to bring attention to important information.
  • Consists of row and column headings, along with data values and filters.

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    Let's set the stage. 0:00
    You are the product manager for 0:00
    a retail chain with nearly 50 stores across 14 US states. 0:02
    We have six months of sales data for two products in particular, 0:05
    boxing gloves and hand wraps. 0:09
    In short, we have a lot of data. 0:12
    Can we organize it more efficiently? 0:15
    For example, it would be helpful to have totals by state or by quarter. 0:17
    The answer, of course, we can use a pivot table to summarize our data. 0:22
    What is a pivot table? 0:28

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up