Google Sheets

Google Sheets

3 hours Introductory universal_currency_alt No cost

In this course we will introduce you to Google Sheets, Google’s cloud-based spreadsheet software, included with Google Workspace.

With Google Sheets, you can create and edit spreadsheets directly in your web browser—no special software is required.

Multiple people can work simultaneously, you can see people’s changes as they make them, and every change is saved automatically.

You will learn how to open Google Sheets, create a blank spreadsheet, and create a spreadsheet from a template. You will add, import, sort, filter and format your data using Google Sheets and learn how to work across different file types.

Formulas and functions allow you to make quick calculations and better use your data. We will look at creating a basic formula, using functions, and referencing data. You will also learn how to add a chart to your spreadsheet.

Google Sheets spreadsheets are easy to share. We will look at the different ways you can share with others. We will also discuss how to track changes and manage versions of your Google Sheets spreadsheets.

Google Workspace makes it easy to collaborate with your team, clients, and others wherever they are. We will look at some of the collaboration options available to you in Google Sheets. Examples include commenting, action items, and notifications.

When you complete this course, you can earn the badge displayed here! View all the badges you have earned by visiting your profile page. Boost your cloud career by showing the world the skills you have developed!

Badge for Google Sheets
info
Course Info
Objectives
  • Describe how to open Google Sheets and create a new spreadsheet.
  • Add, import, copy, paste, sort and filter data in Google Sheets.
  • Apply formatting to cells, rows, columns, and tabs in a Google Sheet.
  • Perform calculations and visualize data using Google Sheets.
  • Share a Google Sheets spreadsheet and apply permissions.
  • Manage spreadsheet versions in Google Sheets.
  • Collaborate in Google Sheets using comments and action items.
Prerequisites

None

Audience
New Google Workspace users
Available languages
English, español (Latinoamérica), and 日本語
What do I do when I finish this course?
After finishing this course, you can explore additional content in your learning path or browse the catalog.
What badges can I earn?
Upon finishing the required items in a course, you will earn a badge of completion. Badges can be viewed on your profile and shared with your social network.
Interested in taking this course with one of our authorized on-demand partners?
Explore Google Cloud content on Coursera and Pluralsight.
Prefer learning with an instructor?
View the public classroom schedule here.
Can I take this course for free?
When you enroll into most courses, you will be able to consume course materials like videos and documents for free. If a course consists of labs, you will need to purchase an individual subscription or credits to be able consume the labs. Labs can also be unlocked by any campaigns you participate in. All required activities in a course must be completed to be awarded the completion badge.
Preview