BEGIN:VCALENDAR
VERSION:2.0
PRODID:
BEGIN:VEVENT
UID:168412imp
DTSTAMP:20260722T090938Z
DTSTART:20270226T170000Z
DTEND:20270226T190000Z
SUMMARY: Excel for Accounting Professionals Session 4: Conditional Summing and Lookups (2 hours)
DESCRIPTION: Boosting productivity with Excel For those unfamiliar with conditional summing\, you're in for a revelation —it's an impactful technique that improves productivity in creating reports. You'll learn how to optimize Excel efficiency by\n\nmanaging duplicates\, \nselecting appropriate shortcuts\, and \nperforming lookups.\nPractical hands-on Excel learning exercises taught by highly engaging expert in the fieldYou'll also deepen your skills and tackle real-world Excel workbooks that address the following: \n  \n\nBenefits of using lookup functions over direct cell referencing \nA comprehensive exploration of the popular VLOOKUP function \nTechniques for removing duplicates to create a distinct set of report labels\n*Session 4 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 5: Error Trapping and Improving Lookups] (https://www.aicpa-cima.com/cpe-learning/webcast/excel-for-accounting-professionals-session-5--error-trapping-and-improving-lookups) to further prepare to tackle real-world issues and build powerful workbooks.* \n  
CLASS:PUBLIC
END:VEVENT
END:VCALENDAR