Excel Get and Transform (PowerQuery)

This course is for experienced Excel users who spend too much time manipulating data into the right format before they even begin to analyze it month after month or week after week or day after day. Get and Transform (AKA, Power Query) can perform repetitive data cleansing such as deleting row and columns, merging data from various data sources and fixing layout issues without macros or VBA.

Once Get and Transform is set up, simply click the Refresh button. You’ll save hours.

Data source examples used in this class include Excel, CSV and text but the concepts taught can be applied to many different sources.

Upon successful completion of this course, students will be able to:
• Create query connections to a variety of data sources
• Cleanse data for use in an Excel PivotTable
• Consolidate data from multiple datasets

Use the word CREDIT in the checkout field to receive NACM Member price

Register Here

Event Properties

Event Date 08-11-2020 8:00 am
Event End Date 08-11-2020 11:30 am
Individual Price $135.00 with NACM member discount