![]()
Excel Mac 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 Styles | 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 |
Intermediate Formulas | Verified Learning | |||
Reference External Worksheets | ||||
Absolute and Relative References | ||||
Order of Operations | ||||
Cell and Range Names | ||||
Insert Functions | ||||
CONCATENATE Function | ||||
PMT Function | ||||
Display Formulas | ||||
Date Formulas |
Manage Data | Verified Learning | |||
Outline and Subtotal | ||||
Data Validation | ||||
Flash Fill | ||||
Import and Export Data |
Tables | Verified Learning | |||
Insert a Table | ||||
Sort Data | ||||
Filter Data | ||||
Add Rows and Columns | ||||
Table Styles | ||||
Remove Duplicates | ||||
Slicers | ||||
Structured References |
Intermediate Formatting | Verified Learning | |||
Apply Conditional Formatting | ||||
Apply and Remove Cells Styles | ||||
Create and Modify Cell Styles | ||||
Apply a Theme |
Collaborate with Excel | Verified Learning | |||
Cell Comments | ||||
Share Workbooks | ||||
Track Changes | ||||
Protect a Worksheet | ||||
Protect Workbook Structure | ||||
Password Protection |
Quick Answer: