Courses
Excel Mac Intermediate

5 hour course

Excel Mac Intermediate

4.9 out of 5 on G2

Try this course with a Free Trial

Looking to enhance your Excel skills on Mac? This course covers intermediate features like advanced formulas, data management, and chart creation.

Learn to:

Create Advanced Charts
Apply Conditional Formatting
Utilize Intermediate Formulas
Collaborate on Workbooks

Features:

Learn by doing simulations
Skill assessments
Certificate

Skill	Pre-assess	Lesson	Post-assess	Learning mode

Excel Mac Intermediate Outline

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Charts			Verified Learning
Create Charts How to Create Charts in Excel	Not Started	Not Started	Not Started
Move and Resize How to Move and Resize a Chart in Excel	Not Started	Not Started	Not Started
Chart Types How to Change Chart Types in Excel	Not Started	Not Started	Not Started
Layout and Styles How to Apply Chart Layouts and Styles in Excel	Not Started	Not Started	Not Started
Titles and Legends How to Customize Chart Titles and Legends in Excel	Not Started	Not Started	Not Started
Gridlines, Labels, and Data Tables How to Display Chart Gridlines, Labels, and Data Tables in Excel	Not Started	Not Started	Not Started
Chart Elements How to Format Chart Data in Excel	Not Started	Not Started	Not Started
Modify Chart Data How to Modify Chart Data in Excel	Not Started	Not Started	Not Started
Filter Charts How to Filter Charts in Excel	Not Started	Not Started	Not Started
Trendlines How to Add Trendlines in Excel	Not Started	Not Started	Not Started
Dual-Axis Charts How to Create Dual-Axis Charts in Excel	Not Started	Not Started	Not Started
Chart Templates How to Create Chart Templates in Excel	Not Started	Not Started	Not Started
Sparklines How to Add Sparklines in Excel	Not Started	Not Started	Not Started

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Print and Distribute			Verified Learning
Page Size and Scale How to Adjust Page Size and Scale in Excel	Account Required
Print Area and Page Breaks How to Set Print Area and Page Breaks in Excel
Print Titles, Gridlines, and Headings How to Print Titles, Gridlines, and Headings in Excel
Headers and Footers How to Add Headers and Footers in Excel
Margins and Orientation How to Adjust Margins and Orientation in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Intermediate Formulas			Verified Learning
Reference External Worksheets How to Reference External Worksheets in Excel
Absolute and Relative References How to use Absolute and Relative Cell References in Excel
Order of Operations Order of Operations in Excel
Cell and Range Names How to Add Cell and Range Names in Excel
Insert Functions How to Insert Functions in Excel
CONCATENATE Function How to use the Concatenate Text Function in Excel
PMT Function How to Use the PMT Function in Excel
Display Formulas How to Display Formulas in Excel
Date Formulas How to Use Date Formulas in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Manage Data			Verified Learning
Outline and Subtotal How to Use the Outline and Subtotal Features in Excel
Flash Fill How to Use Flash Fill in Excel
Data Validation How to Use Data Validation Rules in Excel
Import and Export Data How to Import and Export Excel Data

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Tables			Verified Learning
Insert a Table How to Insert a Table in Excel
Sort Data How to Sort Data in Excel
Filter Data How to Filter Data in Excel
Add Rows and Columns How to Add Rows and Columns to Excel Tables
Table Styles How to Apply Table Styles in Excel
Remove Duplicates How to Remove Duplicates in Excel
Slicers How to Use Slicers in Excel
Structured References How to Use Structured References in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Intermediate Formatting			Verified Learning
Apply Conditional Formatting How to Apply Conditional Formatting in Excel
Apply and Remove Cells Styles How to Apply and Remove Cell Styles in Excel
Create and Modify Cell Styles How to Create and Modify Cell Styles in Excel
Apply a Theme How to Apply a Theme in Excel

Skill	Pre-assess	Lesson	Post-assess	Learning mode
Collaborate with Excel			Verified Learning
Cell Comments How to Add, Edit, and Delete Cell Comments in Excel
Share Workbooks How to Share Workbooks in Excel
Track Changes
Protect a Worksheet How to Protect a Worksheet in Excel
Protect Workbook Structure How to Protect a Workbook's Structure in Excel
Password Protection How to Add Password Protection in Excel