I'm a heavy Excel user, and I have yet to find a usecase that cannot be solved in Sheets. It has App Script after all, for whenever you run into a feature that isn't there. But even then, I've translated many Excel functions to native Sheets array_formula equivalents, and found the latter much more ergonomic.
Much of Excels dominance is due to its legacy pervasiveness in certain industries/ roles (notably finance or financial related but there’s strong bureaucratic use of it as well asan ad-hoc tracking tool for instance) and the fact that two generations of people grew up using it.
I’ve noticed over the years that younger generations are far more used to using Google Sheets since schools and universities have strong adoption of Google Workspace. As a result, I’ve seen less and less use cases that were once believed to be Excel only domains turn out not to be.
I’m not going to proclaim the death of Excel by any means but it’s not as ironclad of a leader position as it once was. There is however some increasingly niche cases where Excel can do things that Sheets can’t, or doesn’t do as well. One non obvious (for todays environment) use case being offline portability, Excel being a standalone program really helps here.
That said, they both suffer from one issue that’s the same, which is there is no ergonomic way to run business logic rules over the calculations easily (and some cases at all)
