Simon Hurst continues his KPI reporting casebook by incorporating some of the more advanced features available with Excel 2010, including PowerPivot.
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.
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.
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.
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.
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.
Simon Hurst considers the options for a small office network.
- New Range Name features in Excel 2007. By Simon Hurst 415,007 6
- Excel 2007 SUMIFS(): The accountant's favourite Excel function gets an overhaul. By Simon Hurst 54,192 4
- Build your own Excel Net to Gross function - Tutorial by Simon Hurst 23,894 4
- IT BASICS: Data validation for better spreadsheets. By Simon Hurst 14,163 2
- Microsoft Access uncovered - Simon Hurst tutorials 13,741 2