Mastering Power Pivot Essentials in Excel L1

No reviews yet.

Power Pivot is a data modelling technology that allows you to manage large data sets, build extensive relationships, and create simple or complex calculations within the Excel application environment.

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.