Главная
Study mode:
on
1
Start
2
Introduction
3
VLOOKUP Refresher
4
XLOOKUP Basics
5
INDEX and MATCH
6
XLOOKUP - Approx Match Results
7
XLOOKUP - Returning Multiple Values
8
XLOOKUP - Two Way Search
9
Conclusion
Description:
Discover the power of XLOOKUP, Excel's latest lookup function, in this comprehensive 31-minute tutorial. Learn how XLOOKUP improves upon its predecessors, VLOOKUP and INDEX/MATCH, and enhances your Excel performance. Begin with a refresher on VLOOKUP, then explore XLOOKUP's basics, approximate match results, multiple value returns, and two-way search capabilities. Ideal for all Excel users seeking to upgrade their skills, this tutorial provides practical examples and explanations to help you master this efficient new feature. Access exercise files and additional resources to practice and reinforce your learning.

Excel 2021 XLOOKUP Tutorial

Learnit Training
Add to list
0:00 / 0:00