Select Page

Excel Video 484 Getting Started with Excel Power View Part 2

Nov 16, 2015Business Intelligence, Excel 2013

We’ll continue our discussion about getting started with Excel Power View in Excel Video 484. Watch for things that are easy to do in Power View but hard to do in a traditional Excel spreadsheet, and vice versa. We’ll chart our data a couple of different ways with Power View visualizations, and we’ll also introduce a way to map data inside Power View. This is different than Power Map. We’ll come back to Power Map in future Excel Videos. (Note that Microsoft in the process of changing the name of Power Map to 3D Maps in Excel 2016.) The mapping functionality is a great new feature in Excel, but the tradeoff is that the charts are much less flexible than a traditional Excel chart.

Also watch for the corners of a visualization and how easy it is to resize a visualization (with the diagonal arrows) and move a visualization (with the hand). Arranging data like this can be difficult in a traditional Excel spreadsheet where row height and column width come into play.

Now that we have a brief overview of some of the things Power View can do, we’ll slow down a bit in the next Excel Video and look at some sorting and filtering options. Thanks for watching.