Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
VLOOKUP in 30 minutes with Practical exercises
Rating: 4.5 out of 5(857 ratings)
13,191 students

VLOOKUP in 30 minutes with Practical exercises

An introductory guide to VLOOKUP
Created byPranay Suyash
Last updated 10/2018
English
English [Auto],

What you'll learn

  • Increase productivity by reducing time to lookup values in a large data-set.
  • Identify & Search values within multiple sheets without having to go through each cell or even the worksheet.
  • Connect two data-sets having any common column data.

Course content

2 sections • 7 lectures • 29m total length

  • Introduction4:53

    Introduction to the class: What the next lectures contain and how the students can use this class to understand Excel functions particularly the VLOOKUP function.

    The resource file is also attached which can be used to follow along or can be used for practice by the student after the class.

  • Excel Functions1:13

    Identifies various Excel Function Groups.

  • Excel Function structure: VLOOKUP Introduction1:21

    This video provides a description of the structure of an Excel function through an example.

  • Understanding the VLOOKUP parameters2:34

    Explore how vlookup uses the lookup value, a range or table, and a column index to return data from the first column. Compare exact and approximate matches.

Requirements

  • Be able to use computers and familiar with Microsoft Excel

Description

Excel provides a vast amount of functions to help with the data. These are categorized under various headings according to the type of data they work with or according to their functionality. 

In this class we will learn to use VLOOKUP function in MS Excel. 

The VLOOKUP function is categorized as a Lookup & Reference function which can be used to:

1. Search for values

2. Link data sets

3. Find related values

Who this course is for:

  • Beginners who are using spreadsheet programs but are unfamiliar with complex functions.
  • Anyone who would like to learn a new Excel function to increase their productivity.

Report abuse