Excel LookUp Functions: V-LookUP, H-LookUP, X-LookUP, and Beyond

Length: 2 hours, Price: $75

To see available dates/times, use the “Choose a Session” drop down box below.

This class provides a comprehensive overview of the major LookUp functions, including V-Lookup, H-Lookup and X-Lookup, as well as matching, sorting and index functions.

This course is perfect for those of all comfort levels. No previous experience is assumed or required, but we do recommend considering our comprehensive Excel Training Class before registering for this class.  Open to All.

 

Section One – VLOOKUP, HLOOKUP, XLOOKUP
This section compares the three major Lookup functions in Excel: V-LOOKUP, H-LOOKUP and the newest function X-LOOKUP which by and large combines the functionality of VLOOKUP and HLOOKUP.  How to use and when to use each of the three LookUp functions is examined.

  • V-LOOKUP: creating, utlizing, troubleshooting
  • H-LOOKUP: creating utlizing, troubleshooting
  • Using V-LOOKUP and H-LOOKUP in combination
  • X-LOOKUP: when to use, creating, utlizing, troublshooting

Section Two – MATCH, INDEX, XMATCH
This section examines the functionality of MATCH, which is used to locate data, INDEX, which is used to retrieve data, and the new XMATCH, which expands the capabilities of each.

  • MATCH: when to use, locating data
  • INDEX: when to use, retrieving data
  • Using MATCH and INDEX in combination
  • XMATCH: functionality, when to use, locating and retrieving data

Section Three – Additional Lookup Functions
An examination of the best practices for filtering, sorting and data matching in general is covered as are the individual functions of SORT and SORTBY.

 

Question & Answer – this is a live seminar that can accommodate your questions.

Participants will receive a certificate of completion. Course materials include an easy to use reference guide and practice problems. All sessions of this class are currently virtual.  Participation is easy.  All you need is an internet connection; we will do the rest.

We have morning, afternoon and evening classes available. See the drop down menu in the section below to find available classes.

Register

Classes are listed using Eastern Time:

    If you do not receive a confirmation email after registering, please contact us at info@grant-foundation.org.