This live online training course is offered by a collaboration of Minnesota State colleges.
Get & Transform will 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.
- Power Query Basics
- Column-Level Actions
- Table Actions
- Importing Data from Files, Databases
- Common Transformations
- Custom Columns
- Grouping and Aggregating
- Managing Queries
- Reusing Query Steps
- Merge & Append Queries
- Practical applications
- Replace VLOOKUP
Familiarity with VLOOKUP feature. Some knowledge of Pivot Tables is helpful but not required. Those who have completed our Excel Level 1 & 2 courses are well prepared for this course.
Aout 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.