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

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. 

February: Excel - Get & Transform and...

Enter your email address below to receive a reminder message.

Please complete the Captcha

Date and Time

Thursday Feb 21, 2019
8:00 AM - 4:00 PM CST

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.
 

Location

St. Cloud State University Welcome Center
355 5th Ave S, St Cloud, MN 56301

355 5th Ave S St Cloud MN 56301

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

Contact Information

Roxann Neu (registrar): 320-308-4962 or Tammy Anhalt-Warner: 320-308-4252

Enter your email address below to receive a reminder message.

Please complete the Captcha

Business Directory Events Calendar Hot Deals Job Postings Contact Us
GrowthZone - Membership Management Software
Share
Print Email Add to Calendar Facebook Twitter LinkedIn
Tell a Friend
Select Calendar Type
Google Yahoo iCal (Outlook, Apple, or other)