Excel VLOOKUP Introduction
Who is this course aimed at?
This half-day course is aimed at anyone who would like to be able to setup and use VLookups. Applicants should have some knowledge of formulas and functions.
How long does the course last?
This is a half-day course, lasting 3 hours.
How will I benefit from this course?
At the end of this course you will have a good working knowledge of VLookups. You will feel more confident using Excel 2010 and be able to create a VLookup from scratch. Understanding and using some of the built in calculation and formula functionality will allow you to be more productive in your work and home Excel environments. Spreadsheets that you create will be easier to use and look more presentable. You will also receive a Certificate of Attendance in recognition of the new skills you have acquired.
What will the course cover?
- The 6 steps in setting up a VLookup Function
- Understanding Syntax
- Understanding #N/A or #REF! in a VLookup
- Linking worksheets using VLookup