Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
0 Hour(s) 51 Minute(s)
Language
English
Taught by
Nurture Tech Academy
Rating
1 views
Course Overview
Learn Lookup functionality in just 50 minutes
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.
Course Content
- 5 section(s)
- 8 lecture(s)
- Section 1 First thing first - References in Excel
- Section 2 Understanding Vlookup in-depth
- Section 3 Understanding Hlookup
- Section 4 Lookup - No "V" No "H" only lookup
- Section 5 Last option in Lookup Functionality - Index & Match
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
Skills covered in this course
Reviews
-
GGowtham
The content is okay, I can understand the concept. But the voice of the instructor literally dozes me off. Can add additional examples for in depth understanding
-
LLester Francis Lobo
Good course learnt about VLookup in a basic manner, but the examples could be a bit better so as to cover larger data as well, which would be helpful.
-
LLa Trice Vanderford
Easy to do. Instructor sometime was hard to understand but that did not affect my learning.
-
RRavinder Malik
Explaining is good but data used and example is so good
