Courses
Google Sheets

4 hour course

Google Sheets

4.9 out of 5 on G2

Try this course with a Free Trial

Want to master Google Sheets? Learn how to create, edit, and format spreadsheets to organize and analyze data efficiently.

Learn to:

Create Professional Spreadsheets
Format Data Effectively
Utilize Formulas and Functions
Collaborate in Real-Time

Features:

Learn by doing simulations
Skill assessments
Certificate

Skill	Pre-assess	Lesson	Post-assess	Learning mode

Google Sheets Outline

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Sheets Fundamentals			Verified Learning
Create Spreadsheets How to Create Spreadsheets in Google Sheets	Not Started	Not Started	Not Started
Open a Spreadsheet How to Open a Spreadsheet in Google Sheets	Not Started	Not Started	Not Started
Navigate Spreadsheets How to Navigate Spreadsheets in Google Sheets	Not Started	Not Started	Not Started
File Management How to Manage Google Sheets Files	Not Started	Not Started	Not Started
Print Spreadsheets How to Print Spreadsheets in Google Sheets	Not Started	Not Started	Not Started
Get Help How to Get Help in Google Sheets	Not Started	Not Started	Not Started

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Edit Spreadsheets			Verified Learning
Select Cells and Ranges How to Select Cells and Ranges in Google Sheets	Account Required
Edit Cell Data How to Edit Cell Data in Google Sheets
Cut, Copy, and Paste Data How to Cut, Copy and Paste Data in Google Sheets
Undo, Redo, and Repeat How to Undo, Redo, and Repeat in Google Sheets
Use Paste Special How to Use Paste Special in Google Sheets
Insert and Move Cells How to Insert and Move Cells in Google Sheets
Delete Cells How to Delete Cells in Google Sheets
Hide Rows and Columns How to Hide Rows and Columns in Google Sheets
Find and Replace Text How to Find and Replace Text in Google Sheets
Check Spelling How to Check Spelling in Google Sheets

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Format Spreadsheets			Verified Learning
Format Text How to Format Text in Google Sheets
Align and Merge Cells How to Align and Merge Cells in Google Sheets
Cell Borders and Background Colors How to Format Cell Borders and Background Colors in Google Sheets
Format Numbers and Dates How to Format Numbers and Dates in Google Sheets
Adjust Row Height and Column Width How to Adjust Row Height and Column Width in Google Sheets
Freeze Rows and Columns How to Freeze Rows and Columns in Google Sheets
Copy Formatting How to Copy Formatting in Google Sheets
Apply Conditional Formatting How to Apply Conditional Formatting in Google Sheets

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Formulas and Functions			Verified Learning
Formula Basics Formula Basics in Google Sheets
Autofill How to Use Autofill in Google Sheets
Sums and Averages How to Calculate Sums and Averages in Google Sheets
MIN and MAX How to Use the MIN and MAX Functions in Google Sheets
COUNT How to Use the COUNT Function in Google Sheets
Insert Functions How to Insert Functions in Google Sheets
Absolute and Relative Cell References How to Use Absolute and Relative Cell References in Google Sheets
Cell Range Names How to Name a Cell Range in Google Sheets

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Manage Sheets and Data			Verified Learning
Insert, Rename, and Delete Sheets How to Insert, Rename, and Delete Sheets in Google Sheets
Duplicate, Move, and Hide Sheets How to Duplicate, Move, and Hide Sheets in Google Sheets
Sort Data How to Sort Data in Google Sheets
Filter Data How to Filter Data in Google Sheets
Data Validation How to Use Data Validation in Google Sheets
Protect Spreadsheets How to Protect Spreadsheets in Google Sheets

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Insert Objects			Verified Learning
Insert a Chart How to Insert a Chart in Google Sheets
Customize a Chart How to Customize a Chart in Google Sheets
Insert Images How to Insert Images in Google Sheets
Insert Links How to Insert Links in Google Sheets

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Share, Collaborate, and Convert			Verified Learning
Upload and Convert Spreadsheets How to Upload and Convert Spreadsheets in Google Sheets
Download and Email Spreadsheets How to Download and Email Spreadsheets in Google Sheets
Share Spreadsheets How to Share Spreadsheets in Google Sheets
Collaborate How to Collaborate in Google Sheets
Work with Versions How to Work with Versions in Google Sheets
Add-Ons How to Install Add-Ons in Google Sheets