BEGIN:VCALENDAR
VERSION:2.0
PRODID:
BEGIN:VEVENT
UID:358061imp
DTSTAMP:20260424T094212Z
DTSTART:20270426T140000Z
DTEND:20270426T160000Z
SUMMARY: Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data
DESCRIPTION: 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!

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.
Delivery Method: Individual webcastCPE Credit: 2Program Level: IntermediateThis course is being offered by a learning partner. You may access the Surgent platform through the My CPE page on vscpa.com after purchase\n 
CLASS:PUBLIC
END:VEVENT
END:VCALENDAR