Google Sheets Training
Features:
-
Interactive bite-sized lessons
-
Get Certified
-
Accurate skill assessments
-
Customizable, LMS-ready content
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|
Google Sheets Training
Account Required:
Try this course with a
Free Trial
|
Verified Learning |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Sheets Fundamentals | ||||
|
Create Spreadsheets
How to Create Spreadsheets in Google Sheets |
Account Req | Not Started | Account Req | |
|
Open a Spreadsheet
How to Open a Spreadsheet in Google Sheets |
Account Req | Not Started | Account Req | |
|
Navigate Spreadsheets
How to Navigate Spreadsheets in Google Sheets |
Account Req | Not Started | Account Req | |
|
File Management
How to Manage Google Sheets Files |
Account Req | Not Started | Account Req | |
|
Print Spreadsheets
How to Print Spreadsheets in Google Sheets |
Account Req | Not Started | Account Req | |
|
Get Help
How to Get Help in Google Sheets |
Account Req | Not Started | Account Req | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Edit Spreadsheets | ||||
|
Select Cells and Ranges
How to Select Cells and Ranges in Google Sheets |
Account Req | Not Started | Account Req | |
|
Edit Cell Data
How to Edit Cell Data in Google Sheets |
Account Req | Not Started | Account Req | |
|
Cut, Copy, and Paste Data
How to Cut, Copy and Paste Data in Google Sheets |
Account Req | Not Started | Account Req | |
|
Undo, Redo, and Repeat
How to Undo, Redo, and Repeat in Google Sheets |
Account Req | Not Started | Account Req | |
|
Use Paste Special
How to Use Paste Special in Google Sheets |
Account Req | Not Started | Account Req | |
|
Insert and Move Cells
How to Insert and Move Cells in Google Sheets |
Account Req | Not Started | Account Req | |
|
Delete Cells
How to Delete Cells in Google Sheets |
Account Req | Not Started | Account Req | |
|
Hide Rows and Columns
How to Hide Rows and Columns in Google Sheets |
Account Req | Not Started | Account Req | |
|
Find and Replace Text
How to Find and Replace Text in Google Sheets |
Account Req | Not Started | Account Req | |
|
Check Spelling
How to Check Spelling in Google Sheets |
Account Req | Not Started | Account Req | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Format Spreadsheets | ||||
|
Format Text
How to Format Text in Google Sheets |
Account Req | Not Started | Account Req | |
|
Align and Merge Cells
How to Align and Merge Cells in Google Sheets |
Account Req | Not Started | Account Req | |
|
Cell Borders and Background Colors
How to Format Cell Borders and Background Colors in Google Sheets |
Account Req | Not Started | Account Req | |
|
Format Numbers and Dates
How to Format Numbers and Dates in Google Sheets |
Account Req | Not Started | Account Req | |
|
Adjust Row Height and Column Width
How to Adjust Row Height and Column Width in Google Sheets |
Account Req | Not Started | Account Req | |
|
Freeze Rows and Columns
How to Freeze Rows and Columns in Google Sheets |
Account Req | Not Started | Account Req | |
|
Copy Formatting
How to Copy Formatting in Google Sheets |
Account Req | Not Started | Account Req | |
|
Apply Conditional Formatting
How to Apply Conditional Formatting in Google Sheets |
Account Req | Not Started | Account Req | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Formulas and Functions | ||||
|
Formula Basics
Formula Basics in Google Sheets |
Account Req | Not Started | Account Req | |
|
Autofill
How to Use Autofill in Google Sheets |
Account Req | Not Started | Account Req | |
|
Sums and Averages
How to Calculate Sums and Averages in Google Sheets |
Account Req | Not Started | Account Req | |
|
MIN and MAX
How to Use the MIN and MAX Functions in Google Sheets |
Account Req | Not Started | Account Req | |
|
COUNT
How to Use the COUNT Function in Google Sheets |
Account Req | Not Started | Account Req | |
|
Insert Functions
How to Insert Functions in Google Sheets |
Account Req | Not Started | Account Req | |
|
Absolute and Relative Cell References
How to Use Absolute and Relative Cell References in Google Sheets |
Account Req | Not Started | Account Req | |
|
Cell Range Names
How to Name a Cell Range in Google Sheets |
Account Req | Not Started | Account Req | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Manage Sheets and Data | ||||
|
Insert, Rename, and Delete Sheets
How to Insert, Rename, and Delete Sheets in Google Sheets |
Account Req | Not Started | Account Req | |
|
Duplicate, Move, and Hide Sheets
How to Duplicate, Move, and Hide Sheets in Google Sheets |
Account Req | Not Started | Account Req | |
|
Sort Data
How to Sort Data in Google Sheets |
Account Req | Not Started | Account Req | |
|
Filter Data
How to Filter Data in Google Sheets |
Account Req | Not Started | Account Req | |
|
Data Validation
How to Use Data Validation in Google Sheets |
Account Req | Not Started | Account Req | |
|
Protect Spreadsheets
How to Protect Spreadsheets in Google Sheets |
Account Req | Not Started | Account Req | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Insert Objects | ||||
|
Insert a Chart
How to Insert a Chart in Google Sheets |
Account Req | Not Started | Account Req | |
|
Customize a Chart
How to Customize a Chart in Google Sheets |
Account Req | Not Started | Account Req | |
|
Insert Images
How to Insert Images in Google Sheets |
Account Req | Not Started | Account Req | |
|
Insert Links
How to Insert Links in Google Sheets |
Account Req | Not Started | Account Req | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Share, Collaborate, and Convert | ||||
|
Upload and Convert Spreadsheets
How to Upload and Convert Spreadsheets in Google Sheets |
Account Req | Not Started | Account Req | |
|
Download and Email Spreadsheets
How to Download and Email Spreadsheets in Google Sheets |
Account Req | Not Started | Account Req | |
|
Share Spreadsheets
How to Share Spreadsheets in Google Sheets |
Account Req | Not Started | Account Req | |
|
Collaborate
How to Collaborate in Google Sheets |
Account Req | Not Started | Account Req | |
|
Work with Versions
How to Work with Versions in Google Sheets |
Account Req | Not Started | Account Req | |
|
Add-Ons
How to Install Add-Ons in Google Sheets |
Account Req | Not Started | Account Req | |