Google Sheets

Overview

This course introduces you to Google Sheets, Google’s cloud-based spreadsheet tool included in Google Workspace. You will learn how to create spreadsheets, import data, manage and format information, work with formulas and functions, create charts, and collaborate with others in real time. The course also covers sharing options, version tracking, and collaboration features such as comments, action items, and notifications.

Syllabus

Course introduction

• Course introduction
• Agenda

Introduction to Google Sheets

• Introduction to Google Sheets
• Activity 1 explained
• Activity 1: Import an Excel spreadsheet to Google Sheets
• Quiz

Manage data using Google Sheets

• Manage data using Google Sheets
• Activity 2 explained
• Activity 2: Manage data in Google Sheets
• Quiz

Format a Google Sheets spreadsheet

• Format a Google Sheets spreadsheet
• Format a Sheet
• Cell types, rows, and columns
• Activity 3 explained
• Activity 3: Apply formatting to a Google Sheet
• Manage multiple sheets
• Quiz

Basic formulas, functions, and charts

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

Share your Google Sheets spreadsheets

• Share your Google Sheets spreadsheets
• Activity 7 explained
• Activity 7: Explore sharing options
• Quiz

Collaborate with Google Sheets

• Collaborate with Google Sheets
• Activity 8 explained
• Activity 8: Comments and action items
• Chat and Gmail integration
• Quiz

Business challenge

• Business challenge overview
• Business challenge explained
• Activity 9: Business challenge

Wrap up

• Your Next Steps
• Course Badge