Essential Tools to Prepare for the Modern Workplace

Power Query & Power Pivot

Preparatory Materials for the Microsoft University Workshop Series, Workshop #1 - Power Query & Power Pivot

Repository Materials

Resource	Purpose
Presentation Deck	Presentation material presented during the Microsoft University Workshop Series Live Session
Power Query - Step by Step Tutorial	Step-by-step guided tutorial on completing the hands-on workshop
Financial Sample Dataset	Excel file used to demo the different Power Query transformations available
Folder Import	Folder of Excel files to demo Power Query > Import from Folder

Presenter

• Lim Le Shin, Microsoft
• Lester Sim, Microsoft