Like any tool, Excel works perfectly in the right situation, but enterprise reporting is not one of them.

My company used Excel with pre-upload calculations as the data entry frontend to the database . IT set up and maintained the workbooks.

Excel was perfect in that situation.

My manager from the home office was insulted when a consultant told them that they were not professional. The consultant was correct. They did not have a test environment, documentation or user instructions.

I added a test environment when I was hired and later added a running statistical error checking tool that used data from the database.

The user managers used the test environment to train new employees (unforeseen benefit).

Finally, if someone knows how to use a hammer and nothing else, they will drive that screw right into the wood and will be helpless with a flat-end bolt.

William “Bill” Myers, Analyzes all, Programmer, retired. If you learn anything new, find enjoyment, have a new thought, then I’m successful. Photo: 1st article

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store