How to Use Power View in Excel 2013
Starting Power View
Power View is a reporting tool that is available in Microsoft Office Excel Professional Plus 2013. You must first enable Power View in Excel 2013 before you can use the reporting and visualization features of the tool. Note that to use Power View, you must also have Internet Explorer with the Silverlight add-in installed. If you do not, you will be prompted to install Silverlight when you initially enable Power View in Excel 2013.
To enable Power View in Excel 2013, click the “Insert” tab in the Ribbon and then click the “Power View” button in the “Reports” button group. If this is the first time that you have used Power View a dialog box will appear that tells you to enable this feature. Click the “Enable” button to turn Power View on. Excel 2013 will then insert a Power View reporting worksheet into your Excel workbook. If you need to install Microsoft Silverlight, you will then see a message at the top of the Power View worksheet informing you of that fact. You can click the “Install” hyperlink in the message bar to install Silverlight and then click the “Reload” button in the message bar to reload the Power View worksheet.
Once you have enabled Power View in Excel, you can then insert a Power View worksheet into a workbook by simply clicking the “Power View” button in the “Reports” button group on the “Insert” tab within the Ribbon. You will then see the “Power View” tab appear within the Ribbon.
Note that you can insert a Power View worksheet that uses a selected table as a data source by simply clicking into the table within the worksheet, first. You can then click the “Power View” button in the “Reports” button group on the “Insert” tab within the Ribbon. Alternately, you can select an empty cell within a worksheet and then click the “Power View” button to create a blank Power View worksheet to which you can add fields from the workbook’s data model by using the “Power View Fields” task pane that appears at the right side of the Power View worksheet, just as you would if creating a PivotChart or PivotTable.