BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//South Carolina Association of CPAs - ECPv6.18.2//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:20270514T130000
DTEND;TZID=America/Detroit:20270514T135000
DTSTAMP:20261020T041218Z
CREATED:20261019T132817Z
LAST-MODIFIED:20261020T041218Z
UID:10007433-1810299600-1810302600@sc.cpa
SUMMARY:(LITE30/27) Dynamic Array-Based Financial Statements
DESCRIPTION:Event Description\nFinancial reports often require repeated copying\, filtering\, and restructuring whenever new data arrives. Modern dynamic array formulas offer ways to create financial statement views that adapt as source data and reporting requirements change. \nThis presentation answers the question: \nHow can dynamic array formulas make financial reporting more responsive to changing data? \nTopics typically covered: \n· Unique report categories: UNIQUE with Excel Tables. \n· Filtered report views: FILTER and multiple conditions. \n· Reshaping financial data: CHOOSEROWS and CHOOSECOLS. \n· Dynamic calculations: Summing spilled arrays. \n· Combining report ranges: VSTACK to assemble related results. \nObjectives\nLearning objectives \n· Identify dynamic array functions that support adaptable financial report layouts. \n· Recognize how FILTER and multiple conditions can create focused reporting views. \n· Describe how CHOOSEROWS\, CHOOSECOLS\, VSTACK\, and dynamic sums reshape and aggregate results.
URL:https://sc.cpa/event/lite30-27-dynamic-array-based-financial-statements/
CATEGORIES:Livestream
ORGANIZER;CN="David Ringstrom":MAILTO:ask@davidringstrom.com
END:VEVENT
END:VCALENDAR