Don't try this at home:
Things You Shouldn't Use Spreadsheets For...
Spreadsheets have been very valuable productivity tools for decades. We all use them to stay on top of daily business and personal tasks. They’re fast to create and usually easy to use. But there are some tasks that you shouldn’t perform using spreadsheets.
Here are some tasks you shouldn’t use spreadsheets for:
- Purchase Orders:
Formula errors can cost your company thousands of dollars when buying products. Once you find the errors, it might be too late and impossible to change.
If you have sophisticated budgeting needs, don’t use spreadsheets with numerous formulas and other complexity. Auditing these is very difficult and leads to errors.
First off, it’s extremely time-consuming to create and maintain spreadsheet databases. Secondly, it’s much easier to search for data in a true database compared to spreadsheets. Lastly, a real database allows you to keep information in one place, reducing opportunity for errors consolidating data.
- Product Information:
If you want to create an error prone product information management system, start with spreadsheets. When your clients ask you to send product information, consolidating product information contained in multiple spreadsheets is a time-consuming nightmare. If you use spreadsheets to manage product information, what’s your audit history for changes? There is none.