Tools like Power Query (now known as "Get & Transform") can make transforming data from those sources quick and easy. Whether you are importing data or cleaning it, learn how to make it happen! 

Learning Objectives 

By the end of this course, participants should be able to: 

Differentiate between proper and improper data structure. 

Select the best way to import data into Excel. 

Identify ways to use Get & Transform/Power Query to clean your data. 

 
Content 

The topics in this seminar include: 

Various forms of data sources 

Accessing data sources 

Working with multiple tables/sources 

Importing data for analysis 

Introduction to Get & Transform (formerly Power Query) 

 
Applicable for 

Anyone interested in the topic.  

 
Presented by PD Partner: AICPA 

 
What to Expect 

An email will be sent from AICPA to the participant within two business days of registration to set up an account to access the course.  

This self-study course allows the user to save their progress and return to continue later.