exceltoxl.com

Hi there,

Today, we will discuss about PowerPivot add-in in Excel 2010 and above versions. Firstly, let's see where is this powerpivot? 

By default PowerPivot is enabled in Excel. To enable powerpivot, needs to go to Office Ribbon -->Excel Options -->Add-ins -->Under "Manage"-->Select "COM Add-ins" -->Click on Go

Here is where you get PowerPivot add-in for Microsoft Excel (just check mark it) and click ok.

Now, you will find it next to DEVELOPER tab (if at all it is enabled).

If you still don't find "PowerPivot" here, then you might have not installed this add-in. Please check this link to install PowerPivot Add-in to your excel.

Please make sure before you download this add-in, you need to know your system configuration. You have this information in the link itself. Follow the link to get complete details on Installing PowerPivot without errors.

...

Install PowerPivot Add-In Here

This add-in is inbuilt in Office Professional Plus 2013 and Office 365 editions.

ABOUT POWERPIVOT:

PowerPivot is able to import and relate large amounts of data from multiple sources. This doesn't have an additional add-in for Data Modeling because PowerPivot by default links the data with Data Modeling. It has an ability to create relationships between data from different sources and between multiple tables in pivot tables.

The powerpivot will store the data inside the Excel sheet so that it can be portable easily and conviniently. The processing speed is also fast when compared to Excel, this is due to xVelocity functionality in the PowerPivot.

ADVANCED DATA MODELING BENEFITS:

PowerPivot Filters the data from the export based on removing the unnecessary fields (which can also be called as subset)

PowerPivot, can rename tables and columns as you import.

Managing Data Model and Creating Relationships using drag and drop.

We can Define our own Calculated fields throughout the workbook

We can Define Key Performance Indicators (KPI's) to use in pivot table.

We can use Advanced Formulas that uses the Data Analysis eXpressions (DAX) language.

ADVANCED MODE IS BY-DEFAULT:

In Excel 2013, when you click "Manage" to go to the powerpiovt window, by dafult Advanced Tab will include here.

Note: To hide Advanced Tab, click to File Button in Home Ribbon by clicking on "Switch to Normal Mode".

DID YOU USE POWERPIVOT?

Please do share your views and thoughts about PowerPivot by using below comments section.

If you like this post, share it on your social networking sites by clicking on the icons placed around the blog.

If you want to become more passionate on PowerPivot JOIN US HERE. 

SOME IMPORTANT LINKS:

FREE EXCEL TRAINING

ADVANTAGES OF USING POWERPIVOT

NEW DAX FUNCTIONS GETTING ADDED IN POWERPIVOT

7 NEW FEATURES OF EXCEL 2013

Thanks,