Well, today, Microsoft has announced the first step towards full support for Power Query in Excel for Mac. But it’s been missing from Mac Excel.īack in June, there was a little teaser of what was to come with the ability to undertake limited Power Query query refreshes for CSV, JSON, Text, XLSX and XML files only. We have a Power Query blog each Wednesday that keeps you apprised of all the things you can do with the Extract, Transform and Load (ETL) tool.
You can also run Excel 365 for Windows on Mac hardware but to do this you would have to purchase and load Windows 10 onto your Mac using the Boot Camp utility.For several years now, the Windows platform has introduced a powerful set of Get & Transform Data / Power Query tools, starting way back with Excel 2010. If you wish need to learn Excel on Mac hardware and OS the only Excel version that will perfectly match any tutorial resource will be Excel 2019 and not Excel 365. 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.
0 kommentar(er)
