Microsoft Office isn't a decent platform, none of its tools stand out for quality, and most are just gimmicks.
Well this is just ridiculous. It is an oft-repeated meme that "The world runs on Excel" because it's true. Ya, huge, well-planned things actually run in databases, but for everything else, it's Excel. Same with Word, PowerPoint, and Outlook. Those three programs are the basis for most major enterprises and anyone who attempts to say otherwise with a straight face is ignorant of the real world or has an axe to grind.
Look at Power BI, it's analytics for people who don't understand analytics, and stripped of all useful data inspection tools.
It's analytics for people who know how to use Excel and need to show the results of the analytics online. That's not bad.
Should we talk about Visio? The flow chart / diagram / drawing tool that isn't compatible with anything, and isn't a good at any of those tasks!
Vizio could/should be integrated as a feature pack in PowerPoint. It doesn't need to be standalone.
Should I start listing the tools that are terrible? (Apart from those listed above): Forms, Calendar, Engage, Sway, Steam, ToDo, Whiteboard, Bookings, I'll stop.
Forms is unnecessary. SurveyMonkey and Qualtrics have that area locked down.
Calendar as a part of Outlook is intensely functional.
Sway is an outright gimmick.
Stream is transitioning into Sharepoint.
ToDo should just be a feature pack for Outlook.
Bookings is great if you need people to make meetings on your calendar without direct interaction. This is particularly useful for customer-facing fronts.
Personally, I'm still sore about the loss of Microsoft Mappoint. It was the only way I could cheaply (nearly free) and easily geocode a ton of addresses and then run experiments on travel distances, travel times, and proximity. It was a HUGE tool in sustainability. ArcGIS is nowhere near as usable and as a couple years ago when I last looked for replacements, everything out there wants to charge you to geocode per address (or per hundred addresses).
So ya... just like EVERY major company out there attempting to innovate in the software sphere, they make some pieces of software that won't be relevant to you. Eventually unpopular pieces die off. (See: Google.)