Excel is completely terrible but it puts real analytic power in the hands of non-technical people. For most business organizations, Excel alone is worth the price of Office, even if only a couple of accountants or marketing people use its power features.

Better to solve the right problem the wrong way.

Come to think about it, "too flexible and yet not flexible enough" describes all the popular scripting languages, too - Python not least among them.