Whether you are a finance person working on balancing the sheets (or whatever else they do, that's beyond my knowledge) or an operation person building complex macros, it is both versatile, easy to use and yet powerful.
The byproducts of this is that it is also subverted by the genius of human ingenuity and you end up with some pretty interesting, awe-inspiring contraptions.
Such as building a calendar system but using arrow graphs to fill it out. And that's fine, except when you try to scale things up to automate the process and save people money. Now you have to do some pretty wasteful engineering to accommodate this pesky creativity we have.
That is the really interesting and a testament to being a really good software (in features and reach). It breaks the boundaries of the limited vocabulary of computers and therefore can only be fully leveraged by humans.
It's both a great reminder that most people in the world are not on the same level as the crowd around here [1] and that as the group who create tools used by such an audience, we have to be mindful of that.
On a positive note, I think there are some interesting work being done to rethink how to approach those tasks, I remember using one product in particular that had the right mix of being visually engaging while enforcing boundaries. But this won't solve the issue of users having to hack their way into getting what they want how they want it.