Excel 2021 Intermediate
|
||||
What you'll learn:
- 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.
What’s Included:
- Skill assessments
- Bite-sized, interactive lessons
- LinkedIn-ready skills certificate
- Customizable content
| 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 | |
| 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 | ||||
| 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 | ||||
| Manage Data | Verified Learning | |||
| Quick Analysis | ||||
| Data Validation | ||||
| Outline and Subtotal | ||||
| Flash Fill | ||||
| Import and Export Data | ||||
| Tables | Verified Learning | |||
| Insert a Table | ||||
| Sort Data | ||||
| Add Rows and Columns | ||||
| Table Styles | ||||
| Remove Duplicates | ||||
| Slicers | ||||
| Structured References | ||||
| Intermediate Formatting | Verified Learning | |||
| Apply Conditional Formatting | ||||
| Apply and Remove Cell Styles | ||||
| Create and Modify Cell Styles | ||||
| Find and Replace Formatting | ||||
| Apply a Theme | ||||
| Collaboration | Verified Learning | |||
| Cell Comments | ||||
| Share Workbooks | ||||
| Co-author Workbooks | ||||
| Protect a Worksheet | ||||
| Protect Workbook Structure | ||||
| Password Protection | ||||
Quick Answer:
