The advantage of excel is that any office worker can perform data manipulation there. It can't be replaced for una-tantum operations on data, because it isn't practical to do custom implementations every time you need something.
The alternative is to teach programming to every office worker and give them access to the db. Not sure it's a good idea
Programming in business environments is becoming ever more popular using languages like Python and R
It’s nowhere near as pervasive as Excel but I could see AI playing a big part here. Most Excel domain projects don’t require a high degree of technical understanding so autogenerated Python code that is “good enough” can be easily generated. Hell AI alone could take over most of the basic data crunching usecases.
You don't make every worker learn programming. You either hire programmers to make a custom financial suite so that people can input things and then the software does the relevant calculations, or you buy one. SAP is an example of that. They're not worth 300 billion for no reason. There's also custom suites for many different industries, because many have different needs.
The point is that the ability to make custom software replaces Excel... Since Excel is extremely prone to allowing users to mess up.
Edit - I guess no one's adjacent to industries where accounting software rules? Like O&G?
Sure, more complex things can be handled by custom software, but there are still basic things that spreadsheets handle just fine. No need to reinvent the wheel.
Even large companies that use SAP still rely on spreadsheets for simpler needs.
There's a reason Excel rules the world. And it's not because there aren't programmers capable of writing "custom financial suites".
But because Excel can handle most anything you can throw at it
> SAP is an example of that. They're not worth 300 billion for no reason
Yes. There's very little reason for SAP to be worth that much. SAP are infamous for their projects that are nearly always over time and over budget and still don't do what was intended.