Bundle includes

These five courses are included in your bundle:

What you'll learn

As you complete these five courses, you'll learn and practice the following digital skills, terms, and concepts:

Welcome to Google Workspace for Beginners
Digital Skills
Terms and Concepts
Get to Google.com Google apps
Create a Google account Google Workspace
Sign into your Google account Google account


Google Sheets for Beginners
Example Student Outcome
Digital Skills
Terms and Concepts
Create a new spreadsheet Spreadsheet
Rename a spreadsheet Cells
Create a bolded header row Row
Type text and number into a spreadsheet Columns
Use SUM function Header

Function


Google Workspace: Sheets - Part 1
Example Student Outcomes
Digital Skills Terms and Concepts
Navigate a spreadsheet Spreadsheet
Duplicate sheets Cell
Edit the contents of cells in a spreadsheet Row
Add values to cells Column
Insert rows and columns Heading
Delete rows and columns Merge
Format with different fonts and colors Sorting
Merge cells Data Validation
Add borders
Resize rows and columns
Add data validation
Sort data


Google Workspace: Sheets - Part 2
Example Student Outcomes
Digital Skills Terms and Concepts
Sheets functions (SUM, COUNTIF) Filters
Filters Filter views
Filter views Functions
Charts (bar, pie) Charts
Protect sheets
Digitally share
Digitally collaborate with comments
Use version history


Google Workspace: Sheets - Part 3
Example Student Outcomes
Digital Skills Terms and Concepts
Sheets functions (SUM, MULTIPLY, AVERAGE, MAX, MIN) File format
Search the Function List Functions
Download spreadsheet in another file format Cost 
Copy another file format into an existing spreadsheet Revenue
Use absolute cell references Profit
Wrap text Absolute and relative references
Conditional formatting
Insert non-text elements
Insert links to other sheets

What is Google Sheets?

Google Sheets is an online spreadsheet app that lets you create, format, and collaborate on spreadsheets in real-time and from any device.


How much does Google Sheets cost?

Google Sheets is free for personal use. Businesses, schools, and individuals needing professional features and improved capabilities can choose between a variety of paid Google Workspace plans.

Who are these courses for?

These courses are designed to help those who are new to technology to develop an advanced understanding of Google Sheets.
Buy now
Man working at his laptop computer while drinking coffee

You may also like

Browse other courses in our catalogue that may be of interest:

View more products