Google Sheets: Analyzing Data with Tables & Charts

Expected Duration
Lesson Objectives
Course Number
Expertise Level


Analyze data efficiently using the built-in features of Google Sheets. In this course, you will discover how to analyze your data with pivot tables and charts.
Learn how to work with pivot tables, including formatting, sorting, filtering, adding calculated fields, and copying and exporting pivot tables.
Another alternative to visually display your data is to use the built-in chart features in Google Sheets. Learn how to create and insert charts in your document.

Expected Duration (hours)

Lesson Objectives

Google Sheets: Analyzing Data with Tables & Charts

  • create a pivot table to analyze your data
  • add, edit and customize data values in a pivot table
  • sort and filter values in a pivot table
  • add, edit and customize a calculated field in a pivot table
  • copy and download a pivot table
  • use suggestions to create charts and pivot charts
  • insert a chart
  • customize a chart
  • customize a chart's axes
  • Course Number:

    Expertise Level