We last wrote about spreadsheet abuse some time ago. But those are just the tips of the proverbial digital icebergs, and there are lots of circumstances that don’t fall under abuse but do account for inappropriate spreadsheet usage.
Part of the problem has to do with the universal appeal of spreadsheets: after all, they have been around for decades and the user interface of the grid of empty cells is so seductive. You just have to type in a number or a formula and you are good to go, right?
Well, not exactly. There are lots of warning signs that it is time to retire your Excel spreadsheet and move to something more sophisticated and capable to build your mathematical models. As a public service, let’s look at a few questions to get to the bottom of things.Posted in Project Management, Team & Project Management | Tagged Access, Excel, spreadsheets, SQL