Doing more with Google Sheets

Doing more with Google Sheets

Instructor: Google Cloud Training

108,211 already enrolled

Included with

Learn more

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,106 Courses 3,991,944 learners

Offered by

Google Cloud

Explore more from Business Essentials

Google Cloud
Google Sheets
Course
Google Cloud
Google Sheets: Getting Started
Project
Google Cloud
Google Sheets - Advanced Topics
Course
Google Cloud
Use Charts in Google Sheets
Project

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 Aug 31, 2020

This Course helped me dive down into the Google Sheet features that I've thought know them before, and learned the tips and tricks about the SpreadSheet manipulations. thanks a lot :)

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 Nov 22, 2022

Really nice course. Wonderfully structured.More talk on syntax and functions could've been nice but I guess they are for us to try on our own.

View more reviews

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.