Getting Started with Google Sheets

Google Cloud

About this Course

84,849 recent views

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. First, you’ll learn how to input and format your data. Next, you’ll learn how formulas, functions and a few exclusive Google Sheets features can accelerate your data analysis. Finally, you’ll get tips for sharing your spreadsheets and collaborating on them with your team.
About the Instructor
Malia is a tech professional based in Los Angeles who uses G Suite and Google Sheets everyday to manage projects, collaborate with remote teams, and make data-driven decisions.

Learner Career Outcomes

33%

got a tangible career benefit from this course

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Beginner Level

Approx. 5 hours to complete

English

Subtitles: French, Portuguese (European), Russian, English, Spanish

Skills you will gain

SpreadsheetGoogle SheetsData AnalysisData ReportingData Visualization (DataViz)

Learner Career Outcomes

33%

got a tangible career benefit from this course

Shareable Certificate

Earn a Certificate upon completion

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Beginner Level

Approx. 5 hours to complete

English

Subtitles: French, Portuguese (European), Russian, English, Spanish

Instructor

Instructor rating

4.72/5 (218 Ratings)

Google Cloud Training

1,174,707 Learners

255 Courses

Offered by

Google Cloud

We help millions of organizations empower their employees, serve their customers, and build what’s next for their businesses with innovative technology created in—and for—the cloud. Our products are engineered for security, reliability, and scalability, running the full stack from infrastructure to applications to devices and hardware. Our teams are dedicated to helping customers apply our technologies to create success.

Syllabus - What you will learn from this course

Content Rating96%(3,576 ratings)

Week

Week 1

1 hour to complete

Welcome to Google Sheets: how to create, edit, and print your spreadsheet

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.

1 hour to complete

6 videos (Total 24 min), 4 readings, 1 quiz

6 videos

Meet the instructor3m

Create a new spreadsheet5m

Edit your spreadsheet5m

Duplicate, print, or publish your spreadsheet3m

Use some basic keyboard shortcuts4m

Test time - now it's your turn!1m

4 readings

Movie Data Spreadsheet10m

How to create, edit, and print your spreadsheet10m

Test resources10m

Test answer key10m

1 practice exercise

How to create, edit, and print your spreadsheet

Week

Week 2

1 hour to complete

Working with formulas and functions: how to import and analyze your data

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.

1 hour to complete

6 videos (Total 24 min), 5 readings, 1 quiz

6 videos

Welcome to “Working with formulas and functions”1m

Import data to your sheet2m

Analyze your data8m

Use formulas & functions10m

Use paste special in a spreadsheet45s

Test time - now it's your turn!1m

5 readings

Sort & filter your data10m

Relative and absolute references10m

How to import and analyze your data10m

Test resources10m

Test answer key10m

1 practice exercise

Working with formulas and functions

Week

Week 3

1 hour to complete

Telling stories with data: how to design your sheet to highlight trends

Explore how Google Sheets allows you to design spreadsheets that are both aesthetically pleasing and informative.

1 hour to complete

5 videos (Total 16 min), 3 readings, 1 quiz

5 videos

Welcome to “Telling stories with data”1m

Format cells, rows, and columns in your spreadsheet5m

Highlight key data points in your spreadsheet5m

Enter objects in your spreadsheet2m

Test time - now it's your turn!1m

3 readings

How to design your sheet to highlight trends10m

Test resources10m

Test answer key10m

1 practice exercise

Telling Stories with Data

Week

Week 4

1 hour to complete

Supercharge your sheet: how to create charts, pivot tables, and reports

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.

1 hour to complete

6 videos (Total 20 min), 4 readings, 1 quiz

6 videos

Welcome to “Supercharge your sheet”49s

Dive deeper into your data5m

Tell your story with your data4m

Use the GOOGLETRANSLATE and GOOGLEFINANCE functions1m

Analyze your trends alongside Big Data patterns5m

Test time - now it's your turn!1m

4 readings

Create & use pivot tables10m

How to create charts, pivot tables, and reports10m

Test resources10m

Test answer key10m

1 practice exercise

Supercharge your sheet

Frequently Asked Questions

When will I have access to the lectures and assignments?
Access to lectures and assignments depends on your type of enrollment. If you take a course in audit mode, you will be able to see most course materials for free. To access graded assignments and to earn a Certificate, you will need to purchase the Certificate experience, during or after your audit. If you don't see the audit option:
The course may not offer an audit option. 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.
What will I get if I purchase the Certificate?
When you purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.
Is financial aid available?
Yes, Coursera provides financial aid to learners who cannot afford the fee. Apply for it by clicking on the Financial Aid link beneath the "Enroll" button on the left. You’ll be prompted to complete an application and will be notified if you are approved. Learn more.
Will I earn university credit for completing the Course?
This Course doesn't carry university credit, but some universities may choose to accept Course Certificates for credit. Check with your institution to learn more. Online Degrees and Mastertrack™ Certificates on Coursera provide the opportunity to earn university credit.

More questions? Visit the Learner Help Center.

Getting Started with Google Sheets