Audit spreadsheet risk or simply audit risk, like human spreadsheet risk, can be a source of material financial and business cost to companies; thanks to erroneous financial models or spreadsheets. There are three types of audit risk: control risk, detection risk and inherent risk.

Although Excel for Mac 2011 has greatly improved functionality that mirrors its Microsoft cousin, there are still many subtle aspects that can stump a financial modeller, when creating a seamless spreadsheet between the two operating systems.

The rich functionality of Microsoft Excel provides an array of approaches to tighten internal controls of corporate spreadsheets. Some of the below techniques may seem a bit extreme and over the top in some examples, but in other instances they will greatly tighten the management of a financial model.

The ubiquitous and user-friendly nature of spreadsheets has resulted in a heavily reliance by business. However, as a financial modelling professional, I am acutely aware its use and application can be good, bad or even downright ugly at times. There are certain areas of financial, business or management informational analysis, which are best served or kept in the sphere of accounting systems or databases.