Excel: Get and Transform (Power Query)
This course is designed for advanced Excel users who want to streamline their data preparation process. Are you spending too much time cleaning, organizing, and reformatting data before diving into analysis? With Excel’s Get and Transform tools (also known as Power Query), you can automate repetitive tasks such as removing unwanted rows or columns, combining data from multiple sources, and resolving layout inconsistencies—all without requiring macros or VBA.
Once configured, these transformations can be applied with a single click of the Refresh button, saving you hours of manual work.
The course uses practical examples with data sources like Excel workbooks, CSV files, and text files, but the principles taught are versatile and can be applied to a wide range of data sources.
Key Takeaways:
• Learn to create robust query connections to various data sources.
• Master techniques for cleaning and preparing data for analysis in tools like PivotTables.
• Combine and consolidate data from multiple datasets into a single, usable format.
• Understand how to automate data transformations for consistent and repeatable workflows.
By the end of this class, you’ll have fundamentals to prepare your data for analysis, letting you focus on insights rather than manual tasks.
Date & Time
03/24/2026
Start Time: 8:00 AM PT
End Time: 12:00 PM PT
Location
Webinar
Sponsor
NACM Commercial Services
Instructor:
Neal Otto
"People work too hard to get simple things done!” quotes Neal Otto, Jumpstart Computer Training. Neal and Jumpstart believe that technology should reduce waste and help us all get more of the right things done, faster. Since 1996, Neal and Jumpstart have helped tens of thousands of individuals improve their use of Microsoft technologies.
Neal, a former high school teacher, is known for his broad knowledge of an extensive array of Microsoft software and his ability to connect with students of all abilities and styles. Given his background, he can keep audiences engaged and entertained.
Neal lives in Corvallis Oregon with his sweetheart Shannon. Linus THE Wonder Dog and Cali THE Wonder Dog 2 keep Neal company in his office during webinars. Neal is a long-distance bicyclist and loves to spend any spare time in his shop making sawdust or in the kitchen making bread. Son Nathan is the CFO of Fluke Healthcare; daughter Brynne is self-employed and resides in Bellingham Washington.
Course Level
I - Intermediate
Credits
CEU:
0.400
CCE:
0.400
Audience
Admissions
Members:
$135.00
Non-Members:
$175.00
*Price is for admission only. Some events, especially college credit classes, have additional costs associated with materials, such as text books. See the event comments above for more details. Membership discount eligibility is at the discretion of the event sponsor.
Cancellations will be accepted for full refund no later than five working days prior to event — substitute attendees accepted up to day of event.
View Education List