MenuClose
 Log Out
Cart 0 items
Site Search
Course Search

Surgent's Excel for Accountants: Using Excel to Cleanse and Prepare Data

 Various
 
2.0
Registration is Open
Member Price
$99.00 Regular Registration
Your Price
$104.00 Regular Registration
This course is being offered on multiple dates, listed below. Click the Register button next to your preferred date to register.
 Fri, 02/27/2026 from 1:00 pm to 3:00 pm
 Fri, 03/27/2026 from 10:00 am to 12:00 pm
 Mon, 04/27/2026 from 10:00 am to 12:00 pm
Designed For:

Accounting professionals using Excel for Windows

Prerequisite:

Experience working with Excel

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 webcast
CPE Credit: Computer software & applications
Program Level: Intermediate

This course is being offered by a 3rd party vendor and will not be accessible on your My CPE page. Webinar access information will be emailed directly to you by Surgent McCoy.

Objectives

  • Recall the steps to create a new query
  • Identify commands that transform data
  • State the process to return the transformed data to Excel

Speakers

Advanced Preparation

None

Vendor

The Virginia Society of CPAs (VSCPA) is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: NASBARegistry.org.

For more information regarding refund, complaint, program cancellation or other policies, visit our Registration Policies page or call (800) 733-8272.