Loading...

Course Description

This course will deepen your understanding of the powerful data analysis capabilities of Excel that you learned in Excel Parts 1 and 2. You will learn to collaborate seamlessly, automate tasks, and master conditional logic for complex formulas. Ideal for enhancing your Excel skills for data-driven decision-making and efficient collaboration, this course covers both the desktop and Microsoft 365 versions, including Excel for the web and OneDrive skills. 

Course Outline

  • Lesson 1: Working with Multiple Worksheets and Workbooks
    • Use Links and External References
    • Use 3-D References
    • Consolidate Data
  • Lesson 2: Sharing and Protecting Workbooks
    • Collaborate on a Workbook
    • Protect Worksheets and Workbooks
  • Lesson 3: Automating Workbook Functionality
    • Apply Data Validation
    • Search for Invalid Data and Formulas with Errors
    • Work with Macros
  • Lesson 4: Using Lookup Functions and Formula Auditing
    • Use Lookup Functions
    • Trace Cells
    • Watch and Evaluate Formulas
  • Lesson 5: Forecasting Data
    • Determine Potential Outcomes Using Data Tables
    • Determine Potential Outcomes Using Scenarios
    • Use the Goal Seek Feature
    • Forecast Data Trends
  • Lesson 6: Creating Sparklines and Mapping Data
    • Create Sparklines
    • Map Data

Learner Outcomes

This course may be a useful component in your preparation for the Microsoft Excel (Microsoft 365 Apps): Exam MO-210 and Microsoft Excel Expert (Microsoft 365 Apps): Exam MO-211 certification exams. 

Prerequisites

Excel Part 2 (Microsoft 365) LCT0087 or equivalent experience 

Textbooks:

An e-book is included in the price of this class. You will receive a unique access key for your e-book from the instructor on the first day.

If you prefer to have a hardcopy of the textbook, you may purchase it from the Harper Bookstore.

Applies Towards the Following Digital Badges

Loading...
Enroll Now - Select a section to enroll in
Section Title
Excel Part 3 (Microsoft 365)
Type
In-Person
Days
M, W
Time
6:00PM to 9:00PM
Dates
Dec 01, 2025 to Dec 03, 2025
Schedule and Location
View Details
Contact Hours
6.0
Location
  • Harper Learning & Career Center, Prospect Heights
Course Fee(s)
Tuition and Fees non-credit $299.00
CEUs
0.6 CEUs
Instructors
Reading List / Textbook
Section Notes
Section Title
Excel Part 3 (Microsoft 365)
Type
In-Person
Days
M, W
Time
6:00PM to 9:00PM
Dates
Apr 20, 2026 to Apr 22, 2026
Schedule and Location
View Details
Contact Hours
6.0
Location
  • Harper Learning & Career Center, Prospect Heights
Course Fee(s)
Tuition and Fees non-credit $299.00
CEUs
0.6 CEUs
Instructors
Reading List / Textbook
Section Notes
Required fields are indicated by .