• Coming Up:
  • Coming Up:
  • Coming Up:
  • Coming Up:

February: Excel - Get & Transform and Data Model & Power Pivot

  • Share:
  •  
Name: February: Excel - Get & Transform and Data Model & Power Pivot
Date: February 21, 2019
Time: 8:00 AM - 4:00 PM CST
Event Description:

Excel

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.

 

Session 1: 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
Session 2: 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. 
Location:
St. Cloud State University Welcome Center
355 5th Ave S, St Cloud, MN 56301
Date/Time Information:
Date:
February 21, 2019

Times:
?Session 1: Get & Transform aka Power Query
8:00 a.m. - 11:30 a.m. 
 
Session 2: Data Model & Power Pivot
12:30 p.m. - 4 p.m. 

Both sessions
8 a.m. - 4 p.m.
 
Contact Information:
Roxann Neu (registrar): 320-308-4962 or Tammy Anhalt-Warner: 320-308-4252
Fees/Admission:

Cost: Early-bird registration fee applies 2 weeks prior. Registration closes 1 week prior.

  • $99, early bird; $109, regular cost for one session
  • $75, St. Cloud State students for one session
  • $180, both sessions
Set a Reminder:
Enter your email address below to receive a reminder message.