Doing more with Google Sheets

Doing more with Google Sheets

Instructor: Google Cloud Training

108,860 already enrolled

Included with Learn more

Ask Coursera

5 modules

Gain insight into a topic and learn the fundamentals.

1,397 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,397 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 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,279 Courses4,461,911 learners

Offered by

Google Cloud

Explore more from Business Essentials

Status: Free Trial
Google Cloud
Google Sheets
Course
Status: Free Trial
Google Cloud
Google Sheets - Advanced Topics
Course
Google Cloud
Google Sheets: Getting Started
Project
Coursera
Spreadsheets for Beginners using Google Sheets
Guided 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.17%
4 stars
20.81%
3 stars
4.50%
2 stars
1.43%
1 star
1.07%

Showing 3 of 1397

Reviewed on Jan 27, 2022

The course is good overall and you learn the basics of Google Sheets. The reason why it is only 4 stars is because it could have demonstrated the different items a little more in detail or in depth.

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

Demonstrated the real advantages of using online Google Spreadsheets to work with a team spread across the globe, easily, quickly and securely.

View more reviews

Unlock access to 10,000+ courses with a subscription
Advance your career with an online degree
Earn a degree from world-class universities - 100% online
Join over 4,700 global companies that choose Coursera for Business

Frequently asked questions

To access course materials, assignments, and earn a Certificate, you'll need to purchase the Certificate experience when you enroll in a course. Eligible learners may also have the option to start with a Free Trial. Some courses may also offer a Full Course, No Certificate option. This lets you access course materials, submit required assessments, and receive a final grade, but you won't be able to earn or purchase a Certificate.

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.