>> Even MS Office has limitations on Mac, especially Excel, I have to use some very large spreadsheets, often over 500,000 rows and the Mac really struggles with these.
I think MS Office on Mac uses only single core of the CPU where as in Windows it can use all cores.