Excel 2019 Intermediate
Features:
-
Interactive bite-sized lessons
-
Get Certified
-
Accurate skill assessments
-
Customizable, LMS-ready content
Excel 2019 Intermediate
5 hour course
Learn to:
- Create eye-catching charts
- Use absolute & relative relative references
- Apply conditional formatting
- Collaborate with other users
Features:
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|
Excel 2019 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: