Calculating your risk when using Excel
We all know that there is an intrinsic risk in using Excel extensively in your business.
Research shows that over 80% of Excel workbooks are either faulty or not adequate for doing the job.
Still, we all love the flexibility and speed in which Excel allows us to get results for complex situations.
With great flexibility comes great responsibility to use this freedom wisely and carefully.
It’s like driving around in your car, not wearing a seatbelt…
When it comes to Excel you need to create your own seatbelts and airbags…
And unfortunately in many organisations that is not the case.
So, how do you actually calculate the Risk you are facing.
In my view there are three components to consider…
- The team size [TS] – the more people work with Excel, the bigger the risk
- The number of Excel models [EM] you are running
- Your turnover [TO]
If you now multiply them:: TS x EM x TO
and take the square root you have a solid dollar figure for calculating your risk.
Maybe you have 10 people in your team and 10 Excel-models and a budget (turnover) of 10,000,000 your risk is SQRT(10 x 10 x 10,000,000)… That results to 32K per annum.
And when you are looking at your whole organisation with 100 employees and 100 Excel-models and a turnover of 50m your risk equates to 707K per year.
Why not pick up your calculator and do it for your team or organisation?
Here’s what you can do today to mitigate that risk:
- udit and certify your most crucial Excel models
- Automate them as much as possible to minimise manual work
- Systemise your models to have a well documented company – wide structure in place
My clients can expect to trust their numbers and minimise their risk when using Excel.
Please give me a call to find out how I could help you.
“The changes Jürgen made have resulted in a substantial time saving and improved the reliability of our process allowing us to focus on the analysis rather than the collation and manipulation of data. Jürgen isn't just an Excel guy but really understand process flows and the business outcomes. Thanks again.”
David Barton – Club Plus Super
Building Better Systems: Here are three ways I could help you right now…
- You have an idea or a problem to solve and you don’t know where to start and want an honest, straight forward sounding board with business acumen and IT experience. Call me to discuss.
- You have an existing Excel – solution that does not do what it supposed to do. Here I can do a thorough assessment and audit of your model and give you recommendations for moving forward.
- You want to work privately with me to weave some magic into your workflow models that will allow you and your team to base your million dollar decision on the right data. Just email me to set up a time for a chat.