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.

$
= $

Mastering Excel Lookup Functions

Overview

Do you often ask:

  • “How do I look up a value in List ONE and pick up a related value from List TWO?”

  • “How do I avoid my lookup formula displaying an ugly error when it can’t find a match?”

  • “I’ve heard of VLOOKUP, but what’s HLOOKUP and XLOOKUP?”

This session will answer these questions and more, giving you a complete understanding of Excel’s lookup functions and how to use them efficiently.

Why You Should Attend

VLOOKUP, HLOOKUP, and XLOOKUP are some of Excel’s most powerful formulas. When used correctly, they help improve workbook accuracy, save time, and reduce data entry errors. This training will empower you to harness these functions to streamline your work.

Areas Covered in the Session

  • Differences between VLOOKUP, HLOOKUP, and XLOOKUP

  • How to construct and use lookup functions effectively

  • Understanding the TRUE and FALSE parameter in VLOOKUP

  • Using tables to future-proof your LOOKUP formulas

  • Avoiding #N/A errors

  • Comparing INDEX/MATCH with LOOKUP for advanced solutions

Who Will Benefit

  • Intermediate Excel users seeking to master lookup functions

  • Users working with large datasets who need to improve data accuracy and efficiency

  • While delivered using the latest version of Excel, this training is relevant for all Excel versions (note: XLOOKUP is only available in certain versions)


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.