Course Highlights
  • Add, import, manage, and format data using Google Sheets.
  • Filter, summarize, and protect data in Google Sheets.
  • Perform calculations and visualize your spreadsheet data.
  • Apply best practices to share and collaborate in Google Sheets.
Curriculum

2 Topics
Course introduction
Agenda

4 Topics
Introduction to Google Sheets
Activity 1 explained
Activity 1 Import an Excel spreadsheet to Google Sheets
Introduction to Google Sheets

4 Topics
Manage data using Google Sheets
Activity 2 explained
Activity 2 Manage data in Google Sheets
Manage data using Google Sheets

7 Topics
Format a Google Sheets spreadsheet
Format a Sheet
Cell types rows and columns
Activity 3 explained
Manage multiple sheets
Activity 3 Apply formatting to a Google Sheet
Format a Google Sheets spreadsheet

11 Topics
Basic formulas functions and charts
Basic functions
Activity 4 explained
Summarize data with charts
Create a chart
Import export date types and more
Activities 5 and 6 explained
Activity 4 Use formulas to perform calculations
Activity 5 Use named ranges
Activity 6 Create a chart
Basic formulas functions and charts

4 Topics
Share your Google Sheets spreadsheets
Activity 7 explained
Activity 7 Explore sharing options
Share your Google Sheets spreadsheets

5 Topics
Collaborate with Google Sheets
Activity 8 explained
Chat and Gmail integration
Activity 8 Comments and action items
Collaborate with Google Sheets

4 Topics
Business challenge overview
Business challenge explained
Wrap up
Activity 9 Business challenge

  Write a Review

Google Sheets

Go to Free Course