Become an expert in Excel by learning to navigate with HLOOKUP, VLOOKUP, LOOKUP, XLOOKUP, INDEXMATCH formulas!
What you'll learn
Learn the most fundamental lookup formulas
Understand the essentials behind the most widely-used search functions
Navigate through tables and data to get exactly what you need
Become an advanced user of Excel
Requirements
Some prior knowledge of Excel is considered helpful
Excel 365 or Excel 2016 or Excel 2019
Patience and dedication to learn
Description
Excel 102! The easiest way to learn Excel's lookup and search methods available on the web!
Become comfortable to search in datasets, retrieve values and grab results based on your desire. Explore new horizons in Excel by enrolling in this course!
As a certified expert and practitioner who's worked with Excel for more than four years, I can tell you that many people think they understand how to work with Excel, while their skills are delimited by the repetitve every-day tasks and have no motivation or time to learn something new. After work most of us feel as if we don't want to even start that 20+ hours long course, as we are very well-aware we most probably won't finish it.
Excel 102 has been built and designed to make it as easy as possible for you to become the better, more knowledgable, version of Excel user in almost no-time.
Prepare yourself for a fast-paced, a dynamic, no time-waster type of a course, where everything is demonstrated on the go and presentations are used as little as possible. Every lecture has been recorded in a way to be short, concise, but at the same time not to skip over important information. The practical examples, although simple at times, will give you a better understanding of the every-day usage of the functionalities I present to you.
Who this course is for
Users who want to become more advanced in their work with Excel;
Users who want to explore more about the capabilities of Excel lookup functions;
Users who have struggle with efficient data filtering and want to make the best of their time;
Homepage

https://www.udemy.com/course/excel-102-fundamentals-of-lookup-lookups-and-referencing/