Google Workspace: Sheets - Part 3
Learn advanced functions and conditional formatting using Google Sheets.
As you complete this course, you'll learn and practice the following digital skills, terms, and concepts:
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 |
These lessons are included in your course:
Introduction to Google Workspace: Sheets - Part 3
Sheets: Copy Sheets Into Your Spreadsheet — Copy from .csv and .xls File Types
Sheets: Use Calculate Functions
Sheets: Use Functions to Summarize Data and Calculate Profit
Sheets: Use the MIN, MAX, and AVERAGE Functions to Analyze Sales Data
Sheets: Add Conditional Formatting to Emphasize Data
Sheets: Insert Links, Images, Forms and Drawings
Google Workspace: Sheets - Part 3 Wrap-Up
Assessment
Reflection
This course will teach you to draft something similar to these example student outcomes.
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.
Browse other courses in our catalogue that may be of interest:
Learn to build, organize, and format a spreadsheet.
$24.99
Learn spreadsheet functions, filters, and charts.
$24.99
Learn the basic components of Gmail to help you send and receive emails.
$24.99