I'll never forget a past job where they used a lot of Excel in ways I did not know was possible.

First of all they had an invoicing system in Excel, that pulled in data using VBS, into Excel templates, and at the press of a button in the UI generated invoices from these templates.

And the craziest part was their server inventory system made in Excel, where they had drawn all the rack cabinets, you could click on each, to drill down and show all the servers in that rack. Also a ton of VBS, you could even get monitoring status of each rack.

Excel has been OP for a long time, long before its Python capabilities.

Did either of those systems have unit or integration tests?

nowadays, you can even use =WEBSERVICE(...) to access some web apis, if I understand correctly.