
Welcome to the VLOOKUP Course. After this course you'll feel more comfortable doing VLOOKUPs than you do driving a car. We'll start from the very beginning to some of the most advanced aspects to make you a Pro at VLOOKUPs
I've prepared a downloadable assignment for you! Be sure to practice what you learned instead of watching the lectures. We learn by doing, not watching!
In this lecture, we'll start off by introducing the basics of a VLOOKUP. Follow along with the downloadable content, so that you can make your own!
In this lecture, we learn about features that allow us to properly copy and paste VLOOKUPs to multiple cells .
Here we'll learn how to make your table_arrays (ranges that you look in) dynamic. Being dynamic means that your formulas update automatically to the table size you're looking for.
In this lesson, we'll go over how use VLOOKUPs to group by numerical buckets. This isn't commonly used as there are alternatives (such as Nested-Ifs), but they are long and tedious! Here's a better way.
In this lesson we'll go over Wildcard Characters. This powerful feature lets you search for open-ended values in your VLOOKUPs.
Here we'll go over the possible error codes that you might run into such as #N/A and #REF. By the end of this lecture you will know exactly what they mean and how to solve them.
Here, we'll learn about the HLOOKUP (or Horizontal Lookup). This is very similar to VLOOKUP (Vertical Lookup). Let's get some practice in to nail down the concept.
INDEX-MATCH can be used when looking for values to the left, since VLOOKUP can only look right. This is a known benchmark that managers use to measure an analyst's Excel skills. Use this and you will impress.
XLOOKUPs are like VLOOKUPs, but with all the bells and whistles. In this lecture, we'll review all of XLOOKUP's features.
EXPERT CONCEPT. #N/A can be a little confusing at times. Here are some ways you can debug even further.
VLOOKUP is arguably Microsoft Excel's most powerful tool. If you are pulling data from datasets over 100 rows, then this is a MUST KNOW.
If you don't know how to use VLOOKUPs, you can look up your data manually, but there are three major problems with going this route:
Manual lookups take a looooooooooong time
They are boring.
They are very prone to errors.
So you have a slow, time-consuming, error-prone process... Or you can take these ten short lectures, become a PRO, and do the same work in a fraction of the time. Dare I say, you might even begin to enjoy using MS Excel?
We break down the course with the most basic concepts and have you writing your first VLOOKUP right away. From there we take a look at the concepts that only the Experts know. Lastly, we'll go over several of VLOOKUP's cousin functions that are so similar to VLOOKUP that you'll pick it up in no time.
I've prepared for you the following features:
3 Modules - 10 lectures worth of video content to breakdown each topic, bit by bit ($113 value)
3 Quizzes - one at the end of every Module to review the concepts you learned ($31 value)
3 Downloadable Excel Sheets to help practice what you've learned ($77 value)
Unlimited access to a CFA Charter holder with 10+ years experience in some of the top-tier hedge funds on Wall St (PRICESSLESS)
I can't wait to make this transformation with you. But if you don't believe that this is absolutely the best course you've ever taken on VLOOKUPs please take advantage of Udemy's 30 day Money Back Guarantee.
Introducing... XLOOKUPs!
The Microsoft team has been cooking in the lab, and they did a great job with this one! XLOOKUPs introduce a flexibility to VLOOKUP that will save you even more time. If you have Microsoft Suite 365, you'll learn how to take advantage of every single feature it has to offer.
Reading this intro will take more effort than it will to learn VLOOKUPs like a Pro. If you've made it this far, then you're ready. Sign up for this course by clicking the "Buy Now" button to the right.