BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//South Carolina Association of CPAs - ECPv6.18.4.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://sc.cpa
X-WR-CALDESC:Events for South Carolina Association of CPAs
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/Detroit
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20260308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20261101T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20270314T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20271107T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20280312T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20281105T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20270611T130000
DTEND;TZID=America/Detroit:20270611T135000
DTSTAMP:20261110T142416Z
CREATED:20261019T134311Z
LAST-MODIFIED:20261110T142416Z
UID:10007434-1812718800-1812721800@sc.cpa
SUMMARY:(LITE31/27) Advanced Excel Skills for Accountants
DESCRIPTION:Event Description\nAccounting spreadsheets frequently require more than a straightforward lookup or SUM formula. This session explores several approaches to complex problems\, from retrieving the last matching record to target-matching with Solver and protecting important workbook work. \nThis presentation answers the question: \nHow can I choose Excel techniques for accounting problems that go beyond routine formulas? \nTopics typically covered: \n· Advanced lookups: XLOOKUP versus older lookup tools\, finding the last match. \n· Conditional aggregation: SUMIF for matching criteria. \n· Target matching: Solver add-in\, matching a target sum. \n· Workbook resilience: AutoRecover\, cloud-based version recovery. \nObjectives\nLearning objectives \n· Recognize when XLOOKUP can retrieve a last matching record. \n· Identify a target-matching problem suited to Solver. \n· Describe workbook recovery options for local and cloud-based files.
URL:https://sc.cpa/event/lite31-27-advanced-excel-skills-for-accountants/
CATEGORIES:Livestream
ORGANIZER;CN="David Ringstrom":MAILTO:ask@davidringstrom.com
END:VEVENT
END:VCALENDAR