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