\n
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. \;
\n\n
Each course takes 3.5 hours. \;St. Cloud State \;provides a laptop and mouse to use for this hands on training.
\n\n
For human resource professionals\, each course provides 3.5 professional development credits for SHRM-CP or SHRM-SCP.
\n_______________________\n\n
Excel 2016: Get \;&\; Transform aka Power Query
\n\n
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. \; \; \; \; \; \;
\n\n
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!
\n\n
\n - Power Query Basics
\n - Column-Level Actions
\n - Table Actions
\n - Importing Data from Files\, Databases
\n - Unpivoting
\n - Common Transformations
\n - Custom Columns
\n - Grouping and Aggregating
\n - Managing Queries
\n - Reusing Query Steps
\n - Merge &\; Append Queries
\n - Practical applications
\n - Replace VLOOKUP
\n
\n\n
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.
\n\n
_________________________________________________________
\n\n
Excel 2016: Introduction to the Data Model &\; PowerPivot
\n\n
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.
\n\n
\n - Working with the Data Model
\n - Replace VLOOKUP
\n - Database Terms &\; Concepts
\n - Linking Excel Tables to Power Pivot
\n - Loading Data from Relational Databases &\; files
\n - Building table relationships
\n - Calculated columns
\n - Measures
\n - Basic DAX functions
\n - Understanding Evaluation Contexts
\n - Creating PivotTables from the Data Model
\n
\n\n
Prerequisite: \;Frequent use or several months of solving business problems with PivotTables. \;
\n\n
__________________________________________________________
\n