Analyzing Data with Tables & Charts in Google Sheets 2020


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

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)
0.7

Lesson Objectives

Analyzing Data with Tables & Charts in Google Sheets 2020

  • 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:
    ds_gshee20_11_enus

    Expertise Level
    Expert