Loading Events

« All Events

“Excel Get and Transform (PowerQuery)” Webinar

August 11 @ 9:00 am - 12:30 pm

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

Details

Date:
August 11
Time:
9:00 am - 12:30 pm
Event Category:

Venue

Your Phone Line & Internet Connection