Google Sheets
|
||||
What you'll learn:
- Create and edit worksheets to summarize information.
- Basics of entering and formatting data and numbers.
- Build formulas to calculate totals and averages.
- Format data with visually stunning designs.
What’s Included:
- Skill assessments
- Bite-sized, interactive lessons
- LinkedIn-ready skills certificate
- Customizable content
| Sheets Fundamentals | Verified Learning | |||
| Create Spreadsheets Click to start | Not Started | Not Started | Not Started | |
| Open a Spreadsheet | Not Started | Not Started | Not Started | |
| Navigate Spreadsheets | Not Started | Not Started | Not Started | |
| File Management | Not Started | Not Started | Not Started | |
| Print Spreadsheets | Not Started | Not Started | Not Started | |
| Get Help | Not Started | Not Started | Not Started | |
| Edit Spreadsheets | Verified Learning | |||
| Select Cells and Ranges | Account Required | |||
| Edit Cell Data | ||||
| Cut, Copy, and Paste Data | ||||
| Undo, Redo, and Repeat | ||||
| Use Paste Special | ||||
| Insert and Move Cells | ||||
| Delete Cells | ||||
| Hide Rows and Columns | ||||
| Find and Replace Text | ||||
| Check Spelling | ||||
| Format Spreadsheets | Verified Learning | |||
| Format Text | ||||
| Align and Merge Cells | ||||
| Cell Borders and Background Colors | ||||
| Format Numbers and Dates | ||||
| Adjust Row Height and Column Width | ||||
| Freeze Rows and Columns | ||||
| Copy Formatting | ||||
| Apply Conditional Formatting | ||||
| Formulas and Functions | Verified Learning | |||
| Formula Basics | ||||
| Autofill | ||||
| Sums and Averages | ||||
| MIN and MAX | ||||
| COUNT | ||||
| Insert Functions | ||||
| Absolute and Relative Cell References | ||||
| Cell Range Names | ||||
| Manage Sheets and Data | Verified Learning | |||
| Insert, Rename, and Delete Sheets | ||||
| Duplicate, Move, and Hide Sheets | ||||
| Sort Data | ||||
| Filter Data | ||||
| Data Validation | ||||
| Protect Spreadsheets | ||||
| Insert Objects | Verified Learning | |||
| Insert a Chart | ||||
| Customize a Chart | ||||
| Insert Images | ||||
| Insert Links | ||||
| Share, Collaborate, and Convert | Verified Learning | |||
| Upload and Convert Spreadsheets | ||||
| Download and Email Spreadsheets | ||||
| Share Spreadsheets | ||||
| Collaborate | ||||
| Work with Versions | ||||
| Add-Ons | ||||
Quick Answer:
