Webinar Details / Industries / Human Resources

Excel - Mastering Lookup Functions

  • Speaker: Mike Thomas
  • Duration: 60 Minutes
  • Available All Day
Recommend to Colleague

Training Options

Note: 20% discount applies to both options if selected.

$
= $

Overview:

Many Excel users consistently ask how to solve a common data challenge: finding a specific value in one list and returning a corresponding result from a second list. Other frequent points of confusion include preventing error messages when a match isn't found and understanding the differences between various lookup functions like VLOOKUP, HLOOKUP, and XLOOKUP.

This training session is designed to provide clear, actionable answers to these questions and more, offering a comprehensive guide to mastering Excel's built-in lookup functions.

Why you should Attend:

Functions such as VLOOKUP, HLOOKUP, and XLOOKUP are among the most powerful and widely used tools in Excel. When applied correctly, they can significantly enhance the accuracy and reliability of your workbooks, save considerable time, and greatly reduce manual data entry mistakes.

Areas Covered in the Session:

  • Comparing VLOOKUP, HLOOKUP, and XLOOKUP

  • Constructing and applying LOOKUP functions effectively

  • Demystifying the TRUE and FALSE parameter in VLOOKUP

  • Using Tables to create robust, future-proof LOOKUP formulas

  • Techniques for avoiding and handling #N/A errors

  • A comparison of the INDEX/MATCH combination versus LOOKUP functions

Who Will Benefit:

This session is structured for intermediate-level users seeking to build proficiency with Excel's Lookup function family.
While the demonstration will utilize the latest version of Excel, the concepts covered are applicable to most versions. (Please Note: XLOOKUP functionality is limited to newer Excel releases.)


Mike Thomas

Author,


Top-Watched Webinars



HIPAA 2024 Training for the Compliance Officer | Duration: 90 Minutes | Speaker: Brian L Tuttle | Rec. Price: $269 | Register Now

MASTER CMS MEDICARE PECOS 2.0: NEW ENROLLMENT & VALIDATION PORTAL | Duration: 60 Minutes | Speaker: Yesenia Servin | Rec. Price: $229 | Register Now

2024 SAMHSA (42 CFR Part 2) Updates and Changes | Duration: 60 Minutes | Speaker: Brian L Tuttle | Rec. Price: $229 | Register Now

Medicare Advance Beneficiary Notice (ABN): CMS Updated Rules and Guidelines | Duration: 60 Minutes | Speaker: DAVID VAUGHN | Rec. Price: $229 | Register Now

What will you get?

In Recording
  • Access of Recording
  • Additional Handout
  • Available on Desktop, Mobile & Tablet
In Digital Download
  • Access of Recording (Lifetime Access)
  • Additional Handout
  • Available on Desktop, Mobile & Tablet

100% Trusted

Trendy and up-to-date webinars.

Subscribe now to receive updates on upcomming webinars

High-End security, GDPR & HIPAA guidelines followed.