Loading...

Course Description

Excel 2019 provides powerful data analysis capabilities. Learn to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality. Learn to use conditional logic to construct and apply elaborate formulas and functions. This course builds upon the foundational and intermediate knowledge presented in the Introduction and Intermediate Excel 2019 course. PREREQUISITES: Intermediate Excel or equivalent experience.

 

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

  • Work with multiple worksheets and workbooks.
  • Share and protect workbooks.
  • Automate workbook functionality.
  • Use Lookup functions and formula auditing.
  • Forecast data.
  • Create sparklines and map data.

Applies Towards the Following Digital Badges

Loading...
Enroll Now - Select a section to enroll in
Section Title
Advanced Excel 2019
Type
In-Person
Days
M, W
Time
5:30PM to 8:30PM
Dates
Apr 15, 2024 to Apr 17, 2024
Schedule and Location
Contact Hours
5.5
Instructors
Section Title
Advanced Excel 2019
Type
In-Person
Days
T, Th
Time
1:30PM to 4:30PM
Dates
Apr 23, 2024 to Apr 25, 2024
Schedule and Location
Contact Hours
5.5
Location
  • Harper Learning & Career Center, Prospect Heights
Instructors
Section Title
Advanced Excel 2019
Type
In-Person
Days
T, Th
Time
1:30PM to 4:30PM
Dates
Jul 16, 2024 to Jul 18, 2024
Schedule and Location
Contact Hours
6.0
Location
  • Harper Learning & Career Center, Prospect Heights
Instructors
Required fields are indicated by .