Office 2013 - Just installed it. First thing I noticed.
All caps tab titles. Not good, very ugly...and I don't really need MS Office to be yelling at me.
Here's the first trick for Office 2013:
Just go to the Customize Ribbon section of the Excel Options dialog box. Select a tab name and click Rename. Type your new name, using any mix of upper and lower case character. But… If the name is the same as the original tab name, it will revert to uppercase.
The trick: Just add a space character to the end of the name. Here's an example. The HOME tab has been renamed Home<space>.