![]() ![]() In this just select the Microsoft Office PowerPivot for Excel 2013 checkbox and click on the ok button like this: Now select the COM Add-ins under manage DropDown List and click on the go button like this:Ī COM Add-Ins Dialog box will appear like: Now select the Add-Ins option and under it select the Microsoft Office Power Pivot for Excel 2013 option. 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. 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. Now click on the Finish button in the next dialog box appearing like this: Now select the Enable selection of multiple tables check box and select the tables you want to include in the power pivot. In it just select the database from the dropdown list as shown below: ![]() Now a data Connection wizard will appear like this: Now select from SQL Server Option from it. Now click on the Data menu and under it just select the From Other Sources option. Let's have a look at the following steps. We can filter the unnecessary data just to import only the necessary data. We can make the relationships in the Diagram View by just dragging and dropping the fields of another table to it. In it we can rename the tables as well as the columns. It is the advanced data modeling feature in Excel 2013.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |