Learn Vlookup in Less Than One Hour
4.4 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
23 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Learn Vlookup in Less Than One Hour to your Wishlist.

Add to Wishlist

Learn Vlookup in Less Than One Hour

The simplest course ever on Vlookup.
4.4 (8 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
23 students enrolled
Created by Kamall Arya
Last updated 4/2016
English
Current price: $10 Original price: $20 Discount: 50% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 32 mins on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Super Quick Understanding of Vlookup Definition
  • Detailed Understanding of Vlookup Syntax
  • Detailed Understanding of Cell References in Excel
  • Practical Understaning of the Vlookup Function
  • Knowledge of Errors that might come up while using Vlookup
  • Reading Material on Types of Vlookup Errors
  • Download Material on Vlookup with False "range_lookup" argument
  • Download Material on Vlookup with True "range_lookup" argument
  • Bonus on Excel Tips & Tricks For Making Your Job easier
View Curriculum
Requirements
  • Prior Understanding of Basic Excel
  • Working Knowledge of Basic Excel Formulas
Description

Are you struggling hard to learn the Vlookup function?

Have you wasted a lot of money in buying Vlookup Ebooks & Video Tutorials which are difficult to understand?

Do you feel that “Vlookup” is not your cup of tea?

You have an excel exam tomorrow and Vlookup is a sure shot question.

Looking for a Very Simple Vlookup Tutorial then “Yes”…You have come to the right place.

You will learn and master the Vlookup function in less than one hour. And…that’s my promise to you!

Prerequisites for learning this Course

  • Basic Understanding of Microsoft Excel
  • Working Knowledge of Basic Excel Formulas

Contents and Overview

Vlookup is one of the easiest database functions in Microsoft Excel however the least understood.

In over 45 mins of content including 15 lectures, we will cover the Introduction of Vlookup, Definition of Vlookup, Syntax of Vlookup, Basics of Cell References, Types of Cell References i.e. Relative and Absolute Cell References, Vlookup with False "range_lookup" & Vlookup with True "range_lookup" with practical examples and the Types of Errors that you might get while using the Vlookup function via practical examples.

You will be able to check your understanding by attempting the quizzes and by downloading and referring to Supplementary materials.

This course is perfect for anyone who is facing difficulties in understanding the Vlookup Function, Students Learning Excel at School or College, Excel Enthusiasts, Aspiring MIS Specialists, HR Professionals, Payroll Specialists, Business Analysts etc.

Upon Completion of this course you will:

  • Become a master of Vlookup,
  • Have a solid understanding of the Meaning & Types of Cell References.
  • Be able to distinguish between Vlookup - False "range_lookup" argument & Vlookup -True "range_lookup" argument and scenarios where they are used
  • Have a practical understanding of Vlookup Errors.
  • Knowledge of Excel tips & tricks which will make your Job easier.

Wait…..That’s not all!!!

You will get a lifetime access to these Videos, Quizzes, Supplementary materials and Discussion section.

So what are you waiting for?

Get yourself enrolled in this course right away and Show the World that Vlookup is no more a challenge for you.

Enrol Now!!!

ENROLL-BRING-SWARM-ADD-FLOCK-EMBRACE-ENCHANTED-BE.

RUSH-REACH-AMAZING-students-WITH-SPEED-WOLF-TOUCH-JACKPOT-BONUS

REACH COUNT NOW

SHREEM BRZEE 

Who is the target audience?
  • Excel Enthusiasts
  • Aspiring MIS Specialists, HR Professionals, Payroll Specialists,Business Analysts
  • Students Learning Excel at School or College
  • Anyone who is facing difficulties in understanding the Vlookup Function
Students Who Viewed This Course Also Viewed
Curriculum For This Course
+
Promo : Learn Vlookup In Less Than One Hour
1 Lecture 01:45

Learn Vlookup In Less Than One Hour.

Preview 01:45
+
Know Your Instructor
1 Lecture 01:37
+
Prerequisites, Course Contents & Key Takeaways
1 Lecture 01:08

In this Video, I will walk you through the following:

1)Prerequisites for learning this Course

2)Course Contents

3)Key Takeaways

Preview 01:08
+
Introduction to Vlookup
1 Lecture 00:37

In this lecture, I will walk you through the basics of Vlookup..

Preview 00:37

