How to use Vlookup in Excel – A simplest tutorial

Learn Lookup functionality in just 50 minutes

4.0 (679 ratings)

9,784 students enrolled
Last updated 12/2013
 English
 English [Auto-generated]
Includes
  • 1 hour on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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 is the target audience?
  • Working Professionals & Students

 

How to use Vlookup in Excel – A simplest tutorial.zip   (download)
163.79 MB

 


ترك الرد

Please enter your comment!
Please enter your name here