This comparison of the differences between Microsoft Office on Mac, Windows, and iOS devices was put together by Kurt Schmucker who (disclaimer) works for Parallels — the company that makes slick virtual machine apps for running Windows and other operating systems on Mac — but he also happens to know a thing or two about the subject after his previous role as Senior Mac Evangelist at Microsoft and on the Office team. So what exactly is missing on Mac and iOS devices compared to Windows when it comes to the Office suite?
In the charts below, Schmucker breaks down feature-by-feature exactly what you get (and don’t get) in each of the different versions of the productivity suite including Office 2016 and 2013 for Windows, Office 2016 and 2011 for Mac, and Office for iPad.
The full charts (below) show suite-wide differences between the versions such as missing apps, lack of support for Visual Basic and ActiveX, right-to-left language support, accessibility features, AppleScript and much more. Other charts in the study show feature variations for Word, Excel, PowerPoint, and Outlook, with the majority of the features listed unavailable for iPad users and a mixed bag for the other versions.
And Schmucker points out two things regarding the iPad specifically. One positive is support for right-to-left languages, which he notes is something that Mac users have been asking for but have yet to receive, while a negative for the iPad is lack of multiple selection support in PowerPoint, something Schmucker notes is a pretty basic but crucial function for the app.
Click the charts below to view them in full size:
In the end, he concludes that a mix of the various Office suites is the best approach, but admits that his main, go-to version is MacOffice 2011 (apart from using the latest version of Outlook due to enhanced performance):
“I worked for the MacOffice team at Microsoft for several years, and at that time I also worked closely with colleagues on the WinOffice teams. Because of this background, I am often able to pick just the right Office app that will make a given task the easiest to do. One task might be particularly well suited to MacWord 2011 because Publishing Layout View— a feature only in that one Word version— will make this task easy. Another task might be suited to WinPPT because of the Animation Painter, which is not in any MacPPT version. Yet another task might be best suited to WInPPT 2013 because it needs an Office extension not available in other Office suites.”
And this is what Schmucker’s setup looks like with various versions of Office installed on Mac and using virtual machines:
If accessing Windows-only or version specific features on your Mac is the goal, Schmucker notes that with Parallels you can easily run different versions of Windows and Office on one Mac using Parallels Desktop for Mac and a subscription to Office 365 Home (which will give you five installs of the Office suites of your choice). That’s how he accomplishes the setup above using various virtual machines.