Home » Software Training » Excel VLOOKUP Fundamentals

Excel VLOOKUP Fundamentals Bryan Hong

  • Level Beginner
  • 6 Lessons (1hr : 05min)
  • Audio: English

Master Microsoft Excel VLOOKUP Formula and you will be able to:

- Understand the essence of Excel Vlookup, with advanced examples!
- See how these are used in real life examples!


After this class you will learn about:
- Basic Excel Vlookup
- How to compare lists
- Overcoming Vlookup's limitation of looking to the left
- Wildcard searching in Vlookup
- 2-Way lookups
- And more Vlookup tips and tricks!

Who is it for? This course is for people who want to master Excel VLOOKUP formula and speed up in working with your data.

What will I learn? You will learn how to use the Excel VLOOKUP formula so that you can decide which one will be the best on your scenario when working with data.

Course Includes: 18 Video Lessons

Table of Contents

Section 1: Excel VLOOKUP

Menu Example with Excel Vlookup 7:34
   We use a Starbucks Menu to have fun with VLOOKUP   
Wildcard Search with Excel Vlookup 9:22
   Learn how to perform a Wildcard search with Excel Vlookup   
Looking to the Left with Excel Vlookup 16:37
   You can also look to the left with Excel Vlookup and overcome Vlookup's limitation   
2-Way Lookup 13:38
   Perform a 2-way Lookup with Vlookup   
Comparing Lists with Excel Vlookup 3:20
   See how to compare different lists with Vlookup   
Vlookup Tips and Tricks 14:26
   More Vlookup tips and tricks   

Master Microsoft Excel VLOOKUP Formula and you will be able to:

- Understand the essence of Excel Vlookup, with advanced examples!
- See how these are used in real life examples!


After this class you will learn about:
- Basic Excel Vlookup
- How to compare lists
- Overcoming Vlookup's limitation of looking to the left
- Wildcard searching in Vlookup
- 2-Way lookups
- And more Vlookup tips and tricks!

Bryan is a best-selling book author of the 101 Excel Series paperback books and a Microsoft Certified Systems Engineer with IT experience of more than 10 years.

Courses Bryan is focused on range from SQL, Excel Formulas, Power Query, Power BI, Excel Charts, Macros and much more. His passion lies in helping students in whatever means possible, whether it be reaching them via courses or by books.

Educator®

Please sign in to participate in this lecture discussion.

Resetting Your Password?
OR

Start Learning Now

Our free lessons will get you started (Adobe Flash® required).
Get immediate access to our entire library.

Membership Overview

  • Available 24/7. Unlimited Access to Our Entire Library.
  • Search and jump to exactly what you want to learn.
  • *Ask questions and get answers from the community and our teachers!
  • Practice questions with step-by-step solutions.
  • Download lecture slides for taking notes.
  • Track your course viewing progress.
  • Accessible anytime, anywhere with our Android and iOS apps.