“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