Excel - Plain and Simple Lookups


This course is an introduction to lookup functions. Learn different types of lookup functions, when to use them, and how to quickly find answers within a dataset. Lookup functions are one of the most frequently used advanced features and this is a great place to start.


Course Outline:

1 – Outline

  • Make functions and formulas easier to read with named and data easier to access by defining and using range names.
  • Find and return specific values in a dataset with the power of VLOOKUP. One of the most used tools in higher levels of excel
  • Find values from differently structured datasets where VLOOKUP might not work.
  • Use VLOOKUP and HLOOKUP functions with true to find an approximate match.
  • Index and match – learn how to set up and use the powerful lookup function index and learn about the differences from VLOOKUP.

Enroll in this course


Need Help Finding The Right Training Solution?

Our training advisors are here for you.

USD United States (US) dollar