VLOOKUP in 30 minutes with Practical exercises

An introductory guide to VLOOKUP
Rating: 4.2 out of 5 (224 ratings)
4,530 students
English
English [Auto]
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.

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.

Course content

2 sections • 7 lectures • 29m total length
  • Introduction
    04:53
  • Excel Functions
    01:13
  • Excel Function structure: VLOOKUP Introduction
    01:21
  • Understanding the VLOOKUP parameters
    02:34

Instructor

Business Consultant
Pranay Suyash
  • 4.2 Instructor Rating
  • 224 Reviews
  • 4,530 Students
  • 1 Course

Technology enthusiast, Art lover, Looking for things to learn and share.