Master Microsoft Excel VLOOKUP, HLOOKUP, LOOKUP, INDEX-MATCH, XLOOKUP, XMATCH, Two-Dimensional Lookups & Data Validation
InstructorRobin DavisThe curriculum covers sophisticated combinations such as INDEX-MATCH-MATCH and XLOOKUP-XLOOKUP to enable two-dimensional lookups.
Instruction includes resource workbooks that facilitate learning through practical application and exercises.
Editorial course preview
These 3 complementary views highlight concrete, legible examples from the course presentation.
This Excel screenshot demonstrates entering a VLOOKUP formula to retrieve a specific dog breed from a structured data table based on the dog's name.
This Excel table displays coffee drink prices across different sizes, highlighting the intersection of the Cortado row and Large column to demonstrate a two-dimensional lookup scenario.
The image displays an Excel Data Validation settings window configured for a list, positioned over a worksheet with a coffee menu and order fields.
The depth of examples may not satisfy those looking for high-difficulty challenges or techniques for managing very large datasets.
While visuals are clear, the delivery speed may feel accelerated for some learners.
The curriculum aligns with the target audience's goal of mastering specific lookup functions and data validation.