For today’s quick example, I will create a simple table as shown below: In fact, the Power View Fields panel tells me that I need to create and select a range of cells with data and then click Power View from the Insert tab to proceed. In addition to the Power View worksheet, you should see a Power View tab with several options as shown below:īecause I started from a blank spreadsheet, I have no data I can use in my Power View report yet. When the process completes, click the “Reload” button in the message bar to return to Power View. If you do not have Silverlight installed, you will be prompted across the top of the Power View worksheet to do this. This opens a separate Power View worksheet in the current workbook which will look something like the following: If this is your first time using Power View, you will need to enable it by clicking the Enable button that appears. Next open the Insert ribbon in Excel 2013 and click the Power View button that appears in the Reports group. From the list of available add-ins, locate Power View and make sure the checkbox to the left is selected. Using the drop-down menu select: Com Add-ins and click the Go button.
At the bottom of the right panel is an option to manage different classes of Add-ins. If you have those prerequisites, you can enable Power View by opening the options dialog in Excel and selecting Add-Ins. To use this tool, you must also have installed Internet Explorer and Silverlight on your computer. Just like PowerPivot that now comes preinstalled with Microsoft Office Excel Professional Plus 2013, so does Power View. But did you know that there was another way to visualize your data within Excel 2013? You many even have used the Pivot Chart capability to display your data results visually. By now you should have a pretty good idea how to build data models and analyze your data.
I have used many of my blogs over the last couple of years to talk about PowerPivot in Excel 2010 and Excel 2013.
0 kommentar(er)
