Excel Lookup Functions Xlookup & Error Suppression
Speaker: Ray Evans
Speaker Designation: Microsoft Trainer
Speaker: Ray Evans
Speaker Designation: Microsoft Trainer
Going “beyond the basics” Ray Evans clearly demonstrates, features and functionality that enhance the power and flexibility of lookup functions at an intermediate level.
In this easy-to-follow webinar, you'll deepen your understanding of lookup functionalities and discover new ways to boost productivity and improve data presentation. Ray will guide you through how lookup functions can match, retrieve, and merge data between tables using both exact and range matches, leveraging absolutes and named ranges.
Key topics include:
• VLOOKUP: Retrieving data from vertical tables organized in rows.
• HLOOKUP: Retrieving data from horizontal tables organized in columns.
• XLOOKUP: An enhanced function that combines and improves upon both VLOOKUP and HLOOKUP.
In addition, the session will cover advanced techniques such as using named ranges and error suppression to refine your lookup skills, enabling you to handle complex data with greater accuracy and efficiency.
By mastering these lookup functions, you’ll significantly increase your Excel capabilities, save time, and improve your data management in various professional fields like public service, banking, accounting, and business administration.
This webinar replicates the in-person classroom experience through step-by-step guides, student files, and data samples, ensuring clear understanding and maximum knowledge retention. Don’t miss this opportunity to elevate your Excel expertise and stay ahead in a competitive environment.
Excel’s lookup functions are essential tools for efficiently retrieving and managing data. Among these, XLOOKUP represents a significant advancement in flexibility and usability compared to its predecessors, VLOOKUP and HLOOKUP. It is a powerful function designed to search for data within a range or array and return corresponding results. Alongside XLOOKUP, implementing error suppression techniques allows users to create more robust and user-friendly formulas, avoiding common lookup errors that can disrupt workflows.
This webinar will be available soon. Please contact customer care for new schedule date.
Ray’s professional and relaxed style reflects his thorough understanding of advanced learning principles and is demonstrated through his diverse range of classroom, seminar, workshop and online delivery services and instructional materials.
With Microsoft Certifications in Excel and Word, he has mastered over 2500 topics to advanced level in Microsoft Excel, Access, Outlook, Project, PowerPoint, Word, Visio, and Publisher.
Ray has qualifications in Frontline Management, Accounting, Training, and Assessment and is certified in Six Sigma business improvement methodology.
Having trained over 120,000 students and authored a wide range of complex reports, training, and procedural documentation, Ray has demonstrated strong ability in written communication, change management, and knowledge transfer.
