ONLINE - Lookup Functions - VLOOKUP, XLOOKUP, INDEX, MATCH 5/16/2022
CPE 3 hours
9:00 a.m. – 12:00 p.m. Central Time
Method of Delivery
This class will be held online using GoToMeeting. Class participants will receive a PDF of the book and will be able to access the class files online.
When you register, be sure to use the email that you would like your GoToMeeting invitation sent to. The meeting invitation will be sent no later than 1 hour prior to the class. Check your junk mail if you do not receive an invitation, especially if you have a Gmail or Hotmail account. You do not have to have a GoToMeeting subscription to participate.
The web browser client will download automatically when you start or join your first GoToMeeting meeting and is also available for manual download here.
It is a good idea to download this prior to the online meeting.
Excel users need lookup functions to compare data and pull information from multiple sources into one source. In the online class, students will learn how to use the VLOOKUP, HLOOKUP and INDEX, MATCH functions. We will also discuss the new XLOOKUP and what versions will have access to this new function.
USING THE VLOOKUP and HLOOKUP FUNCTION
- Reviewing Basic and Comparison Operators
- Explain the Parts of a Function
- Ways to Locate and Insert Functions
- Describe the Difference in VLOOKUP and HLOOKUP
- Write a VLOOKUP using the TRUE or FALSE arguments
- Learn the MATCH Function
- Learn the INDEX Function
- Nest the INDEX and MATCH FUNCTION
- Discuss the New XLOOKUP and it’s purpose
- Keystroke Shortcuts
Who Should Attend
Intermediate users who would like to expand their knowledge and skills
An Excel Level 1 class or equivalent working knowledge. Users should understand basic functions like SUM and know basic tasks like inserting rows and adjusting column widths.
The cancellation deadline is 5 business days prior to the class. If you are unable to attend, you may send a substitute. If you are a "no show" or you do not send a substitute you will be charged full price for the class.
Cloud Training Services will consider emergency situations such as a death in the family, illness, and weather, and will make every attempt to work with the person in the event of an emergency.
|Event Date||05-16-2022 9:00 am|
|Event End Date||05-16-2022 4:00 pm|
|Cut off date||05-16-2022 8:00 am|