Excel 2021 XLOOKUP Tutorial
Offered By: Learnit Training via YouTube
Course Description
Overview
Discover the power of XLOOKUP, Excel's latest lookup function, in this comprehensive 29-minute tutorial. Learn how XLOOKUP improves upon its predecessors VLOOKUP and INDEX/MATCH, enabling faster and more efficient table searches. Begin with a refresher on VLOOKUP, then explore XLOOKUP basics, approximate match results, returning multiple values, and performing two-way searches. Ideal for all Excel users seeking to enhance their spreadsheet skills, this tutorial provides practical examples and explanations to help you leverage XLOOKUP's capabilities and boost your Excel performance.
Syllabus
Start
VLOOKUP Refresher
XLOOKUP Basics
INDEX and MATCH
XLOOKUP - Approx Match Results
XLOOKUP - Returning Multiple Values
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