Doing more with Google Sheets

Doing more with Google Sheets

Instructor: Google Cloud Training

Access provided by Allegiant Giving Corporation

108,246 already enrolled

5 modules

Gain insight into a topic and learn the fundamentals.

1,394 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,394 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,110 Courses 4,008,556 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.25%
4 stars
20.71%
3 stars
4.51%
2 stars
1.43%
1 star
1.07%

Showing 3 of 1394

Reviewed on Jan 6, 2021

Well paced, great insight into a lot of neat tips and tricks and introduction to topics such as Pivot tables and functions. A beginner course at its best.

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 Apr 3, 2020

The sheet in videos could be closer and darker. Hard to read and follow because they are hard to see. Otherwise the course is a great way to get started with Google sheets.

View more reviews