Learn VLOOKUP in Excel and get noticed!! | Pranay Suyash | Skillshare

Learn VLOOKUP in Excel and get noticed!!

Pranay Suyash

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
7 Videos (30m)
    • 01. Introduction

      4:53
    • 02. Excel functions

      1:13
    • 03. Excel Function structure: VLOOKUP Introduction

      1:21
    • 04. Understanding the VLOOKUP parameters

      2:34
    • 05. Practical use of VLOOKUP: Example 1

      9:30
    • 06. Practical use of VLOOKUP: Example 2

      6:55
    • 07. Practical use of VLOOKUP: Example 3 & Conclusion

      3:18

About This Class

25fa7a91

In this class, we will be taking a look at the VLOOKUP function in Excel.

VLOOKUP is one of Excel's most used functions (just after maybe Autosum and a few other date functions). It is a lookup/ search function.

VLOOKUP can be used to:

1. Find if values exist

2. Comparison

3. Linking multiple datasets

In this course, you will grasp the structure of the lookup function and through multiple practical examples, covering most use cases, you will become a master in using the function (and maybe impress your boss ;))

I hope you find this topic useful. See you in the lessons.

You can also use the attached project file to follow along or practice later.

8

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Pranay is a full-time business consultant and part-time art lover.

In his free time, he likes to pursue his hobbies in photo editing, photography, reading, and digital illustration. 

See full profile

Report class