Have you ever wanted to create a Report in Excel in order to represent and visualize your data more professionally? You thought that the whole idea of creating a Report will be difficult and very confusing? This is where PowerView appears in Excel. What can we do with Power View?

We can create Charts and other Visualizations.

We can filter and highlight data in our spreadsheet.

We can sort tables, bars and column charts.

We can print PowerView reports and do many more other things. All we have to do is to follow the steps below. This post will be the first part about PowerView.

First of all we must select the data that we want to represent in a report and then select the Insert tab and then from the area of the ribbon named Reports we select the Power View command as shown in the image below.