alt Hacker NewsI didn’t really appreciate excel fully until I worked at a company that forbid software development and had implemented a whitelist policy for executables. VBA was blocked too.
Excel on Windows was the only tool available, outside of offering sacrifices to the high priesthood of IT.
It is a supremely elegant tool capable of deep data integration and extraordinary analysis, if you approach it with an engineer’s mindset.
This was during the time when they started introducing lambda and related functions. Nowadays, Excel is even more of a superpower.
Unfortunately, Excel on Mac is not nearly as good. It has all the features, but it’s missing a lot of the UI needed to use them effectively.
Replies
The console in browsers is also very useful
Especially since it uses your cookies by default.
Were you able to process truly large datasets? I worked at a very excel company once but we kept running into row limit issues when scaling workloads and eventually migrated almost everything away from it. What industry were you in at the time?
> Unfortunately, Excel on Mac is not nearly as good. It has all the features, but it’s missing a lot of the UI needed to use them effectively.
Someone could just vibe code that. I'm not even kidding.
I've worked at places like they. They did have a self-service app store you could use to install things. It also had an approval system for anything that cost real money for a license. Excel was the bread and butter for many engineers for a long time to make functional tools. The great part of Excel is you could make little GUIs with the tables, not exactly QT, but you could have labels and textboxes. We regularly used a tool up until 2020 that was originally created in Excel 97.
MATLAB was the runner up for our tools but the good part about Excel was that every PC had it whereas MATLAB wasn't and also needed network access for the license (or else your program/department had to buy a node license). Later, many people switched to python since not everyone loves MATLAB and it's more of a real software language (and it's free) than what's effectively a very expensive calculator.