Quiz on Basic Understanding of Vlookup
1 question
+
Definition of Vlookup
1 Lecture 00:28

In this lecture, I will walk you through the definition of Vlookup.

Preview 00:28

Quiz on Definition of Vlookup
2 questions
+
Syntax of Vlookup
2 Lectures 01:15

In the lecture, I will walk you through the Syntax of Vlookup.

Preview 01:15

Download the Reading Material
2 pages

Quiz of Syntax of Vlookup
3 questions
+
Cell References in Excel
2 Lectures 10:27

Post completion of this lecture, you will have a solid understanding of meaning & definition of "Cell References"

Preview 01:19

Post completion of this lecture, you will have a solid understanding of Relative & Absolute Cell References.

Preview 09:08

Quiz On Cell References in Excel
3 questions
+
Learning the Real Stuff
2 Lectures 08:07

In this lecture, I will explain you about the usage/functioning/working of Vlookup with False "range_lookup" argument using a Real Life Scenario.

Have attached a Supplementary Practice Worksheet. Please download and practice in the attached worksheet post watching this lecture.

Using Vlookup with False "range_lookup"
03:16

Quiz on Vlookup with False "range_lookup"
2 questions

In this lecture, I will explain you about the usage/functioning/working of Vlookup with True "range_lookup" argument.

Have attached a Supplementary Practice Worksheet. Please download and practice in the attached worksheet post watching this lecture.

Using Vlookup with True "range_lookup"
04:51
+
Errors that you might get while using Vlookup
2 Lectures 05:09

In this lecture, I will walk you through the type of errors that you might encounter while using/applying the Vlookup function.Have incorporated a few examples for your understanding and reference.

Types of Errors that you might get while using Vlookup
05:09

Here is the download material on ""Types of Vlookup Errors"

Download the Reading Material
5 pages

Quiz on Vlookup Errors
3 questions
+
Bonus
1 Lecture 00:00

Bonus : Excel Tips & Tricks.

Excel Tips & Tricks For Making Your Job A Lot Easier
11 pages
1 More Section
About the Instructor
Kamall Arya
4.4 Average rating
8 Reviews
23 Students
1 Course
Human Resources Professional

Kamall Arya is a perseverant, diligent & self-motivated Human Resource Professional with rich experience of over 10 Years in Call Center Operations, Manufacturing, Retail and Education Space. He is an effective communicator with exceptional relationship management skills and ability to relate to people at all levels of business and management. High on moral ethos and ever ready to face and meet challenging situations and is committed to deadlines with care, concern and compassion.

Talking about his qualifications, he holds a Masters Degree in Business Administration (Human Resources & Finance Management) & a Bachelor Degree in Computers and a few certifications in Recruitment & HR Labor Laws as well. Has a sound hand-on expertise in Talent Management, Learning & Development, Employee Engagement, Compensation & Benefits Management, Compensation Mapping, Formulation and Implementation of Policies & Strategies, Organizational Development-Culture Building, Mentoring & Capability Building, Designing HR Formats, Templates and Preparation of MIS Trackers, Reports & Analysis and ensuring timely Statutory Compliances.

Kamall Arya strongly believes that learning never stops for those who value learning and is passionate about sharing his knowledge gained through various hands on experiences and perseverance. He has been training people on Human Resources, Organizational Development, Succession Planning, Branding, Leadership Development, Change Management, Business Management and Microsoft Excel - Basic & Advanced at all management levels. Besides in-house corporate achievements, he is a thorough outdoors person, which includes active sports and adventure tourism. These activities not only focus on a positive frame of mind but ensure a healthy living style as well.

His favorite cuisines Include Indian, Chinese and Italian as well.

Favorite Quotes

a) “Everyone is my teacher. Some I seek. Some I subconsciously attract. Often I learn simply by observing others. Some may be completely unaware that I’m learning from them, yet I bow deeply in gratitude.” - Eric Allen

b) “Success is not final, failure is not fatal: it is the courage to continue that counts.” - Winston S. Churchill

Kamall Arya’s Secret for High Octane Performance & Success

a) Keep self motivated by drawing inspiration from the Leaders

b)Take stock of your competitive landscape

c) Maintain positive attitude in stressful situations

d) Get a Full Sleep and maintain a Healthy Diet

e) Keep self updated with latest trends and updates

All Time Favorite Word

“Finesse”