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