Half-Day Rapid Training in Vancouver
Rapid Computer Training runs this course as a scheduled public course. This course is based on Excel 2019/
2016/ 2013/2010 versions. It is offered at 325 Howe St. in downtown Vancouver and also at client locations with our mobile lab.
Lookup Functions in Excel such as VLOOKUP, INDEX and MATCH are very powerful. They save you enormous time, labour and provide a great deal of accuracy and automation. Many office workers find these functions a bit tricky to use. 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 make you understand these functions easily.
Quality training is delivered by Microsoft Certified Trainers and other qualified computer professionals. The entire course is hands-on. Participants
receive custom designed exercise files and a printed course manual for practice
We can also deliver this course at your office with our mobile computer lab. Please visit our On-site Training Page for more details.
Course Fee: $250+GST/HST per participant
Course Material: $35+GST/HST each
Course Duration: Half Day (9:00AM to 12:30PM)
Course Pace/Style: Medium to fast; hands-on, intensive
Class Location: 325 Howe St, Suite 608, Dntn Vancouver
Course Schedule: Please click here Course Schedule
Skills learned in our Excel Level-1 & Level-2 courses or equivalent everyday work experience of using MS Excel.
Proficiency in Windows environment with excellent mouse skills. Some keyboard skills also required.
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
Courses can be customized to suit your training needs. Please send us a detailed email. We would be happy to provide you with the most cost effective solution.
Checkout More Course Outlines
Rapid Computer Training, Inc.
© 2005, Rapid Computer Training, Inc.