Doing more with Google Sheets

Doing more with Google Sheets

Instructor: Google Cloud Training

Access provided by Primary Diagnostics Inc

108,203 already enrolled

5 modules

Gain insight into a topic and learn the fundamentals.

1,393 reviews

Beginner level

No prior experience required

Flexible schedule

5 hours to complete

Learn at your own pace

95%

Most learners liked this course

5 modules

Gain insight into a topic and learn the fundamentals.

1,393 reviews

Beginner level

No prior experience required

Flexible schedule

5 hours to complete

Learn at your own pace

95%

Most learners liked this course

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

5 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 5 modules in this course

Google Sheets is a robust, cloud-based application that empowers you to create sophisticated spreadsheets. Whether you are working at your desk—or from your smartphone or tablet on-the-go—Google Sheets helps you organize, analyze, and share your most important data. In this course for Sheets users, you’ll learn how to make your own supercharged spreadsheets, incorporating powerful functions and visualizations to accelerate your data analysis and share meaningful insights with your team. Follow along with exercises and a companion spreadsheet to practice new skills as you encounter them.

Getting started with Google Sheets is simple. Let’s start with the basics. Learn how to create and edit your spreadsheet. Then print or publish it to the web.

What's included

6 videos4 readings1 assignment

6 videos Total 24 minutes

Meet the instructor 3 minutes
Create a new spreadsheet 6 minutes
Edit your spreadsheet 6 minutes
Duplicate, print, or publish your spreadsheet 3 minutes
Use some basic keyboard shortcuts 5 minutes
Test time - now it's your turn! 1 minute

4 readings Total 40 minutes

Movie Data Spreadsheet 10 minutes
How to create, edit, and print your spreadsheet 10 minutes
Test resources 10 minutes
Test answer key 10 minutes

1 assignment

How to create, edit, and print your spreadsheet 0 minutes

Anyone can be a data analyst with Google Sheets. Learn how to use formulas, functions, and other key features to help you analyze data effectively.

What's included

6 videos5 readings1 assignment

6 videos Total 24 minutes

Welcome to “Working with formulas and functions” 1 minute
Import data to your sheet 3 minutes
Analyze your data 8 minutes
Use formulas & functions 10 minutes
Use paste special in a spreadsheet 1 minute
Test time - now it's your turn! 1 minute

5 readings Total 50 minutes

Sort & filter your data 10 minutes
Relative and absolute references 10 minutes
How to import and analyze your data 10 minutes
Test resources 10 minutes
Test answer key 10 minutes

1 assignment

Working with formulas and functions 0 minutes

Explore how Google Sheets allows you to design spreadsheets that are both aesthetically pleasing and informative.

What's included

5 videos3 readings1 assignment

5 videos Total 16 minutes

Welcome to “Telling stories with data” 1 minute
Format cells, rows, and columns in your spreadsheet 5 minutes
Highlight key data points in your spreadsheet 5 minutes
Enter objects in your spreadsheet 3 minutes
Test time - now it's your turn! 2 minutes

3 readings Total 30 minutes

How to design your sheet to highlight trends 10 minutes
Test resources 10 minutes
Test answer key 10 minutes

1 assignment

Telling Stories with Data 0 minutes

Google Sheets empowers you to detect and visualize data with no advanced coding required. This module will show you how to generate charts, pivot tables, and other shareable reports of your data.

What's included

6 videos4 readings1 assignment

6 videos Total 20 minutes

Welcome to “Supercharge your sheet” 1 minute
Dive deeper into your data 6 minutes
Tell your story with your data 4 minutes
Use the GOOGLETRANSLATE and GOOGLEFINANCE functions 2 minutes
Analyze your trends alongside Big Data patterns 6 minutes
Test time - now it's your turn! 1 minute

4 readings Total 40 minutes

Create & use pivot tables 10 minutes
How to create charts, pivot tables, and reports 10 minutes
Test resources 10 minutes
Test answer key 10 minutes

1 assignment

Supercharge your sheet 0 minutes

With Google Sheets you can work in real-time on a spreadsheet. Learn how to share your data with your team.

What's included

7 videos5 readings1 assignment

7 videos Total 22 minutes

Welcome to “Collaborating in Sheets” 1 minute
Share a spreadsheet 3 minutes
Maintain control of your data 6 minutes
Troubleshoot error messages 2 minutes
Collaborate with your team 6 minutes
Track changes and activity 2 minutes
Test time - now it's your turn! 2 minutes

5 readings Total 50 minutes

How to use Google Forms 10 minutes
View the activity on your Google Sheets 10 minutes
How to share your data with your team 10 minutes
Test resources 10 minutes
Test answer key 10 minutes

1 assignment

Collaborating in Sheets 0 minutes

Instructor

Instructor ratings

(433 ratings)

Google Cloud Training

Google Cloud

2,105 Courses 3,990,500 learners

Offered by

Google Cloud

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

5 stars
72.23%
4 stars
20.73%
3 stars
4.51%
2 stars
1.43%
1 star
1.07%

Showing 3 of 1393

Reviewed on Jun 1, 2020

While very useful some parts were tricky if you didn't already know the same function in excel.I would've liked to see more practices and some files were in cvs which my laptop doesn't recognize.

Reviewed on Oct 2, 2024

It is a nice review of the core functionality of google sheets. Don't expect detailed explanations or an actual tutorial. There are links to relevant documentation for some deeper exploring.

Reviewed on Aug 16, 2020

its was really educational for beginners like myself, now i can at least do something with google sheets and google forms. seeing forward to advanced tutorials.

View more reviews