Doing more with Google Sheets

Doing more with Google Sheets

Instructor: Google Cloud Training

108,855 already enrolled

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 videosTotal 24 minutes

Meet the instructor3 minutes
Create a new spreadsheet6 minutes
Edit your spreadsheet6 minutes
Duplicate, print, or publish your spreadsheet3 minutes
Use some basic keyboard shortcuts5 minutes
Test time - now it's your turn!1 minute

4 readingsTotal 40 minutes

Movie Data Spreadsheet10 minutes
How to create, edit, and print your spreadsheet10 minutes
Test resources10 minutes
Test answer key10 minutes

1 assignment

How to create, edit, and print your spreadsheet0 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 videosTotal 24 minutes

Welcome to “Working with formulas and functions”1 minute
Import data to your sheet3 minutes
Analyze your data8 minutes
Use formulas & functions10 minutes
Use paste special in a spreadsheet1 minute
Test time - now it's your turn!1 minute

5 readingsTotal 50 minutes

Sort & filter your data10 minutes
Relative and absolute references10 minutes
How to import and analyze your data10 minutes
Test resources10 minutes
Test answer key10 minutes

1 assignment

Working with formulas and functions0 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 videosTotal 16 minutes

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

3 readingsTotal 30 minutes

How to design your sheet to highlight trends10 minutes
Test resources10 minutes
Test answer key10 minutes

1 assignment

Telling Stories with Data0 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 videosTotal 20 minutes

Welcome to “Supercharge your sheet”1 minute
Dive deeper into your data6 minutes
Tell your story with your data4 minutes
Use the GOOGLETRANSLATE and GOOGLEFINANCE functions2 minutes
Analyze your trends alongside Big Data patterns6 minutes
Test time - now it's your turn!1 minute

4 readingsTotal 40 minutes

Create & use pivot tables10 minutes
How to create charts, pivot tables, and reports10 minutes
Test resources10 minutes
Test answer key10 minutes

1 assignment

Supercharge your sheet0 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 videosTotal 22 minutes

Welcome to “Collaborating in Sheets”1 minute
Share a spreadsheet3 minutes
Maintain control of your data6 minutes
Troubleshoot error messages2 minutes
Collaborate with your team6 minutes
Track changes and activity2 minutes
Test time - now it's your turn!2 minutes

5 readingsTotal 50 minutes

How to use Google Forms10 minutes
View the activity on your Google Sheets10 minutes
How to share your data with your team10 minutes
Test resources10 minutes
Test answer key10 minutes

1 assignment

Collaborating in Sheets0 minutes

Instructor

Instructor ratings

(433 ratings)

Google Cloud Training

Google Cloud

2,278 Courses4,460,732 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.17%
4 stars
20.81%
3 stars
4.50%
2 stars
1.43%
1 star
1.07%

Showing 3 of 1397

Reviewed on Jun 10, 2021

while executing some examples on how to do a given task, there needs to be more explanation on whats happening rather than just saying 'see' or "isn't that cool?"

Reviewed on Dec 2, 2020

Such a fun course! She made learning so simple. I previously tried taking a course about Excel and wasn't really getting it but this was great! Thank you so much!

Reviewed on Oct 23, 2020

The course was very informative. I now able to do more with my spreadsheets with the massive knowledge I have gained in this course. Thank you.

View more reviews