Category Archives: Risk

Corporate Governance and Safe Spreadsheet Practice

Posted on May 25, 2012 by

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 Risk, Research | Tagged , , , , , , , , , | Leave a comment

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

Posted on November 23, 2011 by

The European Spreadsheet Risks Interest Group (www.eusprig.org) 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

Posted on November 4, 2011 by

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’

Posted on October 26, 2011 by

He describes various scenarios and shows how people preferred one of the three risk management approaches offered in each case. http://www.workinginuncertainty.co.uk/study_integ_report.shtml “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

Posted on October 21, 2011 by

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 Risk | Leave a comment