Events Calendar Courses

Home / Professional Development / Courses

Surgent’s Excel for Accountants: Using Excel to Cleanse and Prepare Data (SU0712/24)

Loading Events

« All Events

Surgent’s Excel for Accountants: Using Excel to Cleanse and Prepare Data (SU0712/24)

Member Price $99
Non-Member Price $129
If you are a member, please login to activate member pricing.

May 29 @ 1:00 pm - 3:00 pm

Event 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.

Designed For

Accounting professionals using Excel for Windows

Objectives

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

Major Subjects

Automation capabilities of Excel The “Get & Transform” Tool Using “Get & Transform” for flattening, splitting and combining data, unpivoting summarized data, and combining CSV exports

Prerequisites

Experience working with Excel

Instructions

None

Details

Date:
May 29
Time:
1:00 pm - 3:00 pm
Cost:
$02 – $2024

Other

Credit Hours
2
Max Registrations
0
Course Level
I
Course Type
Webinar