Loading...

Course Description

Excel 2019 Level 3 builds on the concepts and skills of our Level 1 and Level 2 courses to provide advanced tools for solving real-world problems in Microsoft Excel 2019: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, what-if-analysis, and macros. Students will benefit most from this course if they want to use Excel 2019 to perform real-world tasks such as handling and getting information from large amounts of data from sources inside out and outside of Excel, creating output that varies according to conditions, manipulating dates and text, and automating repetitive tasks.

Course Outline

  • Chapter 1: Logical and Lookup Functions

       Module A: Decision-making functions

       Module B: Lookup and reference functions

    Chapter 2: Advanced Formulas

       Module A: Auditing and error-trapping

       Module B: Formula options

       Module C: Arrays

    Chapter 3: Special functions

       Module A: Date and time functions

       Module B: Text functions

       Module C: Other functions

    Chapter 4: Importing and Exporting

       Module A: The Power Pivot Data Model

       Module B: Exporting data

    Chapter 5: Analysis

       Module A: What-if analysis

       Module B: The Analysis Toolpak

    Chapter 6: Macros and Forms

       Module A: Recording macros

       Module B: Running macros

       Module C: Forms

    Appendix A: Internationalization and Accessibility

       Preparing workbooks for internationalization and accessibility

Duration

6 Hours | 1 Day or 2 Nights

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Excel III: Level 3
Type
Instructor-Led
Days
T, Th
Time
5:30PM to 8:30PM
Dates
Jun 29, 2021 to Jul 01, 2021
Schedule and Location
# of Course Hours
6.0
Delivery Option
Course Fee(s)
Rate non-credit $345.00
Potential Discount(s)
Required fields are indicated by .
*Academic Unit eligibility to be determined by college/university in which you are enrolled in a degree seeking program.