Course Introduction-Course introduction
Course introduction
()
Agenda
()
Introduction to Google Sheets-Introduction to Google Sheets
Introduction to Google Sheets
()
Activity 1 explained
()
Activity 1 Import an Excel spreadsheet to Google Sheets
Manage data using Google Sheets-Manage data using Google Sheets
Manage data using Google Sheets
()
Activity 2 explained
()
Activity 2 Manage data in Google Sheets
Format a Google Sheets spreadsheet-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
()
Basic formulas, functions, and charts-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
Share your Google Sheets spreadsheets-Share your Google Sheets spreadsheets
Share your Google Sheets spreadsheets
()
Activity 7 explained
()
Activity 7 Explore sharing options
Collaborate with Google Sheets-Collaborate with Google Sheets
Collaborate with Google Sheets
()
Activity 8 explained
()
Activity 8 Comments and action items
Chat and Gmail integration
()
Business challenge-Business challenge
Business challenge overview
()
Business challenge explained
()
Activity 9 Business challenge
Wrap up
()