I was coming here to say this. Nothing compares to Excel. The problem with replacing Excel is that it has thousands of features, and every user seems to use a different subset of those features.
With that said, a large majority of users can probably get by with what GSuite offers.
Long have I wished for an open source spreadsheet tool built on a database backend.
I don’t hear the stories as much these days but for ages it was common for contracting firms to come into a place and find they’d been running the whole operation as an Excel spreadsheet and they had a very poor understanding of how complicated it would be to grow their system. Basically a complete rewrite to a DB model.
I thought for sure when Oracle bought Sun that this would be forthcoming but nothing came of it.
That was exactly my experience around two years ago. The brand of the company was far, far more valuable than their internal processes or capabilities as a result, and it was a painful migration (still is, from what I hear).
It's hard to describe why Excel is so good at what it does. The only way I can think to describe it is "the most amount of power for the least amount of work."
I agree. I have been using it for over 20 years now, and use it almost daily in many different capacities. Excel along with the entire MS Office suite of applications is ubiquitous across almost every enterprise.
I am curious how Airbus is going to handle external vendors, customers and organizations sending them complex Excel Spreadsheets and Word Documents.
They are big enough for their contracts to enforce usage of something other than the de facto standard.
Not only are they big but a lot of their suppliers are SMEs which in effect are economically dependent to Airbus (even if they carefully avoid dependence to them in the legal definition of the expression).
Do you have any performance benchmarking to show the difference between Excel and LibreOffice Calc, because my experience LibreOffice is much better on resources. I would like to see what tests you are using so that I can run them myself.
> I am wondering which Microsoft PR company you work for?
That’s really unnecessary.
I don’t have any of the alternatives available to me right now but if you’re honestly curious I could take another look this weekend and see if every widely used function has a shortcut. But from what I remember many don’t. I would love to see a plugin that maps excel shortcuts to either libre office or open office
And yes, I've learned Python, R and SQL, but these tools are not a replacement for the Excel workflow.