Category Archives: Risk

Corporate Governance and Safe Spreadsheet Practice

I am giving a presentation at the Institute of Chartered Accountants Ireland in Dublin on 5th June at their event “Corporate Governance and Safe Spreadsheet Practice – The Importance of Mitigating Risk for Professionals” which also features Dr Kevin McDaid of … Continue reading

Posted in Research, Risk | Tagged , , , , , , , , , | Leave a comment

The Science of Spreadsheet Risk Management, July 5-6 2012, Manchester UK

The European Spreadsheet Risks Interest Group ( has issued a call for papers for their 13th Annual Conference on the theme “The Science of Spreadsheet Risk Management”. The conference will be held on the 5th and 6th of July 2012 … Continue reading

Posted in Excel/VBA, Risk | Tagged , , , , , , , , | Leave a comment

Free Excel formula highlighting tool

My main product is the XLTest addin that does a comprehensive shakedown of Excel workbooks. I’ve picked out the most popular feature, colour coding cells by formula region, and give it away as a free taster, the XLTest Colorizer. It … Continue reading

Posted in Excel/VBA, Risk | Tagged , , , , , , , , , , , , , | Leave a comment

Matthew Leitch’s survey on ‘integrated risk management’

He describes various scenarios and shows how people preferred one of the three risk management approaches offered in each case. “It shows that most people recognize it when they see it, and would be much more likely to recommend … Continue reading

Posted in Risk | Tagged | Leave a comment

List of Mac Excel 2011 differences from Excel 2007

1) DIR() returns error rather than null string, so trap it 2) rg.Find Searchformat named argument not found Same for ReplaceFormat 3) rg.Autofilter Help says “If you omit all the arguments, this method simply toggles the display of the AutoFilter … Continue reading

Posted in Mac, Risk | 1 Comment