Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Microsoft Excel - Master VLOOKUP and Key Excel Features
Rating: 4.6 out of 5(52 ratings)
325 students

Microsoft Excel - Master VLOOKUP and Key Excel Features

Quickly Master Using VLOOKUP, HLOOKUP , Other Functions & Features to Maximize Your Productivity & Efficiency in Excel
Created byKerron Duncan
Last updated 6/2023
English
English [Auto],

What you'll learn

  • Master using VLOOKUP both at a basic and advance level.
  • Learn to combine VLOOKUP with IFERROR, MATCH and other features in Excel to boost efficiency and automate your reports.
  • Bonus: Learn to use VLOOKUP's cousin HLOOKUP.
  • Build a dynamic Dashboard by combining VLOOKUP and MATCH.

Course content

4 sections • 14 lectures • 1h 18m total length

  • Course Structure1:01
  • Introduction into Using VLOOKUP7:14

    You can follow along with me using the Practice File.

    Use Exercise File to test your knowledge as directed through the course.

    Review the Solutions File to ensure you got the correct answers.

  • VLOOKUP & Proper Referencing - Part I6:18

    Master VLOOKUP by understanding relative and absolute references, fix table array errors, and learn to copy formulas down to retrieve correct quantities for product numbers.

  • VLOOKUP & Proper Referencing - Part II6:55

    Learn to use vlookup and proper referencing to fetch quantities, prices per unit, and product names from a table using an exact match, absolute and relative references, and drag-fill.

Requirements

  • Basic Excel Experience

Description

I not only benefited greatly from this course but I truly enjoyed every minute of it! Kerron did a stellar job in teaching with clarity and simplicity. It's super easy to follow along and he is very motivating! Hands down one of the best instructors I have come across in Microsoft Excel, can't wait for the next course! - D. Samaroo

I really enjoyed the course! I wasn't that interested in Microsoft Excel so I was surprised to see how useful it can be. The teacher was well organized, the lessons were structured in a logical, easy to follow method. His explanations were clear and understandable and the exercises he gave really helped to cement the things I was learning. 10/10 definitely would recommend. JB

Enroll in this course to master using VLOOKUP and HLOOKUP. You will be able to get that job or that pay raise that requires that you master VLOOKUP. The course walks you through the basics of using VLOOKUP so that you don't get overwhelmed, then step by step you will learn more advance ways of using VLOOKUP which will surpass the average use of this powerful function in Excel. You will learn how to significantly boost your productivity and impress your Boss because of the time that you will save once you become a master in using VLOOKUP. HLOOKUP and other functions are also covered. The topics the course will take you through and the learning outcomes are as follows:

  • Learn the Fundamentals of Using VLOOKUP

  • Learn the Fundamentals of Using HLOOKUP

  • Master Absolute, Relative and Mixed Referencing to Prevent VLOOKUP Errors

  • Make VLOOKUP More Readable Using Named Arrays

  • Deal With VLOOKUP Errors Using IFERROR

  • Learn How and When to Search for Approximate Matches

  • Use Dropdowns to Return Dynamic Statistics from VLOOKUP and HLOOKUP

  • Nest VLOOKUP and MATCH to Perform More Dynamic and Automatic Lookups

The fact that you read this far means that you know that this course is worthwhile for you. So what are you waiting on? I'll love to see you in the classroom.

Who this course is for:

  • Anyone that wants to master using VLOOKUP fast and unleash the true power of this Function.
  • The course also teaches other topics that will help you use VLOOKUP at a PRO level.

Report abuse