Office Productivity Online Course by Udemy, On Sale Here
Master Microsoft Excel VLOOKUP, HLOOKUP, LOOKUP, INDEX-MATCH, XLOOKUP, XMATCH, Two-Dimensional Lookups & Data Validation
An excellent training about Microsoft
Excel Lookup Deep Dive: VLOOKUP, XLOOKUP, INDEX-MATCH & More
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 cant I just do a manual search through my data with ctrl-f and find what I need that way? And sure, thats 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?Thats 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 Excels 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 stepCopies of all the files used in the course videos so that you can follow along and practiceExercises that will challenge your understanding and deepen your lookup knowledge. By the end of this course youll 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. Theres just something about seeing your data magically populate in cells because of a complex formula that you created thats very satisfying – Ican’t wait for you to experience this for yourself and start loving lookup functions as much as Ido. 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!
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.