Loading Events
This event has passed.
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

 

Regular Member Rate

Member Rate $135

*Members will be invoiced for their registration*

 

Non-Member Registration

Non-Member Rate $175

*Non-Members will be contacted in advance for payment*

 

(Please note: All registration charges will be incurred without a 24-hour cancellation notice.)

 

[button link=”https://nacmbcs.org/08-11-2020-microsoft-365-excel-get-and-transform-powerquery-online-training/”]Register Now[/button]

Share This Page on Social Media!