Excel Lookups

excel_tip
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

Excel Lookups
Jul 20 11:00 am - 12:00 pm Excel Lookups Webinar Excel Lookups Excel Lookups 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... Mission Critical Systems 20-07-2018T11:00 20-07-2018T12:00 Active
Active 20-07-2018 Active 0.00 20-07-2018
Register Now