Instant Access

Excel Lookup Functions Xlookup & Error Suppression

5826
Duration90 Minutes
Ray Evans
Instructor

Ray Evans

View profile

VLOOKUP, HLOOKUP, and XLOOKUP are some of the most well-known (and most useful) formulas in Excel. Used properly, they will help you to improve the accuracy and integrity of your Excel workbooks save time, work smarter, and boost your efficiency and productivity.

Course Objectives:

To gain a practical “hands-on” understanding of key Lookup functions in MS Excel.

Areas Covered:

• Vlookup - Range Lookup Table with Absolute References

• True and False - The 4th Parameter Demystified

• Vlookup Function - Exact Match Lookup Table with Named Range

• Tables - The Key to Future-Proofing Vlookup

• Using the Insert Function Wizard with Vlookup

• Vlookup Link to External Data using Insert Function

• Vlookup – Incorporating other Excel Functions

• Hlookup - Range Lookup Table with Absolute References

• Hlookup Function - Exact Match Lookup Table with Named Range

• Formula Auditing

• How to suppress #NA error messages

• NEW: The XLOOKUP Function

Why Should You Attend

• Understand the latest powerful and most relevant MS Office functions available

• Work smarter, faster, and more effectively

• Boost profit, efficiency, and productivity

• Improve job satisfaction, team performance, and professionalism

• Gain a strong competitive advantage at the peer and business level

• Achieve more in less time with higher quality results.

• Strengthen your resume and justification for increased salary

Course Outline:

• How to look up a value in list one and pick up a related value from list two

• How to avoid lookup formulas displaying an error when it can't find a match

• What's HLOOKUP and what’s XLOOKUP?

• These are just a few questions asked on a regular basis

• You can get the answers to these questions, and more by attending this training session dedicated to mastering the various key lookup functions that are built into Excel

What You Get:

• Training Materials

• Live Q&A Session with our Expert

• Participation Certificate

• Access to Signup Community (Optional)

• Reward Points

Who Will Benefit:

Anyone seeking to significantly boost profits, competitive advantage, productivity, job satisfaction, and effective use of their technology.

Please reach us at 1-888-844-8963 for any further assistance or if you wish to register

100% MONEY BACK GUARANTEED

Refund / Cancellation policy

Get In Touch

Subject : Excel Lookup Functions Xlookup & Error Suppression


Similar Trainings

Excel Lookup Functions: VLOOKUP, HLOOKUP, and XLOOKUP Made Easy
Cross Industry | Skill Enhancement
Get Instant Access 60 Minutes
View Program
Advanced Excel Functions: Lookups, Logic, and More
Cross Industry | Skill Enhancement
Get Instant Access 90 Minutes
View Program
INTERMEDIATE FUNCTIONS, LOOKUPS & LINKING IN MS EXCEL
Cross Industry | Skill Enhancement
Get Instant Access 90 Minutes
View Program
Microsoft Excel®: Lookup Functions and 3-D Excel file
Cross Industry | Skill Enhancement
Get Instant Access 90 Minutes
View Program
Lookup Functions, Formula Tracing & Named Ranges in Excel
Cross Industry | Skill Enhancement
Get Instant Access 90 Minutes
View Program