Google Sheets Course Outline
Sheets Fundamentals
| 1 | Create Spreadsheets |
| 2 | Open a Spreadsheet |
| 3 | Navigate Spreadsheets |
| 4 | File Management |
| 5 | Print Spreadsheets |
| 6 | Get Help |
Edit Spreadsheets
| 1 | Select Cells and Ranges |
| 2 | Edit Cell Data |
| 3 | Cut, Copy, and Paste Data |
| 4 | Undo, Redo, and Repeat |
| 5 | Use Paste Special |
| 6 | Insert and Move Cells |
| 7 | Delete Cells |
| 8 | Hide Rows and Columns |
| 9 | Find and Replace Text |
| 10 | Check Spelling |
Format Spreadsheets
| 1 | Format Text |
| 2 | Align and Merge Cells |
| 3 | Cell Borders and Background Colors |
| 4 | Format Numbers and Dates |
| 5 | Adjust Row Height and Column Width |
| 6 | Freeze Rows and Columns |
| 7 | Copy Formatting |
| 8 | Apply Conditional Formatting |
Formulas and Functions
| 1 | Formula Basics |
| 2 | Autofill |
| 3 | Sums and Averages |
| 4 | MIN and MAX |
| 5 | COUNT |
| 6 | Insert Functions |
| 7 | Absolute and Relative Cell References |
| 8 | Cell Range Names |
Manage Sheets and Data
| 1 | Insert, Rename, and Delete Sheets |
| 2 | Duplicate, Move, and Hide Sheets |
| 3 | Sort Data |
| 4 | Filter Data |
| 5 | Data Validation |
| 6 | Protect Spreadsheets |
Insert Objects
| 1 | Insert a Chart |
| 2 | Customize a Chart |
| 3 | Insert Images |
| 4 | Insert Links |
Share, Collaborate, and Convert
| 1 | Upload and Convert Spreadsheets |
| 2 | Download and Email Spreadsheets |
| 3 | Share Spreadsheets |
| 4 | Collaborate |
| 5 | Work with Versions |
| 6 | Add-Ons |