April Excel Level 3 & 4

We offer five different courses of Microsoft Excel courses through Bob Bruce, an instructor who has trained people on Microsoft products for more than 20 years. 

Each course takes 3.5 hours. St. Cloud State provides a laptop and mouse to use for this hands on training.

For human resource professionals, each course provides 3.5 professional development credits for SHRM-CP or SHRM-SCP.

Excel 2016: Get & Transform aka Power Query

Excel 2016 includes a powerful new 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.      

You don't know this Excel!  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!

• 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 Level 1 & 2 courses are well prepared for this course.

_________________________________________________________

Excel 2016: Introduction to the Data Model & PowerPivot

PowerPivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With PowerPivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.

• 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
• Measures
• Basic DAX functions
• Understanding Evaluation Contexts
• Creating PivotTables from the Data Model

Prerequisite: Frequent use or several months of solving business problems with PivotTables. 

__________________________________________________________