MS Excel

[wobs]

They can take my spreadsheets from my cold dead hands!:

Excel: Workers cling to the software despite shift to AI

Companies are trying to wean staff off Excel spreadsheets to centralise control of their data.

www.bbc.co.uk

Seriously though, while I do recognise it can be over used, it is more useful to play around with data than a database. I get so many requests to provide data in different ways, I need that flexibility.

 

[jt512]

Excel has its place. It is a very useful tool for manipulation of small, simple datasets. But, especially for large data sets, anything you can do with Excel you can do at least as well (usually better) with dedicated database, graphics, or statistical software. It is extremely easy to introduce errors into an Excel spreadsheet, and usually extremely difficult to find them once they are introduced, as there is no audit trail to follow. As a statistician, I have had to deal with many Excel "databases." I can count on, like, one finger how many of those were error free. It was common to spend more time correcting the data than doing the actual analysis.

 

[Worm]

Excel very much has its place, it gets relied on too much, particularly when it comes to large data sets, but it's a great tool to allow general access to data tools for non-tech adept people. The greatest failing of Excel I see is that most people don't use about 80% of its capabilities. I'm guilty of this myself, and I'm always aware of not introducing 'clever' or complex processes into a spreadsheet that other people are going to have to maintain later on, but every time I see a report with charts included using 'default' excel settings, a little part of me dies.

 

[jt512]

Excel very much has its place, it gets relied on too much, particularly when it comes to large data sets, but it's a great tool to allow general access to data tools for non-tech adept people. The greatest failing of Excel I see is that most people don't use about 80% of its capabilities. I'm guilty of this myself, and I'm always aware of not introducing 'clever' or complex processes into a spreadsheet that other people are going to have to maintain later on, but every time I see a report with charts included using 'default' excel settings, a little part of me dies.

Every time anyone views an Excel graph a little part of them dies. They just don't know it.

 

[wobs]

I'm trying to wean people off storing source data in annual Excel spreadsheets, but this isn't the greatest horror I've come across.

These include, but not limited to:
Storing source data in annual spreadsheets, but each month is on a separate sheet, so linking to them required annually updating links for each month. I have managed to get this onto a continuous sheet, and data is downloaded from our system, so the data should be correct now.
There is still a spreadsheet on site that has some monthly totals taken from another spreadsheet for data analysis. This is ok, but..... The months are in alphabetical order! Its been like this for years, and I don't have write access to it, I can only view it.

 

[Wudang]

The worst my wife saw was a Excel "database" that kept being expanded by the person who wrote it. But each new use would mean acting as if it was a new app so each person had their address, for example, entered 14 times.
I inherited an Excel tool written in VBA. The bank we worked for had an approval process for new software. I used it once and held a little party each year on the anniversary as I waited for it to be approved. The tool was quite interesting except he used 1 char variable names and has never heard of "pass by value" so it had lots of fun bugs. Once he retired I did a major code clean up.

 

[Brainster]

And if you tried using Excel as a word processor you'd probably run into lots of other problems. Excel has its uses and does have some simple database-type functions like sorting, and at times you can tease out data using "if-then" formulas. If you really want to do more sophisticated data analysis, it's much better to use Access. I commonly used Excel to fill in forms that I then pasted into Access, ran a few queries and pasted the results of those queries back into Excel so I could present it however I wanted.

 

[Trebuchet]

When the only tool you have is Excel, every problem looks like a spreadsheet.