Главная
Study mode:
on
1
Start
2
Introduction to VLOOKUP
3
VLOOKUP Limitations
4
Introduction to Index and Match
5
Introduction to XLOOKUP
6
XLOOKUP - Approximate Match
7
XLOOKUP - Multiple Values Returned
8
XLOOKUP - Two Way Search
9
Conclusion
Description:
Discover the power of XLOOKUP, Excel's latest lookup function, in this comprehensive 39-minute tutorial. Learn how XLOOKUP improves upon its predecessors, VLOOKUP and Index and Match, by exploring their strengths and limitations. Master the proper usage of XLOOKUP to enhance your Excel skills and boost productivity. Explore advanced features such as approximate matching, returning multiple values, and performing two-way searches. Suitable for all Excel users seeking to leverage cutting-edge functionalities, this tutorial includes practical examples and an exercise file for hands-on learning.

Excel 2019 XLOOKUP Tutorial

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