Excel Mac Intermediate

Learn by doing—not watching—with interactive simulations.

178 users

Course Includes

  • Custom-branding Certificate of Accreditation
  • Custom-branding 5.0 Credit Hours
  • Custom-branding Interactive Tutorials & Skills Assessments
  • Custom-branding Student manual, instructor guide, & practice files

What you'll learn:

  • How to create Bar, Column, Pie and Line Charts.
  • Build intermediate formulas using absolute & relative cell references.
  • Share & protect workbooks to collaborate with others.
  • Add conditional formatting to highlight data that meets your criteria.

Proven Learning Method

ALT_LEARNING_DIAGRAM
Skill Assess Learn Verify Improvement

Excel Mac Intermediate

 Complete Course to Display Score

Charts demo

Create Charts Click To Try 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 lock Subscribe to unlock

Page Size and Scale
Print Area and Page Breaks
Print Titles, Gridlines, and Headings
Headers and Footers
Margins and Orientation

Intermediate Formulas lock Subscribe to unlock

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 lock Subscribe to unlock

Outline and Subtotal
Data Validation
Flash Fill
Import and Export Data

Tables lock Subscribe to unlock

Insert a Table
Sort Data
Filter Data
Add Rows and Columns
Table Styles
Remove Duplicates
Slicers
Structured References

Intermediate Formatting lock Subscribe to unlock

Apply Conditional Formatting
Apply and Remove Cells Styles
Create and Modify Cell Styles
Apply a Theme

Collaborate with Excel lock Subscribe to unlock

Cell Comments
Share Workbooks

Track Changes
Protect a Worksheet
Protect Workbook Structure
Password Protection