Excel Pivot Tables & PowerPivot Tools

The Excel 2016 version has enhanced the traditional Pivot Tables reporting tool by more deeply integrating the PowerPivot tools add-in. Students will learn how to construct and edit Pivot Table reports, as well as use PowerPivot tools to create Pivot Tables from Data Models, build relationships between Data Models to create relational Pivot Tables, use the new PowerPivot DAX language to integrate Calculated Fields in Pivot Tables, and much more!