If you work in finance, audit, accounting, or tax, mastering Excel functions like VLOOKUP and XLOOKUP is essential. This course teaches you how to use VLOOKUP to compare spreadsheets, find missing data, and connect multiple sources into one report—all of which can save you time and make you stand out in your team. You’ll start with simple examples and progress to advanced techniques explained in plain language.
The course also introduces XLOOKUP—the powerful modern alternative to VLOOKUP available in Microsoft 365—with 14 dedicated lessons. Practice files are included so you can follow along with the tutor. Plus, enjoy 3 bonus lessons on Pivot Tables, In-Cell Dropdowns, and Password Protection to further boost your Excel skills.
This course includes: