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

Excel Lookups
Feb 21 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 21-02-2020T11:00 21-02-2020T12:00 Active
21-02-2020 Active 0.00 21-02-2020
Register Now
Excel Lookups
Jun 26 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 26-06-2020T11:00 26-06-2020T12:00 Active
26-06-2020 Active 0.00 26-06-2020
Register Now
Excel Lookups
Oct 23 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 23-10-2020T11:00 23-10-2020T12:00 Active
23-10-2020 Active 0.00 23-10-2020
Register Now