Long-time AccountingWEB contributor Simon Hurst has been touring the country extensively for the past two years passing on tips and advice on how to “work harder with Excel 2010”.
Microsoft launched Excel for Windows back in 1987 and effectively replaced Lotus 1-2-3 despite being a late-comer to the spreadsheet party.
Simon Hurst reviews the techniques available for extracting and reporting on accounts data with the tools available in Excel 2010.
We looked at using conditional formatting to present data in the first article in this t
Simon Hurst advises how Excel’s PowerPivot add-in can streamline your dashboard measures.
Why read a survey when the suppliers can tell you what it says?
For serious analytical Excel users, the PowerPivot add-in has been a revelation. Simon Hurst presents a preview of features that are about to appear in its next release.
Simon Hurst’s search for a silver bullet to cure Excel hell drew him to a meeting of like-minded enthusiasts at the Slaughtered Lamb in London on 25 January.
Simon Hurst completes his management dashboard tutorial series with a look at effective visual presentation techniques.
Having covered font formats including the use of Excel Styles and Themes and the
- New Range Name features in Excel 2007. By Simon Hurst 417,431 6
- Excel 2007 SUMIFS(): The accountant's favourite Excel function gets an overhaul. By Simon Hurst 54,352 4
- Build your own Excel Net to Gross function - Tutorial by Simon Hurst 23,967 4
- IT BASICS: Data validation for better spreadsheets. By Simon Hurst 14,204 2
- Microsoft Access uncovered - Simon Hurst tutorials 13,769 2