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

COMMUNITY EVENT: 2016 Excel Training

  • Share:
  •  
Name: COMMUNITY EVENT: 2016 Excel Training
Date: February 22, 2018
Time: 8:00 AM - 4:00 PM CST
Event Description:
Get and Transform; Power Query
8:00 a.m. - 11:30 a.m.  (3.5 hours)
 
Excel 2016 includes a powerful new set of features called 
Get & Transform, which provides fast, easy data gathering and shaping capabilities. These tools enable 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.  
  • 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
 
Getting Started with the Data Model & Power Pivot
12:30 - 4:00 p.m. (3.5 hours)  
 
Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, 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 Pivot Tables from the Data Model
Location:
St. Cloud State University Welcome Center
355 5th Ave South
St. Cloud, MN
56301
Date/Time Information:
Get and Transform; Power Query
8:00 a.m. - 11:30 a.m.  (3.5 hours)
 
Getting Started with the Data Model & Power Pivot
12:30 - 4:00 p.m. (3.5 hours)  
Contact Information:
Fees/Admission:
$99 per class by February 15
$165 both classes on February 22
Early bird registration: $89 per class by February 8
St. Cloud State students: $75 by February 15
Set a Reminder:
Enter your email address below to receive a reminder message.