I currently in the market for a new notebook. I would really like a mac, and would buy one in a second if it were not for one thing. I do use it a lot for my job, and would often need to do some work from home. I don't think it is really worth buying a windows machine all because of one piece of software.
I work in insurance so tend to use a lot of macros/VBA, pivots tables, statistical formulas ect. I know excel 2011 on mac is not too bad but how much am I really giving up? Would it be fully compatible? And will I be able to change the shortcuts so they are the same as windows (if I use a windows keyboard). I will be working on a windows machine at work so it needs to be full compatible. Would I be better to just use bootcamp/VmWare when using excel? I much prefer OSX compared to windows as I am used to it for everything else.
Here are our picks for the best laptops in every category, including for the best budget laptop and best gaming laptop. The best MacBook Riley Young/Digital Trends. Why should you buy this.
Any thoughts from other heavy spreadsheet users? I agree with Joel, while Microsoft have done an excellent job with cross compatibility in Microsoft Excel 2011 for Mac - with Excel for Windows 2010, unfortunately the calculation engine in the mac version leaves a lot to be desired.
Complex finance models that work fine in the Windows Version of Excel can be seen recalculating in the Mac version. Running Excel for Windows in a VM (Virtual Machine) like may be the best approach. Parallels has a useful Coherence Mode, which hides the Windows desktop while displaying Windows applications. Windows still runs in the background, but is hidden from view. Windows applications appear in the Mac Dock, letting you switch between them without using the Windows interface. I'm a heavy Excel (and Access) user and I've found compatibility with Excel for Mac to be fine, almost transparent.
However, as noted by an earlier poster, there is a performance difference. Excel for Mac is much slower and missing a few of the key keyboard shortcuts I use every day -like F2 to edit a cell, ALT + to total a column of numbers, etc. When I really need to crank, I honestly use the actual windows version via Parallels as I also have this loaded on my Mac. I like the menu bar on the Mac version (it also has the newer 'ribbon'), but for productivity purposes I need the windows version of Excel.
![For For](https://cdn2.macworld.co.uk/cmsdata/slideshow/3642376/best_mac_monitor_2018_thumb1200_4-3.png)
Also, macros and VBA are hosted by the windows version for automation techniques. Click to expand.I work in banking/private equity and am a heavy user of windows excel despite being a mac user since 2001. Office for Mac never satisfied my needs since I would need to relearn all of my shortcuts and for a while macros didn't work. Fast forward to today and I have the maxed out 2012 MBA and run excel via VMWare Fusion 5 (in its own space). Performance is as good as my official work laptop which pretty much never get used. There will be a few small tweaks you need to make (e.g.
Disabling ctrl-arrows for changing spaces in mission control in order to move around in cells more effectively, or remapping page-up/page down commands to make navigating worksheets more manageable). Overall it is a great setup and I am sure you will be find running it in either VMWare or Parallels. I've avoided using bootcamp for the simple reason that I don't need the highest levels of performance and prefer using windows in a VM in its own space so that I can do my browsing, etc on the mac side and MS Office work on the PC side. I am in engineering and a heavy Excel user, light/moderate with VBA.
I find Excel for Mac to slow me down considerably versus the Windows equivalent. This is not from a features perspective, but rather a work flow perspective.
Mac Excel does not have the auto-fill option like in Windows (well it does but it gives you a dropdown of item which requires mousing or down-arrowing to your choice), furthermore loading of spreadsheets is a little slower and in some cases the VBA code does not translate. I do not recommend doing heavy Excel workflow on Mac Excel. Some people tend to disagree with me as I have been vocal about this over the years here on MR Forums but I still have not budged on my opinion. Mac Excel is definitely worse than Win Excel. I work in banking/private equity and am a heavy user of windows excel despite being a mac user since 2001. Office for Mac never satisfied my needs since I would need to relearn all of my shortcuts and for a while macros didn't work.
Fast forward to today and I have the maxed out 2012 MBA and run excel via VMWare Fusion 5 (in its own space). Performance is as good as my official work laptop which pretty much never get used. There will be a few small tweaks you need to make (e.g. Disabling ctrl-arrows for changing spaces in mission control in order to move around in cells more effectively, or remapping page-up/page down commands to make navigating worksheets more manageable). Overall it is a great setup and I am sure you will be find running it in either VMWare or Parallels. I've avoided using bootcamp for the simple reason that I don't need the highest levels of performance and prefer using windows in a VM in its own space so that I can do my browsing, etc on the mac side and MS Office work on the PC side.
Click to expand.Surfearth, I found your post really helpful. Can you please elaborate on this part? Disabling ctrl-arrows for changing spaces in mission control in order to move around in cells more effectively, or remapping page-up/page down commands to make navigating worksheets more manageable).' Where do you disable ctrl-arrows and how do you remap page-up / page-down commands? Home/End/PgUp/PgDn are pretty much the only commands holding me off since I am a heavy Excel user as well.
Appreciate your help. I am in engineering and a heavy Excel user, light/moderate with VBA. I find Excel for Mac to slow me down considerably versus the Windows equivalent. This is not from a features perspective, but rather a work flow perspective. Mac Excel does not have the auto-fill option like in Windows (well it does but it gives you a dropdown of item which requires mousing or down-arrowing to your choice), furthermore loading of spreadsheets is a little slower and in some cases the VBA code does not translate.
I do not recommend doing heavy Excel workflow on Mac Excel. Some people tend to disagree with me as I have been vocal about this over the years here on MR Forums but I still have not budged on my opinion. Mac Excel is definitely worse than Win Excel. Click to expand.I second this.
I found this thread as I was searching on experiences with virtualizing the windows version of Excel in Parallels. My experiences do not seem to match up with the majority of those here, and I'm not sure why. I use Excel very heavily (lots of formulas, lots of vlookups, and lots of VBA), and I find the Mac 2011 version of excel to be utterly unusable for any serious excel work. The current file I'm working on is pretty much useless on my desktop (hardware isn't an issue here - running with 16GB of RAM, i5 4670k, and SSD). Inserting any columns practically crashes the program, and scrolling through VBA modules is nigh impossible. It is not smooth in the least. It freezes up and I can't tell where I'm at since there is such a lag.
Yesterday, I was trying to grab some code to share with someone. Rather than booting up in windows to grab the code, I just opened up the file in OS X. Not only did it take much longer to open, but it probably took 5 minutes to successfully navigate to the proper module and procedure and copy the right code into text edit.
The scrolling was beyond laggy. I when I would move the mouse, it would take 5+ seconds to register on the screen. Thus, while I certainly hope the experience for others is not similar, Excel for Mac 2011 is unusable as a day-to-day power user. I thought that virtualizing might be an option, but I'm not even satisfied with that (using it on a late 2013 rMBP). That little bit of lag bothers me too much.
Thus - the only solution that has worked for me has been dual booting into Windows for doing serious excel work. For me, this is not a problem or a serious inconvenience. When I'm trying to get work done, I don't need to be switching back and forth frequently.
Like most people here I've resorted to using Excel in a Windows VM because the performance of Excel 2011 is dreadful. Get a few 1000 rows in there and try scrolling through them, that will kill Excel 2011 every time.
There's got to be something considerably wrong for Excel to run faster in a VM than it does as a native OX X app. And that's without doing any heavy formulas. I've looked at the alternatives, Libre Office, Numbers and they just don't cut it. The only hope of not having to run Excel inside a VM is that the next release will be better now Microsoft are concentrating on applications and services as part of their corporate strategy.