Loopskey-logo
Back to content
CourseTechnology

Pivot Tables in Google Sheets

By External Provider

Price

Free

Go to content

Opens coursera.org in a new tab

Level

INTERMEDIATE

Duration

30 min

About this course

This is a self-paced lab that takes place in the Google Cloud console. Create pivot tables to quickly summarize large amounts of data and reference data using named ranges. Use functions and formulas to calculate descriptive statistics.

What you will learn

  • Apply formatting to cells, rows, and columns.
  • Calculate descriptive statistics like AVERAGE, MEDIAN, and MODE.
  • Create a pivot table and reference data by using named ranges.
  • Use collaboration features in Sheets.