Excel PowerPivot , PowerQuery, Measures, DAX Functions, and KPI - Data Analysis - Excel 2013 & 2016

Thomas Fragale, Microsoft Certified Trainer

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
1 Lessons (1h 15m)
    • 1. Powerpivot and power query


About This Class

Learn how to use the powerful new PowerPivot and PowerQuery features of Microsoft. The PowerPivot allows you to make pivot tables from more than 1 sheet, and there's some new functions available with the PowerPivot that are not available anywhere else. This video includes the new functions and KPI functions as well. The PowerQuery allows you to take data from many sources and join them together into powerful reports. These new features really allow you to make Excel into a relational database.

Data Analysis - Excel 2013 & 2016