When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
Excel 2016: VLOOKUP, INDEX MATCH, and Other Advanced Lookups
Master the use of lookup functions like VLOOKUP, INDEX MATCH, OFFSET, and INDIRECT to automate your work!
This Course Includes
udemy
4.3 (65 reviews )
1 total hour 
english
Online - Self Paced
course
Udemy
About Excel 2016: VLOOKUP, INDEX MATCH, and Other Advanced Lookups
JOIN DESKBRIGHT'S COMMUNITY OF THOUSANDS OF STUDENTS TO LEARN INCREDIBLE FORMULAS AND FUNCTIONS THAT WILL HELP AUTOMATE YOUR WORK IN EXCEL.
++++++++++++++++++++++++++++++++++
Created: June 2016
++++++++++++++++++++++++++++++++++
About This Course
So, you use Excel at work. And, you’ve got a handle on the basics. But you’ve got a feeling that if you just knew a little bit more about the program, you could be way more productive at work.
Unfortunately, it’s hard to figure out how to begin. Online forums and websites are crammed with confusing information, and there’s so much content out there that it’s tough to decide where to start.
Well, don’t worry — Deskbright is here to help! We’ve identified Excel’s most important features and bundled them into a series of engaging videos that make learning spreadsheets easy.
In this advanced course, we’ll cover lookups — some of Excel’s most powerful features. From common functions like VLOOKUP and HLOOKUP through more advanced formulas, we’ll cover everything you need to know to become a pro.
In this course, we'll follow a fictional company called SnackWorld as it uses Excel to extract valuable insights from its business data. All of our lessons are based on real-world uses of these functions, so you'll get to see live applications of everything you learn. You’ll get over an hour of easy-to-understand video, taught by master Excel instructor Sam McIntire. Plus, comprehensive exercises and answer keys to go along with every function you’ll learn — and a comprehensive culminating exercise to test your skills.
It’s time to stop wondering, and take your potential into your own hands. With a little bit of practice, you can make your work work look easy!
About The Instructor
This course is taught by master Excel instructor Sam McIntire of Deskbright. Through his website, Sam has helped thousands of students just like you learn the skills they need to thrive at work. Sam:
Course Benefits
What You Will Learn?
- Use VLOOKUP, INDEX MATCH, and other advanced formulas to automate work in Excel.
- Perform advanced lookups based on both rows and columns at the same time.
- Employ array functions to create complex formulas that pull data based on multiple criteria from a table.
- Use INDIRECT and OFFSET with advanced string concatenation for the most automated lookups possible in Excel.
- Save hours of work every day by automating spreadsheets.