VOOZH about

URL: https://www.coursera.org/learn/getting-started-with-google-sheets

⇱ Doing more with Google Sheets | Coursera

Doing more with Google Sheets

Ends soon! Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.

Doing more with Google Sheets

108,779 already enrolled

Included with

Gain insight into a topic and learn the fundamentals.
4.6

1,397 reviews

Beginner level
No prior experience required
Flexible schedule
5 hours to complete
Learn at your own pace
Gain insight into a topic and learn the fundamentals.
4.6

1,397 reviews

Beginner level
No prior experience required
Flexible schedule
5 hours to complete
Learn at your own pace

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

5 assignments

Taught in English
95%
Most learners liked this course

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.

About the Instructor Malia is a tech professional based in Los Angeles who uses Google Workspace and Google Sheets everyday to manage projects, collaborate with remote teams, and make data-driven decisions.

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
4.7 (433 ratings)
Google Cloud
2,269 Courses•4,432,832 learners

Explore more from Business Essentials

Why people choose Coursera for their career

👁 Image

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."
👁 Image

Jennifer J.

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

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."
👁 Image

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

RA
·

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.

KS
·

Reviewed on Jun 15, 2022

I enjoyed this course. I had only limited use of excel prior to this and feel that this knowledge of Google Sheets will help at work and at home.

DP
·

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.

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.

Financial aid available,