To me it seems Python or Julia notebook stuff like ipython or jupyter could (and did in some circles) displace Excel in almost all cases. The self-sustained inertia to change is real though.
Get into the world of the Excel user. Some of us do learn coding. But generally speaking? No. If it happens, it's on our own.
And we can agree that spreadsheets have problems, and Excel users typically are not data people.
BUT!
When we agree on that, it becomes evident that a lot of suggested solutions are non-starters. Not all Excel users are in an enterprise that's throwing money around for training and dedicated software.
I'd like to see the Warehouse Manager who goes in Monday morning and says to the company vice-president, "I've been looking into this Python class ... "
The Warehouse Manager or Sales Assistant doesn't need to learn an alternative, but e.g. the Finance people should. PowerBI/Tableau for reporting and R/Python for modelling should be a thing in those worlds (even if Excel continues to be an amazing tool for entry level stuff and some quick number crunching).
In my experience these take ages to load data that is near instant on Excel. I can totally see how people prefer excel.
Do I need to say it again? My Excel skills were necessary because of garbage in databases.
I could sit at my desk; extract a data-dump of 50k rows of data; locate the fuzzy matches, identify which records needed to be kept and which ones deleted; merge it with the client's spreadsheet that they emailed to me and compare them; identify problems and report back to the angry client.
Why was the client angry? Because of inflexible garbage reports coming out of the database that people were blindly trusting.
Why was there garbage in the database? Not because of Excel.
Can’t we simply accept this for what it is? Code nerds preferring a code solution while normal people simply use the modern equivalent of graph paper?