Simon Hurst continues his KPI reporting casebook by incorporating some of the more advanced features available with Excel 2010, including PowerPivot.
Simon Hurst
Simon Hurst continues his tutorial series on KPIs by explaining how to present information clearly and with maximum impact.
Simon Hurst unearths and highlights some of the most commonly recurring themes from Excel Zone’s Any Answers.
Introduction
Simon Hurst returns to the scene of a previous management reporting tutorial to see how he can improve the presentation using new facilities in Excel 2010.
1
Excel’s VLOOKUP function is probably second only to pivot tables in popularity for management reporting and accounting users. Simon Hurst looks into its potential applications.
9
An article explaining the Named Ranges feature in Excel 2007 remains the single most popular item ever published on AccountingWEB.co.uk.
Simon Hurst draws on queries and answers from the ExcelZone archives to offer a collection of time-saving worksheet handling tips.
2
A round up of tips and tricks to help you cope with Excel’s arithmetic foibles.
Why are Excel calculations sometimes incorrect?
In response to recent Any Answers questions, Simon Hurst and Robert May have collaborated on an introductory guide advising accountants about their computer networking options.
