I have to strongly disagree with you on this. In Excel on Mac the simple lack of auto-complete for similar cells is a deal breaker for me, not to mention some VBA functions don't translate to VBA on a Mac.
Um, autocomplete is in there. You must not be using Excel 2011. I do this all the time. You start typing in a cell and you get a pop list of completeables that match, and as you keep typing it narrows down, et cetera. It works great. Like I said I do this to put food on the table Every-Single-Day. I depend on Office 2011 for Mac and Office 2010 for Windows working and playing well together. And they do. They are effectively identical.