MS Excel – Lookup, Match and Compare Data

Start Dates: TBC

Duration: 1hour and 30minutes

Location: Virtual Sessions

https://www.ifsskillnet.ie Book Now

Programme overview

This session will cover more advanced Functions in Excel such as Vlookup and Match and Index to perform more complex lookups of data.

Learning outcomes

  • Participants will be able to use more advanced Functions in Excel such as Vlookup and Match and Index to perform more complex lookups of data.

Who is the course for?
Participants should be proficient Excel users.

Modules

  • When to use a Lookup function
  • How to create a formula using the Lookup function
  • Vlookup versus Hlookup
  • How to check your data
  • How to return an exact match
  • When and how to use range names in the lookup function
  • Branch when errors / non match occurs
  • Using the Match function within the Lookup
  • Using the Match and Index function instead of lookup
  • Which functions to use when more than one lookup is needed

Trainer Profile