Excel VLookup Function: Learn The VLookup Formula With Examples

Focused View

Gary Carpenter

1:34:01

141 View

01 Introduction.mp4

01:31

02 Getting Prepared For This Class.mp4

01:25

03 Why The VLookup Is Important.mp4

02:13

04 How The Vlookup Function Works.mp4

01:44

05 L1 Vlookup Into One Cell.mp4

10:38

06 L2 Vlookup Into A Column.mp4

09:50

07 L3 Vlookups In Multiple Sheets.mp4

13:28

08 L4 Common Vlookup Issues - P1.mp4

12:32

09 L5 Common Vlookup Issues - P2.mp4

15:04

10 L6 Vlookup Real-World Use Example.mp4

06:08

11 VLookup Class Project.mp4

19:28

file.zip

Description

Do you want to learn how to use the Vlookup function so you can apply it to your own job or business? Come join this easy to follow and engaging skill quest designed to take you from beginner to Vlookup pro! I will walk you through step by step how to use the VLookup formula with real world examples for you to practice along the way!

Key Features Of This Class

Hands-on Vlookup examples to practice after each lesson
Engaging class setup / structure
In-depth Class Project at the end to test your skills
Less than 2 hours

What You Will Learn

The purpose of the Excel Vlookup Function
The syntax of the Vlookup Formula (Lookup Value, Table Array, Column Index, Match Type)
The fundamental understanding of how the Vlookup function works
How to lookup values in a column and bring a matching value into a cell
How to lookup values in a column and bring multiple matching values into a column
How to perform VLookups between different sheets
Understanding absolute reference vs whole column table arrays
How to use multiple criteria to create unique lookup IDs
How to handle data on the left side of your table array comparing column
How to convert your Vlookup formula to values and when it’s important
How to convert your lookup ids to text or number quickly
How to use the TRIM formula and when it’s important to utilize
How to convert your range to a table and when it’s helpful for your VLookup
The top 10 common issues preventing your Vlookup from working / calculating and how to avoid them
And much more!

Who This Class Is For

Vlookup beginner level / no experience
Anyone who wants to improve their excel-related skills for their job or business
Anyone who wants to save time in excel by mastering the Vlookup function
Anyone looking to land a new job where understanding the Vlookup formula will help

Materials Needed

Microsoft Excel 2013 or greater
A computer

About The Teacher

Founder of Skill Quests, an educational course creation company providing valuable skill-based training experiences that are engaging, interactive, and fun
Over 10 years of real-world Field Development, Data Analytic, and Microsoft Product Experience

Upon Completion Of This Class

I would love to hear your feedback and comments once you complete the course. Feel free to ask any questions and/or leave a review.
Feel free to follow us on our social media platforms.

So let’s get this quest started! I can’t wait to see your class projects!

What You'll Learn?

Business
Excel
Microsoft Excel
Vlookup
Business Analytics
Writing Formulas In Excel
Vlookup Function

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Excel

Excel Formulas and Functions

Gary Carpenter

Instructor's Courses

Hello, I'm Gary, a sr. data analyst with over 10 years of real-world field development, data analytic, and Microsoft product experience. I'm also the founder of Skill Quests, which provides valuable skill-based training experiences that are engaging, interactive, and fun. I have a passion for teaching and I'm very excited to be able to create these classes for you!

SkillShare

View courses SkillShare

Skillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.