Adding Power Pivot Add-Ins in Excel 2013

This is a new feature introduced in Excel 2013. It is the advanced data modeling feature in Excel 2013. In it we can rename the tables as well as the columns. We can make the relationships in the Diagram View by just dragging and dropping the fields of another table to it. We can filter the unnecessary data just to import only the necessary data.

Let's have a look at the following steps.

Step 1

Go to Excel 2013.

Step 2

Now select the blank workbook.

powerpivotaddins.jpg

Step 3

Now click on the Data menu and under it just select the From Other Sources option.

powerpivotinexcel.jpg

Step 4

Now select from SQL Server Option from it.

Excel2013powerpivot.jpg

Step 5

Now a data Connection wizard will appear like this:

Excelpowerpivot.jpg

Step 6

In it just select the database from the dropdown list as shown below:

addpowerpivotaddins.jpg

Step 7

Now select the Enable selection of multiple tables check box and select the tables you want to include in the power pivot.

powerpivotinexcel2013.jpg

Step 8

Now click on the Finish button in the next dialog box appearing like this:

addpowerpivot.jpg

Step 9

Now an import data dialog box will appear; in it just select the PivotTable Report option and click on the Existing worksheet option and click on the ok button.

addinspowerpivot.jpg

Step 10

A pivot table will appear like this:

powerpivot.jpg

Step 11

Now to add the Power Pivot Add-Ins in Excel 2013 first click on the File menu option and under it click on the Options menu option.

powerpivotaddins1.jpg

powerpivotaddins2.jpg

Step 12

Now select the Add-Ins option and under it select the Microsoft Office Power Pivot for Excel 2013 option.

excel2013powerpivot1.jpg

Step 13

Now select the COM Add-ins under manage DropDown List and click on the go button like this:

excel2013powerpivot2.jpg

Step 14

A COM Add-Ins Dialog box will appear like:

addpowerpivot1.jpg

Step 15

In this just select the  Microsoft Office PowerPivot for Excel 2013 checkbox and click on the ok button like this:

addpowerpivot2.jpg

Step 16

Now we will see that the PowerPivot menu option appears like this:

addpowerpivot3.jpg

Step 17

In it just click the to manage option to manage the data model.

excelpowerpivot3.jpg

Step 18

A PowerPivot window appears like this and in this two tables appear like this:

excelpowerpivot4.jpg

Step 19

Under it we can change the column name like this:

excelpowerpivot5.jpg

Step 20

In it we can view the diagram view by clicking on the Diagram View option like this:

powerpivotaddins4.jpg

powerpivotaddins5.jpg

We can do such tasks and just try to do other things on your own.


Similar Articles