BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//South Carolina Association of CPAs - ECPv6.17.3//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:20250309T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20251102T060000
END:STANDARD
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
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Detroit:20260911T130000
DTEND;TZID=America/Detroit:20260911T135000
DTSTAMP:20260807T051433Z
CREATED:20260807T051432Z
LAST-MODIFIED:20260807T051433Z
UID:10007355-1789131600-1789134600@sc.cpa
SUMMARY:(LITE22/27) 5 Productive Excel Features for Accountants
DESCRIPTION:Event Description\nMicrosoft Excel contains hundreds of commands\, but only a handful can dramatically improve the way accountants organize\, summarize\, and analyze data. In this fast-paced session\, CPA and author of Microsoft 365 Excel for Dummies David Ringstrom demonstrates five of his favorite Excel productivity features that can help you work more efficiently and avoid common spreadsheet frustrations. \nYou’ll learn how to filter data more quickly\, transform ordinary lists into dynamic Excel Tables\, summarize thousands of rows with PivotTables\, retrieve information with XLOOKUP\, and create interactive reports with slicers. Rather than simply demonstrating commands\, David explains when each feature is most valuable so you can confidently apply these techniques to your own spreadsheets. \nTopics covered:• Filtering data quickly with keyboard shortcuts and custom Quick Access Toolbar buttons. • Converting lists into Excel Tables for dynamic filtering\, totals\, and automatic expansion. • Creating and customizing PivotTables to summarize large datasets. • Filtering Excel Tables visually with slicers. • Replacing older lookup functions with XLOOKUP\, including returning multiple columns with a single formula.  \nObjectives\n• Identify techniques for filtering and restoring filtered data more efficiently. • Recognize the advantages of converting data ranges into Excel Tables. • Create PivotTables to summarize and analyze data. • Apply XLOOKUP to retrieve one or more related values from a list.
URL:https://sc.cpa/event/lite22-27-5-productive-excel-features-for-accountants/
CATEGORIES:Livestream
ORGANIZER;CN="David Ringstrom":MAILTO:ask@davidringstrom.com
END:VEVENT
END:VCALENDAR