Excel PowerPivot , PowerQuery, Measures, DAX Functions, and KPI - Data Analysis - Excel 2013 & 2016 | Tom Fragale | Skillshare

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

Tom Fragale, Microsoft Certified Trainer

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

      74:38

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

48

Students

--

Projects

  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Tom Fragale

Microsoft Certified Trainer

Report class