Current Status
Not Enrolled
Get Started

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. Who this course is for:

  • Working Professionals & Students

Course Content

1. First thing first - References in Excel
2. Understanding Vlookup in-depth
3. Understanding Hlookup
4. Lookup - No V No H only lookup
5. Last option in Lookup Functionality - Index & Match