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
Retake any public class up to 6 months after original class date....Read more
Interactive classes allow you to immediately try out new skills....Read more
Live instructors deliver our classes in an engaging and interactive way....Read more
Classes limited to 12 students for more individual attention....Read more