BEGIN:VCALENDAR
VERSION:2.0
PRODID:
BEGIN:VEVENT
UID:168376imp
DTSTAMP:20260722T012357Z
DTSTART:20261202T140000Z
DTEND:20261202T160000Z
SUMMARY: Excel for Accounting Professionals Session 5: Error Trapping and Improving Lookups (2 hours)
DESCRIPTION: Practical hands-on Excel learning exercises taught by a highly engaging expert in the fieldYou'll develop your expertise with real-world Excel workbooks. Despite the popularity of VLOOKUP\, it has its drawbacks. This session will address these drawbacks while offering alternatives. You'll walk through the VLOOKUP and IFERROR functions\, and explore the following topics: \n\nImproving the use of VLOOKUP with VALUE/TEXT \nImproving the use of VLOOKUP with MATCH. \nMoving beyond VLOOKUP with INDEX \nTrapping errors with IFERROR\nMoving beyond basic Excel functions Grasping the limitations and possible enhancements for the VLOOKUP feature\, along with methods to handle errors can elevate your proficiency in Excel. You'll also partake in hands-on Excel activities that showcase the integration of functions and their use in crafting spreadsheets\, encompassing:\n  \n\nCombining functions to enhance flexibility \nUtilizing functions for atypical data categories \nPerfecting sophisticated lookup functions\n*Session 5 is one of eight sessions that is available as an individual session. Each session builds on the prior sessions\, so you'll want to consider watching [Session 6: List Comparisons and Indenting] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-6--list-comparisons-and-indenting) to further prepare to tackle real-world issues and build powerful workbooks.*\n  
CLASS:PUBLIC
END:VEVENT
END:VCALENDAR