Excel 102 - Fundamentals of Lookup. Lookups and Referencing
Excel 102 - Fundamentals of Lookup. Lookups and Referencing
Duration: 2h 21m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 959 MB
Genre: eLearning | Language: English
Duration: 2h 21m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 959 MB
Genre: eLearning | Language: English
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;
More Info