If you want to learn all of Excel’s features (including the OLAP capability that Microsoft often describe as “modern data analysis”) you will have to learn using the Windows version of Excel 365.
This is because the OLAP features used by Excel leverage upon Microsoft’s server products that are incapable of running on the Mac OS. For example none of the new OLAP features (Power Pivot etc) are present on the Mac version. This means that it is impossible to produce a useful Excel 365 for Mac book (indeed different groups of users around the world may be using different versions at any one time).Įxcel 365 for Mac still remains very limited when compared to the Windows version. While Microsoft produce a scheduled update or Excel 365 for Windows they do not do this for the Mac version that is updated on a non-scheduled basis. We also produce a new book every six months to match each new version. In the case of Excel 365 for Windows, Microsoft produce a new semi-annual version every six months. You can see some of the differences in the Excel 2019 Windows vs the Mac version here: For this reason we produce separate Excel books for the Mac versions: Excel 2016 for Mac Excel 2019 for Mac. There are huge differences between the Mac and Windows versions of Excel 365.
