Excel Lookup Functions Xlookup & Error Suppression
14-January-2025 :03:00 PM EST Duration : 90 Minutes
Ray Evans,
Performing key roles in a the private and public sectors and also as a Board Director, Ray's proven experience includes management, business analysis, audit, report writing, system documentation, website design and video production.
Ray has qualifications in Frontline Management, Accounting, Training and Assessment an Read more
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 policyGet In Touch
Similar Trainings
Leadership: Strategic Planning and Decision Making
LIVE : Scheduled on
09-January-2025 :02:00 PM EST
|
Microsoft Excel - A Beginner's Guide to Formulas
LIVE : Scheduled on
10-January-2025 :01:00 PM EST
|
3 Hour Microsoft Excel Automation Boot Camp
LIVE : Scheduled on
13-January-2025 :01:00 PM EST
|
Data-Driven Decision Making
LIVE : Scheduled on
15-January-2025 :01:00 PM EST
|
Automate Excel Spreadsheets with Basic Macros
LIVE : Scheduled on
17-January-2025 :01:00 PM EST
|
