Google Sheets Training

Free Google Sheets Training and Google Sheets Cheat Sheet

Free Google Sheets Training resources to use and share with our compliments!

Interactive eLearning
Learn by doing—not watching—with interactive simulations that give students hands-on experience of using real software!
Step-by-step Courseware
Fully illustrated, simple to follow lessons.
Free Quick References
Free to download and distribute with our compliments!
Spanish Versions
Click here to view this course in Spanish.

Share with staff, students, parents—anyone who wants to learn Google Sheets!

What you'll learn:

Understand how to use spreadsheets to calculate information
Learn the basics of entering and formatting data and numbers
Build simple formulas to calculate sums and averages
Upload and convert existing Microsoft Excel files to Google Docs

Google Sheets Training	Copy these free tutorials to use in your own lesson plans:
Sheets Fundamentals
Create Spreadsheets How to Create Spreadsheets in Google Sheets		Copy Link
Open a Spreadsheet How to Open a Spreadsheet in Google Sheets		Copy Link
Navigate Spreadsheets How to Navigate Spreadsheets in Google Sheets		Copy Link
File Management How to Manage Google Sheets Files		Copy Link
Print Spreadsheets How to Print Spreadsheets in Google Sheets		Copy Link
Get Help How to Get Help in Google Sheets		Copy Link
Edit Spreadsheets
Select Cells and Ranges How to Select Cells and Ranges in Google Sheets		Copy Link
Edit Cell Data How to Edit Cell Data in Google Sheets		Copy Link
Cut, Copy, and Paste Data How to Cut, Copy and Paste Data in Google Sheets		Copy Link
Undo, Redo, and Repeat How to Undo, Redo, and Repeat in Google Sheets		Copy Link
Use Paste Special How to Use Paste Special in Google Sheets		Copy Link
Insert and Move Cells How to Insert and Move Cells in Google Sheets		Copy Link
Delete Cells How to Delete Cells in Google Sheets		Copy Link
Hide Rows and Columns How to Hide Rows and Columns in Google Sheets		Copy Link
Find and Replace Text How to Find and Replace Text in Google Sheets		Copy Link
Check Spelling How to Check Spelling in Google Sheets		Copy Link
Format Spreadsheets
Format Text How to Format Text in Google Sheets		Copy Link
Align and Merge Cells How to Align and Merge Cells in Google Sheets		Copy Link
Cell Borders and Background Colors How to Format Cell Borders and Background Colors in Google Sheets		Copy Link
Format Numbers and Dates How to Format Numbers and Dates in Google Sheets		Copy Link
Adjust Row Height and Column Width How to Adjust Row Height and Column Width in Google Sheets		Copy Link
Freeze Rows and Columns How to Freeze Rows and Columns in Google Sheets		Copy Link
Copy Formatting How to Copy Formatting in Google Sheets		Copy Link
Apply Conditional Formatting How to Apply Conditional Formatting in Google Sheets		Copy Link
Formulas and Functions
Formula Basics Formula Basics in Google Sheets		Copy Link
Autofill How to Use Autofill in Google Sheets		Copy Link
Sums and Averages How to Calculate Sums and Averages in Google Sheets		Copy Link
MIN and MAX How to Use the MIN and MAX Functions in Google Sheets		Copy Link
COUNT How to Use the COUNT Function in Google Sheets		Copy Link
Insert Functions How to Insert Functions in Google Sheets		Copy Link
Absolute and Relative Cell References How to Use Absolute and Relative Cell References in Google Sheets		Copy Link
Cell Range Names How to Name a Cell Range in Google Sheets		Copy Link
Manage Sheets and Data
Insert, Rename, and Delete Sheets How to Insert, Rename, and Delete Sheets in Google Sheets		Copy Link
Duplicate, Move, and Hide Sheets How to Duplicate, Move, and Hide Sheets in Google Sheets		Copy Link
Sort Data How to Sort Data in Google Sheets		Copy Link
Filter Data How to Filter Data in Google Sheets		Copy Link
Data Validation How to Use Data Validation in Google Sheets		Copy Link
Protect Spreadsheets How to Protect Spreadsheets in Google Sheets		Copy Link
Insert Objects
Insert a Chart How to Insert a Chart in Google Sheets		Copy Link
Customize a Chart How to Customize a Chart in Google Sheets		Copy Link
Insert Images How to Insert Images in Google Sheets		Copy Link
Insert Links How to Insert Links in Google Sheets		Copy Link
Share, Collaborate, and Convert
Upload and Convert Spreadsheets How to Upload and Convert Spreadsheets in Google Sheets		Copy Link
Download and Email Spreadsheets How to Download and Email Spreadsheets in Google Sheets		Copy Link
Share Spreadsheets How to Share Spreadsheets in Google Sheets		Copy Link
Collaborate How to Collaborate in Google Sheets		Copy Link
Work with Versions How to Work with Versions in Google Sheets		Copy Link
Add-Ons How to Install Add-Ons in Google Sheets		Copy Link