Events Search
  Summary & Check Out (0)
Wednesday, May 27, 2026 Live Webcast

Excel for Accountants: Using Excel to Cleanse and Prepare Data (X1-EXPD-2026-01-WEBNR-147-01)

1:00 PM - 3:00 PM EDT
webcast

Vendor Platform

2 CPE Credits in SK

OVERVIEW

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.

DESIGNED FOR

Accounting professionals using Excel for Windows

BENEFITS

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

HIGHLIGHTS

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

COURSE LEVEL

Intermediate

PREREQUISITES

Experience working with Excel.

ADVANCE PREPARATION

None

INSTRUCTOR

Jeff Lenning

Jeff Lenning

Read bio

PRICING

$89.00 - Member

$289.00 - Nonmember

Register Today


Note: Online pre-registration will close on May 27 at 12:30 PM.

ADDITIONAL OPTIONS

Remind me to register

Print a registration form

COURSE DEVELOPER

Surgent