Loading...

Course Description

Ideal for enhancing your data analysis and presentation abilities in a professional setting, in this course you will expand your Excel skills and learn how to create advanced workbooks to organize data and extract insights to make them easier to interpret and present to others. You will be able to analyze large datasets and extract actionable information. Explore advanced Excel features like charts, graphic objects, and data sorting/filtering for comprehensive data management. 

Course Outline

  • Lesson 1: Working with Functions
    • Work with Ranges
    • Use Specialized Functions
    • Work with Logical Functions
    •  Work with Date and Time Functions
    •  Work with Text Functions
  • Lesson 2: Working with Lists
    •  Sort Data
    • Filter Data
    • Query Data with Database Functions
    • Outline and Subtotal Data
  • Lesson 3: Analyzing Data
    • Create and Modify Tables
    • Apply Intermediate Conditional Formatting
    • Apply Advanced Conditional Formatting
  • Lesson 4: Visualizing Data with Charts
    • Create Charts
    • Modify and Format Charts
    • Use Advanced Chart Features
  • Lesson 5: Using PivotTables and PivotCharts
    • Create a PivotTable
    • Analyze PivotTable Data
    • Present Data with PivotCharts
    • Filter Data by Using Timelines and Slicers

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 1 (Microsoft 365) LCT0086 or equivalent experience

Applies Towards the Following Digital Badges

Loading...
Enroll Now - Select a section to enroll in
Section Title
Excel Part 2 (Microsoft 365)
Type
In-Person
Days
M, W
Time
5:30PM to 8:30PM
Dates
Jul 14, 2025 to Jul 16, 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 2 (Microsoft 365)
Type
In-Person
Days
M, W
Time
6:00PM to 9:00PM
Dates
Nov 10, 2025 to Nov 12, 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
Required fields are indicated by .