This live online training course is offered by a collaboration of Minnesota State colleges.
Take your Excel skills to the next level with our Special Features workshop discount bundle!
First, learn how to use Power Pivot to mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily. Then learn how to use Power Query to import data from many different sources and then clean, transform and reshape your data as needed.
Intro to the Data Model & Power Pivot 8am-12pm
- Working with the Data Model
- Replace VLOOKUP
- Database Terms & Concepts
- Linking Excel Tables to Power Pivot
- Loading Data from Relational Databases & files
- Building table relationships
- Calculated columns
- Basic DAX functions
- Understanding Evaluation Contexts
- Creating Pivot Tables from the Data Model
Get & Transform aka Power Query 1-5pm
- 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
Frequent use with Pivot Tables and 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 these courses.
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.
A full refund minus a $25 processing fee will be issued if request is by June 3, 2021.