Excel Lookup Functions
O365/2021/2019/2016
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
- INDEX v/s VLOOKUP
- XLOOKUP, the future function
