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

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

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!

Please, take into account that XLOOKUP and the SPILLING functionality in Excel that I demonstrate here, are only available in EXCEL 365.

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;

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;