Excel Intermediate
Excel Intermediate
|
||||
Try Limited, Free Training:
- How to create Bar, Column, Pie and Line Charts.
- Build formulas with absolute & relative cell references.
- Share & protect workbooks to collaborate with others.
- Use conditional formatting for specific data.
Upgrade to Experience:
-
LinkedIn-ready certificates that verify your skills
-
Skill assessments
-
Unlocked courses & interactive content
-
Customizable content; create your own courses
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Charts | Limited Free Learning | |||
| Create Charts | Click to start | Not Started | Not included | |
| Move and Resize | Not included | Not Started | Not included | |
| Chart Types | Not included | Not Started | Not included | |
| Layout and Style | Not included | Not Started | Not included | |
| Titles and Legends | Not included | Not Started | Not included | |
| Gridlines, Labels, and Data Tables | Not included | Not Started | Not included | |
| Chart Elements | Not included | Not Started | Not included | |
| Modify Chart Data | Not included | Not Started | Not included | |
| Filter Charts | Not included | Not Started | Not included | |
| Trendlines | Not included | Not Started | Not included | |
| Dual-Axis Charts | Not included | Not Started | Not included | |
| Chart Templates | Not included | Not Started | Not included | |
| Sparklines | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Print and Distribute | Limited Free Learning | |||
| Page Size and Scale | Not included | Not Started | Not included | |
| Print Area and Page Breaks | Not included | Not Started | Not included | |
| Print Titles, Gridlines, and Headings | Not included | Not Started | Not included | |
| Headers and Footers | Not included | Not Started | Not included | |
| Margins and Orientation | Not included | Not Started | Not included | |
| Inspect for Issues | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Intermediate Formulas | Limited Free Learning | |||
| Reference External Worksheets | Not included | Not Started | Not included | |
| Absolute and Relative References | Not included | Not Started | Not included | |
| Order of Operations | Not included | Not Started | Not included | |
| Cell and Range Names | Not included | Not Started | Not included | |
| Insert Functions | Not included | Not Started | Not included | |
| CONCAT Function | Not included | Not Started | Not included | |
| PMT and NPER Functions | Not included | Not Started | Not included | |
| Display Formulas | Not included | Not Started | Not included | |
| Date Formulas | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Manage Data | Limited Free Learning | |||
| Quick Analysis | Not included | Not Started | Not included | |
| Data Validation | Not included | Not Started | Not included | |
| Outline and Subtotal | Not included | Not Started | Not included | |
| Flash Fill | Not included | Not Started | Not included | |
| Import and Export Data | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Tables | Limited Free Learning | |||
| Insert a Table | Not included | Not Started | Not included | |
| Sort Data | Not included | Not Started | Not included | |
| Add Rows and Columns | Not included | Not Started | Not included | |
| Table Styles | Not included | Not Started | Not included | |
| Remove Duplicates | Not included | Not Started | Not included | |
| Slicers | Not included | Not Started | Not included | |
| Structured References | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Intermediate Formatting | Limited Free Learning | |||
| Apply Conditional Formatting | Not included | Not Started | Not included | |
| Apply and Remove Cell Styles | Not included | Not Started | Not included | |
| Create and Modify Cell Styles | Not included | Not Started | Not included | |
| Find and Replace Formatting | Not included | Not Started | Not included | |
| Apply a Theme | Not included | Not Started | Not included | |
| Skill | Pre-assess | Lesson | Post-assess | Learning mode |
|---|---|---|---|---|
| Collaboration | Limited Free Learning | |||
| Cell Comments | Not included | Not Started | Not included | |
| Share Workbooks | Not included | Not Started | Not included | |
| Co-author Workbooks | Not included | Not Started | Not included | |
| Protect a Worksheet | Not included | Not Started | Not included | |
| Protect Workbook Structure | Not included | Not Started | Not included | |
| Password Protection | Not included | Not Started | Not included | |