Excel 2021 Basic
Features:
-
Interactive bite-sized lessons
-
Get Certified
-
Accurate skill assessments
-
Customizable, LMS-ready content
Excel 2021 Basic
4 hour course
Learn to:
- Build & edit spreadsheets
- Calculate with formulas
- Add eye-catching formatting
- Organize and manage workbooks
Features:
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|
Excel 2021 Basic
Try this course with a Free Trial
|
||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Excel Fundamentals |
Verified Learning
|
|||
| Understand the Excel Screen Click to start | Not Started | Not Started | Not Started | |
| Create Workbooks | Not Started | Not Started | Not Started | |
| Navigate Worksheets | Not Started | Not Started | Not Started | |
| Open Workbooks | Not Started | Not Started | Not Started | |
| Save Workbooks | Not Started | Not Started | Not Started | |
| AutoRecover | Not Started | Not Started | Not Started | |
| The Quick Access Toolbar | Not Started | Not Started | Not Started | |
| Not Started | Not Started | Not Started | ||
| Help | Not Started | Not Started | Not Started | |
| Close and Exit | Not Started | Not Started | Not Started | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Edit a Workbook |
Verified Learning
|
|||
| Select Cells and Ranges | Account Required | |||
| Edit Cell Data | ||||
| Cut, Copy, and Paste | ||||
| Undo, Redo, Repeat | ||||
| More Pasting Options | ||||
| Insert and Move Cells | ||||
| Delete Cells | ||||
| Check Spelling | ||||
| Find and Replace Text | ||||
| Hide Columns and Rows | ||||
| Document Properties | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Basic Formulas |
Verified Learning
|
|||
| Formula Basics | ||||
| AutoFill | ||||
| Sums and Averages | ||||
| MIN and MAX | ||||
| COUNT | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Basic Formatting |
Verified Learning
|
|||
| Format Text | ||||
| Align and Merge Cells | ||||
| Format Numbers and Dates | ||||
| Borders and Background Colors | ||||
| Copy Formatting | ||||
| Row Heights and Column Widths | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Insert Objects |
Verified Learning
|
|||
| Images | ||||
| Shapes | ||||
| Hyperlinks | ||||
| Object Properties and Alt Text | ||||
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Manage Worksheets |
Verified Learning
|
|||
| View Worksheets | ||||
| Multiple Windows | ||||
| Move and Copy Worksheets | ||||
| Insert, Rename, and Delete Worksheets | ||||
| Freeze Rows and Columns | ||||
| Hide Worksheets and Gridlines | ||||
Quick Answer: