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
COMMUNITY EVENT: 2016 Excel Training
Date and Time
Thursday Feb 22, 2018 8:00 AM - 4:00 PM CST
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)
Location
St. Cloud State University Welcome Center
355 5th Ave South
St. Cloud, MN
56301
Fees/Admission
$99 per class by February 15
$165 both classes on February 22
Early bird registration: $89 per class by February 8