Skill Level Intermediate
- [Dennis] For many Excel users, some of the most important functions they use are lookup functions. In this course, I'll be covering many of those functions, including the widely used VLOOKUP, as well as the all-important XLOOKUP, destined to replace both VLOOKUP and HLOOKUP, while expanding the capabilities of both of those functions. I'll also be showing you some of the newer dynamic array lookup functions, like unique, filter, sort, and sort by, changing the way you use Excel and opening up new horizons as you work with formulas and functions. Hi, I'm Dennis Taylor. I've been working with Excel for many years and I'm looking forward to showing you many of Excel's powerful and important lookup functions.