IDG Answers is a community of experts who are passionate about technology. Ask a question or answer one below.
For regular spreadsheets, any of the others are good. But, as you have pointed out, Excel just works and it can do the 5% that none of the others can't, which is important when you are a really sophisticated user with complex systems demands. 2011 is also on my list; I am preparing a budget for a small start-up company and everything Apple but with Office 2001 a likely addition.
Something to consider as this has been absent from Apple's native apps. Have a look at https://itunes.apple.com/us/app/myphonedesktop-phone-on-your/id352226779... and see how you can have Nokia Suite-like functionality on your Mac. It may help complete the system for especially professional users.
Why migrate from Microsoft and then want to use their application software? Mac OS is by far superior to MS Windows, in so many respects. (I have just bought a Dell laptop with Windows 8 64-bit on it. Windows 8, even with Classic Shell, hampered productivity and I have formatted the drive and installed Zorin OS instead.)
On both Linux and Windows, I have been using LibreOffice and have been quite content with it. It also works on Mac, but here is a better option: http://www.neooffice.org/
Also have a look at Kingsoft Office, which I am also using.
The two main things are that it will be slower on a Mac, and all those keyboard shortcuts that you committed to memory won’t be the same on a Mac. The basic core will be the same, but I’d wager you will not find a single person (fanboys excepted) who has actually used both that doesn’t view Excel on the Mac as the inferior version.