YoVDO

Excel 2021 XLOOKUP Tutorial

Offered By: Learnit Training via YouTube

Tags

Microsoft Excel Courses VLOOKUP Courses XLOOKUP Courses

Course Description

Overview

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.

Syllabus

Start
Introduction
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

Análisis de datos: Llévalo al MAX()
Delft University of Technology via edX Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera Data Processing and Analysis with Excel
Rochester Institute of Technology via edX Grab Data Fast with Vertical and Horizontal LOOKUP
Coursera Project Network via Coursera Evaluate Profit Margins with VLOOKUP in Google Sheets
Coursera Project Network via Coursera