How to use references, Vlookup, Hlookup, Lookup, Index & Match
Learn whole lookup functionality from Microsoft Certified trainer from your own desk.
Suitable for beginners to advanced users. ideal for users who learn faster when shown.
Functions explained in most logical and simplest manner
Downloadable exercise files for practical learning
Microsoft Excel 2007/2010/2013
In this lookup functionality video course, Nurture Tech Academy introduces you to the most simplest way to understand Vlookup and other lookup functions.
In this Excel training course, you will learn by watching the author actually perform the operation he is instructing on, as he explains step by step how to perform these functions. The training starts with understanding references and how excel reacts on the same. Then it will show you how to use Vlookup and then gradually moves to the next level in lookup functionality like Vlookup with False, Vlookup with True, Vlookup with if function, Hlookup, Lookup and ultimately combines Index & Match.
By the completion of this online training course, you will be fully versed, and capable of using any function in lookup functionality in Microsoft Excel 2007/2010/2013 in a commercial Environment.
Nurture Tech Academy was founded in 2009. Its a Microsoft Authorised Testing Centre, providing a blend of instructor-led and online training programs in Basic Excel, Advanced Excel, VBA, Macros, and other MS Office applications. It has a team of Microsoft Certified Trainers who are specialist in their respective fields. All trainers have a 9+ yrs. of training experience.