Excel 2021 Intermediate
Features:
-
Interactive bite-sized lessons
-
Get Certified
-
Accurate skill assessments
-
Customizable, LMS-ready content
Excel 2021 Intermediate
Try this course with a Free Trial
|
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Charts |
Verified Learning
|
|||
Create Charts Click to start | Not Started | Not Started | Not Started | |
Move and Resize | Not Started | Not Started | Not Started | |
Chart Types | Not Started | Not Started | Not Started | |
Layout and Style | Not Started | Not Started | Not Started | |
Titles and Legends | Not Started | Not Started | Not Started | |
Gridlines, Labels, and Data Tables | Not Started | Not Started | Not Started | |
Chart Elements | Not Started | Not Started | Not Started | |
Modify Chart Data | Not Started | Not Started | Not Started | |
Filter Charts | Not Started | Not Started | Not Started | |
Trendlines | Not Started | Not Started | Not Started | |
Dual-Axis Charts | Not Started | Not Started | Not Started | |
Chart Templates | Not Started | Not Started | Not Started | |
Sparklines | Not Started | Not Started | Not Started |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Print and Distribute |
Verified Learning
|
|||
Page Size and Scale | Account Required | |||
Print Area and Page Breaks | ||||
Print Titles, Gridlines, and Headings | ||||
Headers and Footers | ||||
Margins and Orientation | ||||
Inspect for Issues |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Intermediate Formulas |
Verified Learning
|
|||
Reference External Worksheets | ||||
Absolute and Relative References | ||||
Order of Operations | ||||
Cell and Range Names | ||||
Insert Functions | ||||
CONCAT Function | ||||
PMT and NPER Functions | ||||
Display Formulas | ||||
Date Formulas |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Manage Data |
Verified Learning
|
|||
Quick Analysis | ||||
Outline and Subtotal | ||||
Data Validation | ||||
Flash Fill | ||||
Import and Export Data |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Tables |
Verified Learning
|
|||
Insert a Table | ||||
Sort Data | ||||
Filter Data | ||||
Add Rows and Columns | ||||
Table Styles | ||||
Remove Duplicates | ||||
Slicers | ||||
Structured References |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Intermediate Formatting |
Verified Learning
|
|||
Apply Conditional Formatting | ||||
Apply and Remove Cell Styles | ||||
Create and Modify Cell Styles | ||||
Find and Replace Formatting | ||||
Apply a Theme |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Collaboration |
Verified Learning
|
|||
Cell Comments | ||||
Share Workbooks | ||||
Co-author Workbooks | ||||
Version History | ||||
Protect a Worksheet | ||||
Protect Workbook Structure | ||||
Password Protection |
Quick Answer: