Today MS Office is still broken in a number of crazy ways. One of the most annoying ones is that if whoever packages and deploys Office to our computers use localization for the user interface, suddenly all formulas are in some broken local language variant making it next to impossible to search for it.
If I know the solution with standard Excel language it is doable to translate it to this broken "Norwegian BASIC" language, it is just really really annoying.
A quick and easy solution then is to write it in Libre Office Calc, export it to xls and import it and done.
With Libre Office I can also choose if I want cute "Ribbon" menus or easy-to-use menus.
List probably goes on, this was just the things from the top of my head.
[1]because it felt almost impossible to do in an efficient way in MS Office even if I had significantly more experience with it)
"The Wall of Shame for the Worst Excel Errors" - https://www.solving-finance.com/post/the-wall-of-shame-for-t...
It sounds like you are picturing in your head that all spreadsheet work is greenfield. Do you have any idea how much Excel code is embedded everywhere? Very often made by people who are no longer around. You can lecture all you want, but this is the situation. I don't like it either.
Did not intend to be smug...honestly..not really. :-) In my defense, I have more than 20 years corporate experience in tech AND finance domains, in more than 25 countries. And in the cultural domains of the five different languages I am familiar and whose grammar I regularly brutalize. Can't recognize the problem you are describing, as the mountain that would stop any company from start using LibreOffice.
All that logic in Excel sheets is just a serious governance problem...
"How an Excel error cost JP Morgan $6 billion" - https://www.linkedin.com/posts/eriklidman_how-an-excel-error...
Oh, BTW. Nextcloud is also nice. Very nice.
Edit: Looks like Owncloud guys have arrived (just joking, I like them equally).
Setting up access for my wife was easy. Adding "apps" to my nextcloud instance was easy. Sharing storage, playing with a Kanban board, editing documents, it all just works.
I'm very impressed with nextcloud, I had no idea it was so good!
It updates nicely too. I'm managing one for ~4 years now, and it's painless.
Nobody calls for me for support either. I think this is, good?