Excel Lookup Functions

CAD 325.00

Intensive, hands-on, half-day Excel Lookup Functions course delivered online by a Live Trainer and not recorded Videos. Please read prerequisites and other details in the description below.

We have distinct course dates for Pacific and Eastern Time zones. You can explore both options below.

Excel Lookup Functions

Lookup Functions in Excel such as VLOOKUP, INDEX and MATCH are very powerful. They save you enormous time and labour and provide a great deal of accuracy and automation. Many office workers find these functions a bit tricky to use however. This course is designed for persons who would like to get a good grip on LOOKUP functions. A variety of examples and hands-on exercises will help you master these functions easily.

Prerequisites: Skills learned in our Excel Beginner and Intermediate courses or equivalent everyday work experience of using MS Excel. Proficiency in Windows environment with excellent mouse skills. Some keyboard skills also required.

Course Duration: Half Day
Course Duration: Half Day
Class Times-1: 9:00 AM to 1:00 PM Pacific Time (Vancouver)
Class Times-2: 9:00 AM to 1:00 PM Eastern Time (Toronto)
Course Pace and Style: Medium-to-Fast; Hands-on, Intensive, Interactive
Course Delivery Format: OnLine and In-Person
(In-Person option is available for group training only)
Course Outline Download: Excel Lookup Functions
Cancellation & Date Change Policy: Cancellation Policy
Technical Requirements for Taking OnLine Courses: OnLine Tech Requirements

Course Outline

What is covered in the course?

  • VLOOKUP- definition & general considerations
  • When to use the Exact and Approximate Match options
  • Doing VLOOKUP from a different worksheet
  • Doing VLOOKUP from a different workbook
  • Doing VLOOKUP with wild card characters
  • Doing VLOOKUP with CONCATENATE function
  • Doing VLOOKUP with MAX function
  • Doing Multiple VLOOKUPs efficiently
  • MATCH- definition & general considerations
  • VLOOKUP and MATCH combo
  • Using VLOOKUP to compare data
  • Using VLOOKUP with IFERROR
  • INDEX- definition & general considerations
  • INDEX and MATCH combo
  • XLOOKUP, the future function


Class Start Time

9:00 AM Pacific Time, 9:00 AM Eastern Time

Course Date

07-Feb-2024, 03-Apr-2024, 29-May-2024, 24-Jul-2024, 18-Sep-2024, 13-Nov-2024, S, 21-Feb-2024, 17-Apr-2024, 12-Jun-2024, 07-Aug-2024, 02-Oct-2024, 27-Nov-2024