Excel 2019 XLOOKUP Tutorial
Offered By: Learnit Training via YouTube
Course Description
Overview
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.
Syllabus
Start
Introduction to VLOOKUP
VLOOKUP Limitations
Introduction to Index and Match
Introduction to XLOOKUP
XLOOKUP - Approximate Match
XLOOKUP - Multiple Values Returned
XLOOKUP - Two Way Search
Conclusion
Taught by
Learnit Training
Related Courses
Introduction to Computational Finance and Financial EconometricsUniversity of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard