I see that Microsoft’s Excel spreadsheet program has just turned 40, which is proof that you can fool a bunch of the people all the time (provided that you bundle your foul, inadequate software into a compendium suite which just “happens” to work okay with the core operating system which, lest we forget, you also created).
I don’t know a lot about a lot of stuff, and even less about software, except that I’ve been a spreadsheet user — at times, a very heavy spreadsheet user — all the way from early 1980s VisiCalc, to SuperCalc, Lotus 1-2-3 through Quattro Pro, while having all that time avoided Excel because its first iteration was dreadful.
Then I joined a company which only used MS Excel, and insisted that I do too (as well as the stupid Word and even-worse Access. Of course, it required re-learning all my old commands in a new language — not too difficult — but what was difficult was discovering that Excel had not really improved much over the years.
So I quit using the thing, did all my development and report design work in Quattro Pro — which was still the best spreadsheet program extant — and then translated everything into Excel, which was time-consuming and also counter-productive because a great many commands I’d used in Quattro as a matter of course had no equivalent in Excel. (Bear in mind that this was back in the 1990s and early 2000s, and things may have changed since then.)
Also, Quattro’s companion database product Paradox was streets better than pretty much all other such programs back then, which hamstrung me even more.
It always struck me that MS products, like Apple’s, are great if you’ve never used anything like that before. If you have, however, and are familiar with the competitive products, MS always comes up short.
Nowadays, my needs are a great deal more modest than back then, so I use Apache’s Open Office suite (Writer and Calc) because a) they work just fine for me and b) they’re free.
Now, if I have to send someone something I wrote or crafted on a spreadsheet, I just tell the recipient to download Open Office to be able to read the stuff. (I should point out that the Son&Heir used OO Writer exclusively to write his papers all the way through college, and never had a problem — to this day it’s the only thing he writes with — but at his job at Global MegaBank Inc. he has to use Excel, which he hates more than I do.)
So Happy Birthday, Inferior Spreadsheet Product, for what that’s worth. (Nothing, by comparison to Open Office’s Calc.)
Thing is, with how M$ has set up their “M365 subscription licensing” anymore, it includes stuff that most companies consider “good enough” all included in the price of the sub. I’m an IT guy, and I’m constantly fielding requests from users to use 3rd party improved programs instead of the base M$ ones, but for the most part I have to deny them and just say “The M$ product already does that and we already have it, so… no, we won’t buy a license for something different that’s better.”
It sucks for everyone, but… there it is.
Open Office hasn’t been updated in many a year now. It’s been superceded by a product called LibreOffice which is based on Open Office, but has been very pleasantly upgraded to eliminate most of the frustrations of “dad-gummit, that’s a simple function in Excel, how the hell can I do it in Open Office Calc?” It also exports and imports modern Excel formats if you need to play nice with others.
Those of us who appreciate/need the features of Excel, but wanted to get the hell out of it because Microsoft, now have a product that has 99+% of the features, but ain’t Microsoft. (Open Office was about 60% of the features and a source of continuous frustration when trying to do serious work.)
Kim, I heartily recommend that you move to LibreOffice, if for no other reason than it is actually supported by development team and bugs get fixed.
Duly noted, and thankee. As much as I hate change, I’ll look into it.
I’ll second the Libre Office recommendation. I use it on both Linux and Windows 10 / 11 machines and it just works. Only warning is that it doesn’t like Excel macros and will not process the ‘Basic’ language Microsoft uses for complex macro work.
Not processing the macros and basic is probably a good thing as they are the source of most of the embedded malware in Excel files. They are also the source of most of the abuse of Excel by folks who should be using a real programming language but don’t. Ask me how I know.
Back in the early 90’s I was working for a camera store chain in Chicago. After getting kicked upstairs from a pro store to the purchasing department I got the job of updating the stores’s price sheets (the stores still used written receipts, no computers). We used Excel to make the price sheets. One day I had the damndest time trying to make something work. Not being the best at math I checked my algebra three times, but the formula just would not work in Excel. I asked a buddy who’d been there a year before I came up, and he told me, ya, that won’t work. And he showed me a longer formula that you had to plug in to get the right numbers. It made no sense, but that was Excel.
I haven’t made the leap to Linux yet, but to this day I’ll use ANY programs other than Microsoft’s – especially if it’s freeware. So I’ll second Uncle Kenny’s endorsement of LibreOffice.
Worse than the program itself is the insufferable Microsoft fanboi powerusers that built overly complicated spreadsheets.
Want a little despair? Borland was bought by Micro Focus, which was bought by OpenText.
I can say with some authority that their products are most likely being shoved in some huge virtual warehouse like at the end of Indiana Jones, with only a Milton with a red stapler down there to support them.
My wife is a CPA and CFO, and is an Excel master. She regularly creates/uses/edits spreadsheets – multiple documents, at the same time – of insane size that will bring her laptop to its knees. You can hear the fans spin up when she starts working. She gets a new work laptop upgrade every year, with the latest CPU and the most RAM they can cram in. She also hates Google Sheets with a passion.
That said, I showed her a video of the Excel Championship (imagine turning Excel into a competitive sports match), she rolled her eyes and said those people were insane.
https://www.youtube.com/live/UDGdPE_C9u8?si=acT5wB5Wm7n_j1U9
I worked in IT at Investec the asset managers. The business was growing so fast that the clients’ accounts software kept on falling down. Investec got a herd of accountants in to audit the accounts before incorrect statements were sent out to clients, with embarrassing results. The method chosen was to download from the database into a Borland spreadsheet. Then a macro script had to be run to convert the data into a readable format. This script could take anything from five minutes to an hour to run, depending on the number of transactions. While it was running the auditors sat idle, at a pretty high hourly pay rate, so they weren’t complaining. I took the spreadsheet and converted it to Excel, using Excel Basic in the place of macros. Typically even the biggest run took under three minutes. Then the auditors started complaining… Excel is good stuff.
The entire FinServ industry runs on Excel. Sure they have other systems, but more often than not the data entry, initial processing, reporting, and especially the financial modeling is done in Excel. If it were magically removed from the world, there would be a total meltdown of the financial system in the country and probably the world. And that’s not really an exaggeration. It’s terrifying.