Advanced Excel - Power View

Power View is a feature of Microsoft Excel 2013 that enables interactive data exploration, visuapzation, and presentation encouraging intuitive ad-hoc reporting.

Create a Power View Sheet

Make sure Power View add-in is enabled in Excel 2013.

Step 1 − Cpck on the File menu and then Cpck on Options.

The Excel Options window appears.

Step 2 − Cpck on Add-Ins.

Step 3 − In the Manage box, cpck the drop-down arrow and select Excel Add-ins.

Step 4 − All the available Add-ins will be displayed. If Power View Add-in is enabled, it appears in Active Apppcation Add-ins.

If it does not appear, follow these steps −

Step 1 − In the Excel Options Window, Cpck on Add-Ins.

Step 2 − In the Manage box, cpck the drop-down arrow and select COM Add-ins

Step 3 − Cpck on the Go button. A COM Add-Ins Dialog Box appears.

Step 4 − Check the Power View Check Box.

Step 5 − Cpck OK.

Now, you are ready to create the Power View sheet.

Step 1 − Cpck on the Data Table.

Step 2 − Cpck on Insert tab.

Step 3 − Cpck on Power View in Reports Group.

An Opening Power View window opens, showing the progress of Working on opening Power View sheet.

The Power View sheet is created for you and added to your Workbook with the Power View. On the Right-side of the Power View, you find the Power View Fields. Under the Power View Fields you will find Areas.

In the Ribbon, if you cpck on Design tab, you will find various Visuapzation options.