Stupid things about Excel 2011 for Mac

Got my Office upgrade a few weeks ago, which made me happy because I was hoping it would obviate most of my need to run Windows XP in VirtualBox. While it has done that, Excel in particular also has a number of annoying and stupid problems. Here's my list.

1. No pivot charts.
2. Limited pivot-table sorting. The Win version of 2007 lets you do lots of fairly complex sorting on various items in the pivot table. Edited to add: OK, looks like you can use the sort button in the ribbon for sorting in other columns. Fine, but different from Windows and why include that sort option in the pop-up then?
3. Click on the pivot-table button to have Excel make a table for you and it puts it in a new sheet. Fine. But that sheet is inserted before the current one. Really.
4. Same auto-create also leaves the floating info window for pivot tables open every time.
5. Ugly, partially transparent, white on black floating windows in filtered and pivot tables.
6. Missing "clear" button to get rid of all the filtering on a table at once. Instead it's in the Data menu.
7. Incomprehensible menu customization process.
8. Window re-sizing when windows are put in background.
9. Window re-sizing upon copying a chart. The original size is restored, but still, what is going on?
10. Still doesn't use the standard clipboard process, so you get asked whether you want to save large clipboard upon quitting, and items cut don't disappear right away, and the copied range will be forgotten if you don't use it right away. (Actually I don't know what set of actions will wipe out the clipboard, but it seems like most of them.)
11. Calibri? Really? (OK, this is in Windows too.)
12. Modal dialog boxes in Find/Replace that close with a button that says "Close" instead of a red close button or a cancel button. 
13. No default key combo for Replace.
14. Ugly pastel built-in chart types. (Again, Windows too.) Can they not hire someone with some taste over there in Redmond?
15. The red button stoplight button does not always get the black dot at its center when you've changed the document. [Added 15 April 11]
16. Some files are changed just by opening them and Excel will ask if you want to save them when you try to close. [Added 15 April 11]

Reason #4306 why I am a Mac user

I run Windows XP in VirtualBox on my MacBook. Love it. Almost everything works great. I can save the state of my Windows machine. I can revert to an older saved state. I can run those rare, but enticing, Windows-only apps like ArcGIS, or the DAVID Laserscanner, or the CVA Access database (yuck). But the big reason is that I've needed the latest version of Excel for compatibility with all the nice stuff pivot tables can do on it. (Shout out to pivot-tabler extraordinaire CVW!)

So here's the thing: open a file in Excel, make some changes, and then try to close without having saved it. Excel will throw up a dialog box for you to save that file. Cancel the save and it will then ask you whether you want to save this file which you've made changes in.

Uh...isn't that backwards? Why don't you ask me first and save a step? You know, like my Mac has done for the past 27 years.

Yes, I know this is Excel and not XP, but it's still Microsoft, so same difference.