I agree with your first post, personally I think less is better when formatting spread sheets, when you go to a meeting and you have to view a spread sheet that has been put together by a dyslexic colour blind psychedelic nutter the urge to kill grows, some have come to the conclusion that I have man management problems as I sit there wishing the devils badness on the author.
As an opponent to junk charts, 3D exploded pie charts would be close to useless for me. But for something I never, ever use? The ability to right-click on the windows scroll bars and having all those options. If I can take the time to right click and choose, I could have just left-clicked and got there right away.
Next would be the BAHTTEXT and the CONCATENATE functions.
For workbooks with an important number of Shapes with event triggered actions, handling naming and changing properties is so weird that forces you either to use VBA code to do the job or avoid using Shapes at all, replacing them by other controls (Forms or ActiveX).
So Shapes isn't at all the most useless Excel feature but it's turned into that because of the interface provided to use them.
"It's been suggested (by an anonymous Excel MVP) that the Excel programmers enjoy Thai food, and they created this function to facilitate email orders to Redmond Thai restaurants. This theory has not yet been confirmed -- but then again it hasn't been denied either."