Excel … It Doesn’t Add Up!
Disclaimer
First a disclaimer, I am not a fan of spreadsheets. There I’ve said it and I know it’s sacrilege to some.
Don’t get me wrong I use them as much as the next person but I’m always very careful in creating a spreadsheet based solution. As a veteran IT professional I’ve seen too many spreadsheets that should come with a warning slapped on them.
In the best cases they are often over complicated in construction and built without a thought as to what they may need to become in the future. However, in the worst cases they just plain don’t add up. Incorrect references and formula and the most eye straining designs you’ll ever have the misfortune to witness coupled with an obvious misunderstanding of the concept of a spreadsheet all mean too many spreadsheets are just not fit for purpose.
Be it a lack of training or a laissez faire attitude on the part of those who should know better in an organization in my experience it is a pervasive problem in organizations today.
Anyway, climbing down from my soapbox …
