VLOOKUP in 30 minutes with Practical exercises

VLOOKUP in 30 minutes with Practical exercises, available at Free, has an average rating of 3.47, with 8 lectures, based on 575 reviews, and has 10882 subscribers.

You will learn about 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. This course is ideal for individuals who are Beginners who are using spreadsheet programs but are unfamiliar with complex functions. or Anyone who would like to learn a new Excel function to increase their productivity. It is particularly useful for Beginners who are using spreadsheet programs but are unfamiliar with complex functions. or Anyone who would like to learn a new Excel function to increase their productivity.

Enroll now: VLOOKUP in 30 minutes with Practical exercises

Summary

Title: VLOOKUP in 30 minutes with Practical exercises

Price: Free

Average Rating: 3.47

Number of Lectures: 8

Number of Published Lectures: 7

Number of Curriculum Items: 8

Number of Published Curriculum Objects: 7

Original Price: Free

Quality Status: approved

Status: Live

What You Will 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.

Who Should Attend

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.

Target Audiences

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.

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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: Excel Functions

Lecture 3: Excel Function structure: VLOOKUP Introduction

Lecture 4: Understanding the VLOOKUP parameters

Chapter 2: Practical Exercises

Lecture 1: Practical use of VLOOKUP: Example 1

Lecture 2: Practical use of VLOOKUP: Example 2

Lecture 3: Practical use of VLOOKUP: Example 3

Instructors

Pranay Suyash
Founder

Rating Distribution

1 stars: 22 votes
2 stars: 38 votes
3 stars: 114 votes
4 stars: 195 votes
5 stars: 206 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu