Excel Lookup & Reference Functions for Beginners VLOOKUP, XLOOKUP, and more in 35 minutes!
Focused View
35:47
11 View
01 Intro Why Learn Lookup & Reference Functions.mp4
01:00
02 Getting Started with the VLOOKUP Function.mp4
05:42
03 Ensuring Table Arrays are Locked.mp4
02:40
04 Ensuring Consistencies with Lookup Values.mp4
01:52
05 When to Use Approximate Match Lookups.mp4
02:20
06 The HLOOKUP function.mp4
02:16
07 The INDEX function.mp4
01:28
08 The MATCH function.mp4
01:16
09 How and Why to Combine INDEX and MATCH.mp4
03:58
10 The XLOOKUP Function.mp4
02:14
11 Using XLOOKUPs If Not Found Feature.mp4
01:15
12 Using XLOOKUPs Exact Match Modes.mp4
02:50
13 Using XLOOKUPs Wildcard Match Mode.mp4
02:30
14 Changing XLOOKUPs Search Mode.mp4
01:34
15 How to Use XLOOKUP for Horizontal Lookups.mp4
01:08
16 Using XLOOKUP for a Lookup Array to the Right.mp4
01:27
17 Next Steps.mp4
00:17
More details
User Reviews
Rating
average 0
Focused display
Category
SkillShare
View courses SkillShareSkillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.
- language english
- Training sessions 17
- duration 35:47
- English subtitles has
- Release Date 2024/02/13
