Udemy, Coursera, 2U/edX Face Lawsuits Over Meta Pixel Use

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel Lookup Formulas

via YouTube

Start learning Write review

Overview

This course covers the learning outcomes and goals of mastering Excel lookup formulas such as VLOOKUP, INDEX MATCH, and XLOOKUP. Students will learn how to effectively use these formulas based on different scenarios, including SUMPRODUCT, TEXTJOIN, and AGGREGATE functions. The course teaches various formula combinations to help learners choose the best lookup formula for their specific tasks. The teaching method includes explanations, examples, and practical applications of each formula. This course is intended for individuals who want to enhance their Excel skills and proficiency in lookup functions.

Syllabus

Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples.
How to use Excel Index Match (the right way).
Advanced Excel Index Match (3 Most Effective Formulas for Multiple Criteria).
Excel 3 Ways to Lookup within Boundaries: SUMIFS, SUMPRODUCT & INDEX.
Excel INDIRECT Function: Lookup Values in Different Sheets / Excel Tabs.
Excel Reverse Lookup Problem: Find Column Header based on Value in Matrix and Row Header.
Excel Complex Lookup: Find Header based on Lookup Criteria in Matrix with INDEX & SUMPRODUCT.
Excel Formula Lookup Multiple Results: Return headers based on matrix values.
TEXTJOIN Formula in Excel: Solve Complex Lookup Problems with TextJoin.
Lookup values across multiple worksheets: VLOOKUP / INDEX MATCH in Excel.
Return Multiple Match Results in Excel (2 methods).
VLOOKUP EXPLAINED - 2 Practical Excel Lookup Examples.
Excel RANK without Skipping Numbers (Top 3 Report with Duplicates).
LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results).
Discover What XLOOKUP Can Do For YOU (R.I.P. Excel VLOOKUP).
Left Lookup in Excel with XLOOKUP (Made Easy).
How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples).
Excel DGET Function Solves 2 of Your VLOOKUP Problems.
Find Multiple Match Results in Excel (Easier Solution For ALL Excel versions).

Taught by

Leila Gharani

Reviews

Start your review of Excel Lookup Formulas

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.