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 

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
9:30AM to 12:30PM
Dates
Oct 14, 2024 to Oct 16, 2024
Schedule and Location
View Details
Contact Hours
6.0
Location
  • Harper Learning & Career Center, Prospect Heights
Course Fee(s)
Tuition and Fees non-credit $279.00
CEUs
0.6 CEUs
Section Title
Excel Part 3 (Microsoft 365)
Type
In-Person
Days
T, Th
Time
1:30PM to 4:30PM
Dates
Dec 03, 2024 to Dec 05, 2024
Schedule and Location
View Details
Contact Hours
6.0
Location
  • Harper Learning & Career Center, Prospect Heights
Course Fee(s)
Tuition and Fees non-credit $279.00
CEUs
0.6 CEUs
Required fields are indicated by .