Discover how to change the way you use Excel by eliminating a lot of unnecessary steps and reducing your project time by hours or even days!

Excel includes a powerful set of features called Get & Transform, which provides fast, easy data gathering and shaping capabilities. Get & Transform enables you to connect, combine, and refine data sources to meet your analysis needs. These features are also used in Power BI, and in the Power Query Add-In available for previous versions of Excel.     

Power Query is a business intelligence tool available in Excel that allows you to import data from many different sources and then clean, transform and reshape your data as needed.

Enhance your productivity and analysis skills by mastering these features in Excel. After completing this course, you'll be able to streamline processes, make better decisions, and work smarter! 

Course Topics:

• Power Query Basics
• Column-Level Actions
• Table Actions
• Importing Data from Files, Databases
• Unpivoting
• Common Transformations
• Custom Columns
• Grouping and Aggregating
• Managing Queries
• Reusing Query Steps
• Merge & Append Queries
• Practical applications
• Replace VLOOKUP

Prerequisites:
If you've completed our Excel Level 1 & 2 courses, you'll be well prepared for this course. Familiarity with VLOOKUP feature is recommended. Some knowledge of Pivot Tables is helpful but not required.

About The Instructor:
Bob Bruce is a Twin Cities-based Information Architect who has expert level skills in the Microsoft Office suite of products. He’s an Excel 2013 Microsoft Certified Expert. Bob has logged thousands of hours as a software trainer, and is energized by the prospect of improving student skills and knowledge.

This live online training course is offered by a collaboration of Minnesota State colleges.

• Computer with Microsoft Excel 2016 or newer, webcam, microphone, and high-speed internet.
• 2 monitors (or 1 large high-resolution screen capable of having multiple windows open at a time).
• Plan to have your video camera on during the training, so the instructor can monitor your experience.
• Zoom links and Excel working files will be emailed several days prior to the class date. Download the Excel files to your computer before the class

Cancellation Policy:

• A full refund (minus a $25 processing fee) or a transfer to a new class date will be issued if the request is made at least 5 business days prior to the class. Requests must be made by calling 507-389-7203 or emailing cwe@southcentral.edu.
• No refunds or transfers will be provided if the request is made less than 5 business days before the class date.