Working with accounts data in Excel: Power View

Simon Hurst delves deeper into the reporting and visualisation capabilities of the Power View add-in for Excel 2013.

So far in this Working with accounts data series, we have been looking mainly at the process of linking to data and summarising and manipulating it, using PivotTables to produce the figures required for reporting before, in the last episode, starting to look at ways of presenting the data.

The last part finished with a quick look at the Power View add-in and how it could be used to produce, among other things, a 'playable' chart that can be used to show changes over time. This time we'll work through Power View and some of its other visualisation features in more detail.

Like the Inquire add-in and Power Pivot, Power View is available with the Professional Plus edition of Excel 2013. According to the Microsoft store helpline Power Pivot, Inquire and Power View are now also included in the UK commercial version of Standalone Excel 2013, available for about £100.

If you do have the right edition, you should see Power View in the Reports group of the Insert ribbon. 

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.