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