Change the way you use Microsoft Excel by learning the Get & Transform feature to eliminate a lot of unnecessary steps and reduce 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.
Don’t miss out on the opportunity to revolutionize your workflow and supercharge your efficiency with Microsoft Excel’s Get & Transform feature! By mastering these advanced capabilities, you’ll not only streamline your data processes but also reclaim hours of valuable time, allowing you to focus on strategic insights and decision-making rather than tedious manual tasks.
Whether you're looking to enhance your current Excel skills or integrate these tools into Power BI for even greater data analysis, this training will empower you to work smarter, not harder. Invest in your productivity today and unlock a new level of precision and speed in your data management practices—your future self will thank you.
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
Prerequisite:
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.
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.
