Microsoft Excel is the preferred weapon choice of financial modelers. In fact, I can’t think of any financially oriented people who don’t live and breathe Excel. This is pretty obvious.
But not all Excel’s are created equally. Excel on a Mac is not a financial modeling tool. It’s a simple spreadsheet tool like Google Doc’s Spreadsheets or Mac Numbers. If you’re serious about building financial models, you have to use Excel for Windows. You can see some differences between the Mac and Windows version of Excel.
There are too many shortcomings in the Mac version for you to be efficient and productive – not enough keyboard shortcuts and while Mac Office 2011’s Excel brought back macros, I’ve heard of some issues with them.
I’ve played with different variations of Windows Excel on a Mac including Parallels, VMWare’s Fusion, and Bootcamp. While they all loaded and ran fine, I just never felt comfortable with the keyboard.
So for my setup, I keep a Window’s machine around mostly for Excel and a Mac for other stuff.