Back to Courses
Beginner
Business Analysis
en
Excel: VLOOKUP and XLOOKUP for Beginners
LinkedIn Learning
Platform
· California, USA
About this course
Many Excel users hear “VLOOKUP” and envision a complicated function reserved only for power users. Not so! VLOOKUP—and XLOOKUP, the newer version for Microsoft 365 subscribers—are among Excel’s most powerful functions, yet you can master them with a few simple steps. In this mini-course, Jess Stratton walks you step-by-step through creating a simple lookup in Excel using both VLOOKUP and XLOOKUP, then shows you how to error-proof your formulas using tools like IFERROR, dropdown lists, and Excel tables. Supercharge your Excel skills and save time with these powerful lookup functions.
Prerequisite Skills
Skills you should have before taking this course
Basic Microsoft Excel usage
Basic spreadsheet concepts
Skills Gained
Skills you will develop by completing this course
Microsoft Excel
Excel Tables
VLOOKUP
XLOOKUP
Lookup functions in Excel
IFERROR function in Excel
Excel data validation and dropdown lists
Excel formulas and functions