Posted: October 19th, 2020 1:01pm +00:00

Are Excel spreadsheets robust enough for your business?

Excel spreadsheets have been getting some bad press lately, not least due to the Government using Excel to track and trace the coronavirus pandemic and losing 15,841 cases due to running out of columns.

Excel spreadsheets can be hugely valuable when used in the right way but as an expansive database the limitations are often going to outweigh the positive attributes.

Lack of Collaboration

Excel spreadsheets are difficult to maintain if the information is required to be updated by multiple people. Sharing and updating the spreadsheet and ensuring all parties are using the most up to date version can be an administrative nightmare. Simply not saving changes can result in a huge amount of time being wasted.

Human Error

With an ever growing and changing database it is simple for human error to occur. Simply placing a number in the wrong field can skew the data exponentially and auditing excel can be difficult.

Working in silos

If an individual takes ownership of the spreadsheet and the updating of the spreadsheet, then this does not allow for input from other business areas and does not allow information to be easily shared. Working independently will also have additional complications if this individual were to leave the business as the information would potentially sit dormant.

Most business outgrow Excel

As your business grows, the number of spreadsheets required is likely to grow. The rising number of spreadsheets will become unmanageable and will need to eventually be replaced with actual databases designed to store, manage, and report on live data rather than a snapshot of data. These databases tend to be more collaborative and reliable.

JCAD CORE

If you are using Excel for your risk management and this is now proving insufficient, then please get in touch for a demo of our risk management software. Our software is web based, making it perfect for visibility across the business as a whole, distribution of responsibilities is simple, reminders can be set, audit trail of changes as standard and reporting that can be exported as PDF, Word, Excel and HTML.

News you might like
How has COVID 19 affected your risk register?

Risk management is recognised by most businesses as crucial for business success. The pandemic has highlighted the importance of risk…

Read more
IRM Covid Response Survey

The IRM conducted a survey to find out how risk departments were responding to the global Covid 19 pandemic. To…

Read more
Thoughts on lockdown

So since March I’ve been working from home as have most of the other staff at JCAD. Initially I think…

Read more

JCAD will subscribe you to our newsletter . Please see our updated privacy policy for more information regarding the use of your data. You can unsubscribe whenever you like through the preferences option on the newsletter.