Excel Lookups

Excel
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.

Prerequisites

Should be comfortable writing formulas in Excel.

Topics Covered

  • Understanding the syntax of a Lookup Function in Excel
  • Vlookups
  • Hlookups
  • 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

Upcoming Classes

No Events