Learn Vlookup in Less Than One Hour

The simplest course ever on Vlookup.
4.2 (5 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.
13 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 16
  • Length 1 hour
  • Skill Level Beginner Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2015 English

Course 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!!!

What are the requirements?

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

What am I going to get from this course?

  • 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

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Promo : Learn Vlookup In Less Than One Hour
01:45

Learn Vlookup In Less Than One Hour.

Section 2: Know Your Instructor
Instructor's Portfolio
Preview
01:37
Section 3: Prerequisites, Course Contents & Key Takeaways
01:08

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

1)Prerequisites for learning this Course

2)Course Contents

3)Key Takeaways

Section 4: Introduction to Vlookup
00:37

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

Quiz on Basic Understanding of Vlookup
1 question
Section 5: Definition of Vlookup
00:28

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

Quiz on Definition of Vlookup
2 questions
Section 6: Syntax of Vlookup
01:15

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

Download the Reading Material
2 pages
Quiz of Syntax of Vlookup
3 questions
Section 7: Cell References in Excel
01:19

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

09:08

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

Quiz On Cell References in Excel
3 questions
Section 8: Learning the Real Stuff
03:16

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.

Quiz on Vlookup with False "range_lookup"
2 questions
04:51

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.

Section 9: Errors that you might get while using Vlookup
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.

5 pages

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

Quiz on Vlookup Errors
3 questions
Section 10: Bonus
11 pages

Bonus : Excel Tips & Tricks.

Section 11: Quick Recap & My Personalized Message
00:35

Course Recap

00:45

My Personalized Message

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Kamall Arya, 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”

Ready to start learning?
Take This Course