COMMUNITY EVENT: 2016 Excel Training
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
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
St. Cloud State students: $75 by February 15