Chat with us, powered by LiveChat

Excel 2016 Mac Intermediate

Learn by doing—not watching—with interactive simulations.

76 users

Course Includes

  • Custom-branding Certificate of Achievement
  • Custom-branding Interactive Tutorials
  • Custom-branding Skills Assessments

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.

Try sample lessons in the course outline shown below!

Proven Learning Method

Learning Method Diagram
Skill Assess Learn Verify Improvement

Excel 2016 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