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

April Excel Level 3 & 4

  • Share:
  •  
Name: April Excel Level 3 & 4
Date: April 18, 2019
Time: 8:00 AM - 4:00 PM CDT
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.

_______________________

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. 
__________________________________________________________
Location:
St. Cloud State University Welcome Center
355 5th Ave S  St Cloud 56301
Date/Time Information:
Get & Transform and Data Model & Power Pivot

April 18, 2019

  • Get & Transform aka Power Query: 8-11:30 a.m. 
  • Data Model & Power Pivot 12:30-4 p.m. 
  • Both sessions: 8 a.m.-4 p.m.
Contact Information:
Tammy Anhalt-Warner 320-208-6100
Set a Reminder:
Enter your email address below to receive a reminder message.