BEGIN:VCALENDAR
VERSION:2.0
CALSCALE:GREGORIAN
METHOD:PUBLISH
PRODID://NDCP//517675
BEGIN:VEVENT
DTSTAMP:20260429T131613
VTIMEZONE:America/Chicago
DTSTART:20270426T140000Z
DTEND:20270426T160000Z
UID:517675
SUMMARY:Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data (EXPD)
LOCATION:Webinar
DESCRIPTION:Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data (EXPD)\n\n04/26/27 09:00 AM CST\n - 04/26/27 11:00 AM CST\Description:\nDo you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel!
 The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we’ll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports.
 If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.
 Objectives:
 Recall the steps to create a new query
 Identify commands that transform data
 State the process to return the transformed data to Excel
 Presenters:Jeff LenningField of Study:Computer Software & Applications (2)Major Topics:
 Automation capabilities of Excel
 The “Get & Transform” Tool
 Using “Get & Transform” for flattening, splitting and combining data, unpivoting summarized data, and combining CSV exports
 \Location:\nWebinar\n\n,
X-ALT-DESC;FMTTYPE=text/html:Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data (EXPD)<br /><br />04/26/27 09:00 AM CST - 04/26/27 11:00 AM CST<br />Description:<br />Do you ever import data into Excel, and then spend a bunch of time manually preparing it for use? Perhaps you delete extra columns or rows. Maybe you need to split a single column into multiple columns, or, combine multiple columns into a single column. The good news is that many of these transformations can be fully automated with Excel!<br />
<br />
The Get & Transform tools built-in to Excel 2016 for Windows, formerly available as the Power Query add-in, are incredibly powerful. At a high level, they enable us to retrieve data from a variety of sources and prepare it for use as needed. In this session, we’ll use Get & Transform queries to help with several common tasks, including flattening data, splitting and combining columns, formatting data, unpivoting summarized data, and combining several csv exports.<br />
<br />
If you frequently export/import data from one system to another, you will want to understand how to use a Get & Transform query to streamline your work.<br />
<br><br><b>Objectives:</b><br><ul>
    <li>Recall the steps to create a new query</li>
    <li>Identify commands that transform data</li>
    <li>State the process to return the transformed data to Excel</li>
</ul><br><b>Presenters:</b><br>Jeff Lenning<br><br><b>Field of Study:</b><br>Computer Software & Applications (2)<br><br><b>Major Topics:</b><br><ul style="list-style-type: disc;">
    <li>Automation capabilities of Excel</li>
    <li>The &ldquo;Get &amp; Transform&rdquo; Tool</li>
    <li>Using &ldquo;Get &amp; Transform&rdquo; for flattening, splitting and combining data, unpivoting summarized data, and combining CSV exports</li>
</ul><br />Location:<br />Webinar<br /><br />,  
PRIORITY:3
TRANSP:TRANSPARENT
BEGIN:VALARM
TRIGGER:-PT5M
ACTION:DISPLAY
DESCRIPTION:Reminder
END:VALARM
END:VEVENT
END:VCALENDAR