Curriculum

11 Topics
Meet the instructor
Create a new spreadsheet
Edit your spreadsheet
Duplicate print or publish your spreadsheet
Use some basic keyboard shortcuts
Test time - now it's your turn!
Movie Data Spreadsheet
How to create edit and print your spreadsheet
Test resources
Test answer key
How to create edit and print your spreadsheet

12 Topics
Welcome to “Working with formulas and functions”
Import data to your sheet
Analyze your data
Use formulas & functions
Use paste special in a spreadsheet
Test time - now it's your turn!
Sort & filter your data
Relative and absolute references
How to import and analyze your data
Test resources
Test answer key
Working with formulas and functions

9 Topics
Welcome to “Telling stories with data”
Format cells rows and columns in your spreadsheet
Highlight key data points in your spreadsheet
Enter objects in your spreadsheet
Test time - now it's your turn!
How to design your sheet to highlight trends
Test resources
Test answer key
Telling Stories with Data

11 Topics
Welcome to “Supercharge your sheet”
Dive deeper into your data
Tell your story with your data
Use the GOOGLETRANSLATE and GOOGLEFINANCE functions
Analyze your trends alongside Big Data patterns
Test time - now it's your turn!
Create & use pivot tables
How to create charts pivot tables and reports
Test resources
Test answer key
Supercharge your sheet

13 Topics
Welcome to “Collaborating in Sheets”
Share a spreadsheet
Maintain control of your data
Troubleshoot error messages
Collaborate with your team
Track changes and activity
Test time - now it's your turn!
How to use Google Forms
View the activity on your Google Sheets
How to share your data with your team
Test resources
Test answer key
Collaborating in Sheets

  Write a Review

Doing more with Google Sheets

Go to Free Course