You could also select the “Delete” command from the pop-up menu to delete a selected relationship from the data model. You can also right-click on the relationship line shown between two fields, and then select the “Edit Relationship” command to open the “Edit Relationship” window, if needed. You can also create relationships between tables by simply clicking and dragging a field from one table and then dropping it onto the related field within another table. This view allows you to see the tables in the data model as diagrams that display the links, or relationships, between fields in the tables. In addition to the “Data View” of the data model, you can also view the “Diagram View” of the data model by clicking the “Diagram View” button within the “View” button group on the “Home” tab of the Ribbon within the data model window. You can click the buttons within the navigator to move back and forth through the records within the selected table. A recordset navigator is displayed for the currently selected table at the bottom of the window. You can click these tabs to switch between the tables within the data model. In a separate pane below the data area is the “Calculation Area.” Below the calculation area you can see the names of the various tables within the data model displayed as tabs. Below the Formula Bar is the “Data View” of the tables within the data model. The Ribbon within the “PowerPivot for Excel” window has four tabs: “File,” “Home,” “Design,” and “Advanced.” Below that is the Formula Bar within the data model. You can click the “Manage” button within the “Data Model” button group on the “PowerPivot” tab within the Ribbon to open a separate, visual instance of the workbook’s data model that you can then manage in Excel. You can click this tab within the Ribbon to view the commands used to mange your PowerPivot data within Excel. Check the checkbox for the “Microsoft Office PowerPivot for Excel” add-in, and then click the “OK” button to the right to enable the add-in.Īt this point, you should see a new “PowerPivot” tab appear within the Ribbon. At the bottom right side of this window, select “COM Add-ins” from the “Manage” drop-down and then click the “Go…” button to open the “COM Add-Ins” window. Within this window, click the “Add-Ins” category shown at the left side. Then click the “Options” category at the left side of the backstage view to open the “Excel Options” window. To enable PowerPivot, click the “File” tab in the Ribbon to open the backstage view. PowerPivot is an “Add-in” program that must be enabled within Excel before you can use it. PowerPivot essentially expands the abilities of the Excel data model to allow for robust data management and reporting for PivotTables and PivotCharts.īefore you can begin using PowerPivot, however, you must enable it within Excel. PowerPivot is not available in Excel 2007. It was also available in Excel 2010, but has seen many improvements to its functionality in the 2013 version.
How to use microsoft excel 2013 plus#
PowerPivot is an add-in that is included in Microsoft Excel Professional Plus 2013.