Microsoft® Excel Advanced Formulas: Lookup Functions

Click Here For More Information

This more advanced Excel course will demonstrate to the user how to use formulas that extend across multiple worksheets as well as exploring the deeper function category Lookup and Reference. These will include such lookup functions as HLOOKUP and VLOOKUP, where mixed-cell referencing is featured in formulas as well as using named ranges. This course will also delve into data mining using the INDEX and MATCH functions in conjunction with each other.

Objective: Upon completion of this course the Excel user will be able to work with lookup functions along with mixed-cell referencing and named ranges. Featured functions include HLOOKUP and VLOOKUP, the LOOKUP function, as well as INDEX and MATCH.

  • Multi-sheet Formulas
    1. Grouping worksheets
  • Lookup Functions
    1. HLOOKUP
      1. Formulas with Mixed Cell Referencing
    2. VLOOKUP
      1. Using Named Ranges in formulas
    3. The LOOKUP Function
      1. Using Table Fields in formulas
    4. INDEX and MATCH

IMPORTANT INFORMATION ABOUT PARTICIPATION:  As part of our sponsorship with NASBA, we have agreed to provide at least three (3) instances of engagement per CPE hour (50 minutes).  These may come in the form of open-ended questions, hand-raising, polling, and other techniques.  You MUST answer or respond to all three opportunities to engage in order to receive credit for that CPE hour.   Knowledge Source Inc. retains these responses after all CPE classes for audit purposes.

Knowledge Source Inc. is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:

Course Information
  • Course Level:Advanced
  • Prerequisite:Microsoft® Excel Basic Formulas or equivalent knowledge
  • Credit:2 CPE Hours
  • Fee:$99
  • Delivery:Virtual Instructor-Led Live
  • Recommend Field of StudyComputer Software and Applications
  • Program Knowledge LevelAdvanced
  • Advanced PreparationDownload and install class files a minimum of 3 working days prior to class.
  • Refund PolicyRequests for cancellations must be submitted in writing and received by Knowledge Source Inc. five (5) days prior to the date of the event to receive a full refund (less a 10% processing fee). Refunds are not given for no-shows. Special circumstances and cancellation requests may be emailed to or by calling 919-878-7100. Refunds will be issued within 30 days after the course.

Related Courses