Powerpoint, not for usability, but for the many terrible presentations I've had to sit through. I'm ambivalent on the UX because I rarely have to use it, but the dull meetings it's created have caused me an intense dislike of it.
That said, I'm still not fond of the Ribbon UI in general. Maybe it's just me, but I find text in a column easier to scan than a bunch of icons, most of which are hidden.
I tend to avoid them all. Though the other day I had to make a simple chart with excel (no problem for me in libreoffice or in the old versions of excel), and I just couldn't figure out how to change the scaling of an axis.
Eventually I found it. Not in a context menu anywhere, but somewhere in the ribbons, through an obscure "current selection" area, a place I would have never looked at on my own.
On the other hand I was pretty impressed by the change tracking feature in Word. Much more understandable for non-geeks than traditional source control.
Access is well known as being the anti-database that no one should ever use, but people still think Publisher is still acceptable for producing documents for print. DIE PUBLISHER DIE.
What I especially hate is that where I work, executives will send out e-mails about something with the body "please see the attachment about blah" and then include the actual message content in an attached word doc. On the upside, I've learned that anything sent this way can safely be ignored.
I'll do you one better: bug reports filed as screenshots of a web page showing an exception message pasted into a word document, attached to an email. Of course, the screenshots had been scaled down to fit on a portrait page, so the text of the actual exception (the only information we actually needed) was too small to read.
I'll turn it around. The only features of office I really like is the spell/grammar checker. I really wish MS would sell it as an independent application that can be used with any text application. Also, excell is OK, but other than that I really don't like office.
I loved what Access represented, but loathed what it was. I've yet to encounter a web-based tool that allows you to quickly build a relatively complex database with the ease that you could with Access. I've tried a lot of tools, but the one thing missing from most of them is the relational aspect. Access had great tools for relational data:
* Easy creation of [FORM [SUB-FORM]] constructs
* Easy linking of dropdowns and lists from table or view data
* Simple GUI for creating forms
* Intuitive data binding behavior
* "Wizards" for common tasks that require guidance
What sucked about Access was the back-end. Using an Access database over a network meant sucking huge chunks of data over the wire. I built a few Access databases with a SQL back-end, and use over a network wasn't all that bad.
And yes, I'm aware that my views are probably wildly unpopular with developers, but I live in a world with business users. Anyone want to venture a guess at the number of business users out there who are literally building databases out of Excel spreadsheets? I know plenty of people for whom a SQL "LEFT INNER JOIN" would make no sense, but they're perfectly happy using an Excel workbook full of tabs and VLOOKUP() calls all over the place.
ZoHo has a product called Creator that comes close, but when I tried it (a year or two ago), the "relational" aspect was missing. The master->child data relationship exists everywhere in business processes, but there are no user facing tools (except Access and Excel) that put the power of relational data in the hands of users.
You've got to be kidding! Think about it, Clippy wasn't really all that bad; he was always there for you, giving handy tips & tricks. But most of all, his funny animations provided a ray of light when you needed it most - when any of the above applications had driven you mad once _again_.
I'm not a fan of any component in particular, well apart from one surprise, so I thought I'd have a rant:
Word - separation of content and layout is an absolute bugger to manage. Hard to share and version documents. It's actually hard to write a letter or lengthy document with it if you don't have a template to hand.
Excel - utter dog if you need to use it for anything more than trivial and all it does is "ugly" and "puke". most problems are solvable in a cleaner way with a small script (python wins for me). Some crazy organisations use it as a database and email changes around to each other via outlook, leading to sync hell. Sometimes, that is the entire company's business floating around in emails. It's just the wrong tool for most jobs it is given. I usually get the job of replacing these turds.
Publisher - I've seen it used for paper aeroplanes only so I can't comment on its usefulness, or perhaps that is its primary use.
Powerpoint - Many an hour I've toiled in front of the output of this program. HOWEVER, it's far better than most of the awful hour long diatribes you have to sit through with whinging monotonic voices in the form of streaming (or should that be steaming) videos. 2 minutes content in an HOUR of my life and they don't skip properly. At least I can scan through a powerpoint in a couple of minutes.
InfoPath - never used it. It goes near Sharepoint so it's off limit for me.
Access - Access is actually really damn good, but only if you use ADB projects attached to a SQL Server database. If you use local MDB files and Jet, it's another Excel.
Outlook - It's better than Lotus Notes. That's the only credit I can give it.
Office 365 is the above products, done half as well, with a third of the performance, without the old fashioned data security of being able to get it all back easily from a USB stick.
> Word - separation of content and layout is an absolute bugger to manage.
This is the result of the WYSIWYG generation. "Ancient" systems like TeX (and even WordPerfect) did much better with this and got better looking output on balance, but with our newfangled "OOhh! Pretty!" systems, everyone thinks they're a designer. So, we get systems like Word.
That said, I'm still not fond of the Ribbon UI in general. Maybe it's just me, but I find text in a column easier to scan than a bunch of icons, most of which are hidden.