Excel Mac Intermediate
Try this course with a Free Trial
|
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:
-
Customizable, LMS-compatible content
-
Skill assessments
-
Bite-sized, interactive lessons
-
LinkedIn-ready skills certificate
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 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 |
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 |
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 | ||||
CONCATENATE Function | ||||
PMT Function | ||||
Display Formulas | ||||
Date Formulas |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Manage Data |
Verified Learning
|
|||
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 Cells Styles | ||||
Create and Modify Cell Styles | ||||
Apply a Theme |
Skill | Pre-assess | Lesson | Post-assess | Learning mode |
---|---|---|---|---|
Collaborate with Excel |
Verified Learning
|
|||
Cell Comments | ||||
Share Workbooks | ||||
Track Changes | ||||
Protect a Worksheet | ||||
Protect Workbook Structure | ||||
Password Protection |
Quick Answer: