Learn all about the power Excel functions called lookups. This class will explain the different varieties and how to use them.
Class Price: $59
Training Class Goal
Students will learn how to write formulas for both H and V lookups.
Should be comfortable writing formulas in Excel.
- Understanding the syntax of a Lookup Function in Excel
- Lookups with a Range
- Lookups with an exact match
- Looking up item codes in a sheet to return descriptions
- Using lookups to create a penalty or discount schedule
- Using Lookups in conjunction with IF statements