About this Course

126,513 recent views

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Beginner Level

Approx. 7 hours to complete

Suggested: 2 days of study, 2 hours per day...

English

Subtitles: English

Skills you will gain

SpreadsheetGoogle SheetsData AnalysisData ReportingData Visualization (DataViz)

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Beginner Level

Approx. 7 hours to complete

Suggested: 2 days of study, 2 hours per day...

English

Subtitles: English

Instructor

Offered by

Google Cloud logo

Google Cloud

Syllabus - What you will learn from this course

Week
1

Week 1

1 hour to complete

Welcome to Google Sheets: how to create, edit, and print your spreadsheet

1 hour to complete
6 videos (Total 24 min), 4 readings, 1 quiz
6 videos
Create a new spreadsheet5m
Edit your spreadsheet5m
Duplicate, print, or publish your spreadsheet3m
Use some basic keyboard shortcuts4m
Test time - now it's your turn!1m
4 readings
Movie Data Spreadsheet10m
How to create, edit, and print your spreadsheet10m
Test resources10m
Test answer key10m
1 practice exercise
How to create, edit, and print your spreadsheet
Week
2

Week 2

1 hour to complete

Working with formulas and functions: how to import and analyze your data

1 hour to complete
6 videos (Total 24 min), 5 readings, 1 quiz
6 videos
Import data to your sheet2m
Analyze your data8m
Use formulas & functions10m
Use paste special in a spreadsheet45s
Test time - now it's your turn!1m
5 readings
Sort & filter your data10m
Relative and absolute references10m
How to import and analyze your data10m
Test resources10m
Test answer key10m
1 practice exercise
Working with formulas and functions
Week
3

Week 3

1 hour to complete

Telling stories with data: how to design your sheet to highlight trends

1 hour to complete
5 videos (Total 16 min), 3 readings, 1 quiz
5 videos
Format cells, rows, and columns in your spreadsheet5m
Highlight key data points in your spreadsheet5m
Enter objects in your spreadsheet2m
Test time - now it's your turn!1m
3 readings
How to design your sheet to highlight trends10m
Test resources10m
Test answer key10m
1 practice exercise
Telling Stories with Data
Week
4

Week 4

1 hour to complete

Supercharge your sheet: how to create charts, pivot tables, and reports

1 hour to complete
6 videos (Total 20 min), 4 readings, 1 quiz
6 videos
Dive deeper into your data5m
Tell your story with your data4m
Use the GOOGLETRANSLATE and GOOGLEFINANCE functions1m
Analyze your trends alongside Big Data patterns5m
Test time - now it's your turn!1m
4 readings
Create & use pivot tables10m
How to create charts, pivot tables, and reports10m
Test resources10m
Test answer key10m
1 practice exercise
Supercharge your sheet

Reviews

TOP REVIEWS FROM GETTING STARTED WITH GOOGLE SHEETS
View all reviews

Frequently Asked Questions

  • Once you enroll for a Certificate, you’ll have access to all videos, quizzes, and programming assignments (if applicable). Peer review assignments can only be submitted and reviewed once your session has begun. If you choose to explore the course without purchasing, you may not be able to access certain assignments.

  • When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

More questions? Visit the Learner Help Center.