Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More
What you'll learn
- How to use Excel lookup functions including VLOOKUP, HLOOKUP, INDEX-MATCH, LOOKUP, XLOOKUP, and XMATCH
- How to add data validation to make your lookup projects more interactive and easier to use
- How to correct the errors that most commonly arise when creating lookup formulas
- How to create and use named ranges in lookup projects
- How to create nested lookup functions
- How to perform two-dimensional lookups
Requirements
- Access to Excel 2010 or later
- Basic Excel skills (e.g., ability to create basic formulas and use simple functions such as SUM and AVERAGE)
Description
As an Excel user you've probably heard a lot about VLOOKUP and other lookup functions. But what can lookup functions do, why should you use them, and how can they help you?
In essence, lookup functions search through data and return specific values. You may be asking yourself, “Well, why can’t I just do a manual search through my data with ctrl-f and find what I need that way?” And sure, that’s fine if you only need to look up one or two things. But what if you have ten, a hundred, or even thousands of things you have to search for and search through?
That’s where lookup functions come in, they are all about making Excel do the work for you. They can help you to quickly and efficiently retrieve data which saves you time and effort.
This course is a comprehensive deep dive into Excel’s lookup functions including (but certainly not limited to) the ever-popular VLOOKUP, my personal favorite, INDEX-MATCH, and the new function, XLOOKUP. It will give you a solid foundation of lookup function knowledge, but also challenge you to learn about and create nested and two-dimensional lookup functions that can really take your Excel capabilities to the next level.
In this course you'll get:
Detailed video walkthroughs so that you can feel confident about each step
Copies of all the files used in the course videos so that you can follow along and practice
Exercises that will challenge your understanding and deepen your lookup knowledge.
By the end of this course you’ll be able to confidently use lookup functions, perform two-dimensional lookups, create nested lookup functions, use data validation in your lookup projects, and know how to correct common errors, among many other things.
And while I hope that you love the course, Udemy has a 100% 30-day money back policy so you can try the course risk-free and can request a total refund if it's not meeting your expectations.
I'm so excited to teach this course because Excel lookup functions are my absolute favorite. There’s just something about seeing your data magically populate in cells because of a complex formula that you created that’s very satisfying - I can't wait for you to experience this for yourself and start loving lookup functions as much as I do. So check out one of the preview lectures for some free lookup function knowledge and a peek into my teaching style, or if you're ready to learn all you can about lookup functions right now click the "Buy now" button and I'll see you in there!
Who this course is for:
- The Excel user who wants to be able to confidently use lookup functions
- The Excel user who wants to gain a deep understanding of how lookup functions work and wants to learn more than just how to use VLOOKUP
- The Excel user who is looking to enhance their knowledge of Excel and learn lookup concepts that can take their productivity and efficiency to the next level
Instructors
- 4.8 Instructor Rating
- 409 Reviews
- 10,224 Students
- 1 Course
Hello, I'm Robin. I specialize in creating instructional videos that are easy to understand and help users feel confident in their skills. l am passionate about teaching through video and have my own business, Redbird Tutorials, where I make software and web app tutorial videos for clients such as QuickBooks.
When it comes to Excel, I have over two decades experience using it in both corporate and government environments for companies such as Lockheed Martin, Amtrak, Loews Hotels, and the Maryland Transit Administration. I’m always so excited to share my Excel expertise with students because I know that having the right Excel skill set can vastly improve office productivity and efficiency.
I design my courses so that complex subjects feel approachable and I break down difficult concepts into smaller, digestible pieces so that they are easier to understand. Excel is complicated, but my course videos include multiple detailed examples and guided walkthroughs so that you feel supported every step of the way.
I want to see each of my students succeed and am here to help you in your Excel learning. You can contact me at any time with messages or questions.
- 4.6 Instructor Rating
- 40,840 Reviews
- 442,295 Students
- 21 Courses
Learning is easier with the right tools and instruction. In every one of my courses I take you step-by-step through the tools and knowledge you need to accomplish your goals.
My talent is taking complex subjects (like Excel, Access and Photoshop) and making them simple to learn. I wasn't always good at technology. There was a time when I didn't even know how to correctly turn a computer on and off. But over the past 20 years I've dedicated myself to mastering technology. Now I'm proud to call myself a self-taught tech geek.
I'm a geek who still speaks the language of normal human beings. I don't use a lot of jargon and fancy words that the average person doesn't understand.
I understand how frustrating it can be when the instructor goes too fast or leaves out critical steps in the learning process. That's why I make sure to clearly demonstrate each step for you visually, so you can follow along starting from the very beginning and going along until you've reached mastery.
I am here to guide you on your way to success. You can contact me at any step of the way for assistance. Let me know when you're struggling with a concept and I'll get right back to you to keep you moving in the right direction.
I'm always happy to help. I believe in you, and I'm here to support you in your learning process.
Are you ready to take your skills to the next level? It all starts with knowledge, and my courses make that part easy.
Sign up for a course today and I'll help you reach the level of success you deserve.
I'll see you in there!