Events

Loading Events

« All Events

  • This event has passed.

08-11-2020 Microsoft 365: Excel Get and Transform (PowerQuery) (online training)

August 11 @ 7:00 AM - 10:30 AM

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

 

Register Now

Details

Date:
August 11
Time:
7:00 AM - 10:30 AM