Simon Hurst, one of the members who worked to assemble the publication, examines ICAEW's 20 principles for good spreadsheet practice.
As well as numerical data, text often finds its way into spreadsheets. Simon Hurst explains different ways you can deal with it.
Simon Hurst turns his attention to standard Excel functions such as SUMIF and SUMPRODUCT that make it easier to produce summary totals.
In the previous instalment in this series we looked in some detail at the Power View add-in
Simon Hurst delves deeper into the reporting and visualisation capabilities of the Power View add-in for Excel 2013.
After looking into some of the more sophisticated reporting and analysis tools in Excel 2013, Simon Hurst goes back to basics with a tutorial on the spreadsheet program’s enhanced charting feat
In an earlier part of our series looking at new tools for working with accou
Can't live with it. Can't live without it. John Stokdyk explores the management accountant's love affair with the spreadsheet.
- New Range Name features in Excel 2007. By Simon Hurst 452,236 6
- Excel 2007 SUMIFS(): The accountant's favourite Excel function gets an overhaul. By Simon Hurst 57,990 4
- Build your own Excel Net to Gross function - Tutorial by Simon Hurst 24,977 4
- Excel 2010 KPI tutorial 3: PivotTable dashboards 20,420 5
- ExcelZone Compendium - Practical tips for using SUMIF() and IF() 15,684