They really don't. I've been at such an org as described by OP. I've owned a system of production R/Excel and it was migrated to cloud + python + ETL over 4 years.
The places where Excel are used are fairly appropriate. Way downstream, for simple tasks.