How to use Vlookup in Excel - A simplest tutorial

What you'll learn

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

Requirements

Microsoft Excel 2007/2010/2013

Description

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