That's the problem right? You want to do something with Excel and it offers this amazing workflow design capability to non-coders. It's not just for accountants. Anyone and everyone with some idea of a process uses it.
But at some point you just want to do something as simple as parse a date in a weird format or extract the specific text from a cell and you start to hit a wall and have to switch to VBA or PowerQuery or hire a developer Python
What if I took all that functionality in Python Pandas and brought it to Excel. That way you get user friendly sheets that dynamically update - far easier to code and use.