BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//South Carolina Association of CPAs - ECPv6.18.2//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:South Carolina Association of CPAs
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:20270108T130000
DTEND;TZID=America/Detroit:20270108T135000
DTSTAMP:20261017T041313Z
CREATED:20261016T191210Z
LAST-MODIFIED:20261017T041313Z
UID:10007430-1799413200-1799416200@sc.cpa
SUMMARY:(LITE26/27) Power Query
DESCRIPTION:Event Description\nPreparing monthly reports often means repeating the same cleanup steps across worksheets\, text files\, and other data sources. This session introduces Power Query as a way to capture those steps and refresh the results when source data changes. \nThis presentation answers the question:How can Power Query turn recurring data preparation into a repeatable process? \nTopics typically covered• Manual versus automated preparation: Recurring cleanup tasks\, repeatable transformations.• Power Query workflow: Sources\, queries\, transformations\, loading results.• Combining worksheets: Consolidating similarly structured data.• External connections: Text-file imports\, source paths\, connection trust.• Maintaining queries: Applied Steps\, Queries & Connections\, refresh behavior. \nObjectives\nLearning objectives• Recognize recurring data preparation tasks suited to Power Query.• Identify the stages involved in consolidating worksheets with Power Query.• Describe how connections\, applied steps\, and refresh settings support repeatable reporting.
URL:https://sc.cpa/event/lite26-27-power-query/
CATEGORIES:Livestream
ORGANIZER;CN="David Ringstrom":MAILTO:ask@davidringstrom.com
END:VEVENT
END:VCALENDAR