Complete Guide to Vlookup, Index Match, & IF Statement!

Focused View

Jeremy Schilling

30:25

295 View

1 - IF Statement

1 - Introduction.mp4

00:52

2 - Example 1.mp4

02:04

3 - Example 2.mp4

02:11

4 - Example 3.mp4

03:02

5 - Example 4.mp4

02:11

2 - Vlookup

6 - Introduction.mp4

00:54

7 - Example 1.mp4

03:19

8 - Example 2.mp4

02:47

9 - Example 3.mp4

02:46

3 - Index Match

10 - Introduction.mp4

00:59

11 - Example 1.mp4

03:13

12 - Example 2.mp4

01:59

13 - Example 3.mp4

04:08

Description

In-depth guide, with multiple examples, to learn everything about the Vlookup, Index Match, and IF formulas!

What You'll Learn?

Basics of the Vlookup formula.
Basics of the Index Match formula.
Basics of the IF formula.
Real world examples of the Vlookup, Index Match, and IF formulas.

Who is this for?

Beginner Excel users that need to understand the Vlookup, Index Match, and IF formulas.

More details

Description
In this course, you will learn everything you need to know about the Vlookup, Index Match, and IFÂ statement. In each section, you will learn one of the formulas listed above and there will be multiple examples to solidify your understanding. This is the one-stop location to learn the basic logic and lookup formulas!
Here are the reasons why you need to learn these formulas:
- The Vlookup and Index match formulas are used in almost all data analytics positions. These formulas alone will put you far ahead of the competition and, quite frankly, make your job way easier. Understanding lookup formulas is key to aggregating data efficiently and effectively.
- The IFÂ statement is the bread and butter logic formula that provides the foundational understanding needed to dive deeper into programming and general logic. The if statement is used almost as much as the lookup formulas and, most of the time, in tandem with the lookup formulas.
This course will make you an absolute beast in all of these formulas. Join me in conquering these core formulas! You will not be disappointed and you will be well on your way to becoming an Excel expert! With just these three formulas, you will be able to do 95%Â of your job, and personal, tasks. Let's do this!
Who this course is for:
Beginner Excel users that need to understand the Vlookup, Index Match, and IF formulas.

User Reviews

Rating

average 0

Total votes0

Focused display

Hi, I'm Jeremy. I have been in the working world for almost 7 years and all of that time has been spent in excel. From my time in college, to my current role today, excel has been a part of my daily toolkit. I’ve developed a passion for analytics, an interest in figuring out the most efficient solutions, and a love for automation.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.