Description
It is a free Excel 2010 add-in, a built-in feature of Excel 2013, and free in Office Professional Plus and Office 365 Professional versions of Office 2016.
Extending the functionality of pivot tables and pivot charts using concepts and features you may or may not already be familiar with, PowerPivot provides additional functionality and formulas.
PowerPivot can manage the relationships between tables of source data and replace VLOOKUPs with simplified solutions. Data from multiple sources can be sourced creating Data Mashups. By incorporating intelligent calculated columns, PowerPivot dashboards can efficiently present Business Intelligence.
Highlights
- Manage Fields in a Power Pivot Data Model
- Build a PivotTable from a Data Model in Power Pivot
- Create and Use Calculated Columns in Power Pivot
- Concatenate Data in Power Pivot
- Format a Data Model and PivotTable in Power Pivot
- Slicers in Power Pivot
- Timelines in Power Pivot
Prerequisites
- Complete the course: Mastering Power Pivot Essentials in Excel L1