Powerpivot & Powerquery In Excel

Learning Outcomes Include:

Upon completion of this course, participants shall be able to:

Introduction
Installing Power Pivot
Importing Data
Understand Window
Calculated Columns
Relationships
Pivot Tables
Calculated Fields
DAX; Tools
Named Sets
Cheat Sheet
Cleaning Data
Transform Data
Queries
Combining multiple sources
Tips & Tricks

PROGRAM LENGTH

Half Day or One Day

FORMAT

Classroom Training