Call us today: 0800 028 3045
NEW! Microsoft Excel Look Up Functions – LOOKUP, VLOOKUP, HLOOKUP Online Course
Find out more about our Online Training Courses
Is it right for me?
Have you started working with more data and find you can’t cross reference data easily? Have you seen others using the VLOOKUP function but have no idea how it works, or perhaps you have used it a bit but need a refresher? Then this 1 hour online trainer-led session is for you.
What will I get out of it?
By the end of the course you will know:
- How the LOOKUP function works and what its limitations are
- How to write a basic VLOOKUP function to find related information within the same worksheet
- The difference between near and exact matches in your searches
- The limitations of the VLOOKUP function
- How to build a VLOOKUP function working between different worksheets and workbooks
- How to use the HLOOKUP function
Related courses in our range
What does it cover?
LOOKUP function
- Putting together the LOOKUP function
- Applying the function to data
- Limitations of the LOOKUP function
VLOOKUP function
- Putting together the VLOOKUP function
- Applying it to a single data set
- Using VLOOKUP across different worksheets
- Using VLOOKUP across different workbooks
- Limitations of the VLOOKUP function
HLOOKUP function
- Putting together the HLOOKUP function
- Applying it to data
Course Summary
Send to a colleague
Please enter details below and click 'submit'
Tailor this course
If you are interested in this course but would like it tailored to your specific needs, contact Karen Osborn on 0800 028 3045.
Alternatively, enter your details below and one of our team will contact you.
Thales Training & Consultancy is a highly successful training services company based in Crawley. We help companies to develop advantage through learning and development. Highly trusted by leading enterprises, we deliver a full range of dedicated training solutions that enable organisations to achieve key business goals. The 4 core services we offer are Training Courses, Supply Management, Bespoke Services and Managed Services. Our successful partnerships with clients prove that the delivery and management of the right training and development can significantly enhance the pursuit of business excellence.
