#Excel 365 for mac for mac

Right-click on the link and choose ‘Save link as …’ or ‘Save Target As. Downloadĭownload the COVID-19 per country/per person workbook here.

#Excel 365 for mac for mac

Three key features are only available together in the Windows release of Excel 365 Geography data type, Get & Transform/Power Query and Xlookup()Įxcel 365 for Mac version has a fixed data table that does not update automatically.Įxcel 365 for Windows users should use this version of the workbook that has an automatically updating data connection. The main workbook download only works with Excel 365 for Mac. Make sure the name in the Country column is the same on both tabs ‘COVID-19 Cases’ and ‘Data’.Īll the columns are sortable from the pull-down buttons on each heading. Many of those stats should be treated with care but the Population per country should be OK.Īdd more countries to the bottom of the table and the map will update automatically.

Geography data type pulls in statistics about locations around the world. That’s not ideal, we know that, but decided it was better to provide a Excel for Mac version with the best that Microsoft can currently provide. In the meantime we’ve made a workbook with a fixed data table of COVID-19 statistics as of today. We’ve not been able to find an online and reputable COVID-19 data source that’s also compatible with Excel for Mac. Excel for Mac has a very limited range of data connections compared to Excel/Windows. Excel for Mac data connectionsĮxcel for Mac lacks an important feature which means our Excel for Windows workbook doesn’t behave on Macs. Keep track of COVID-19 statistics using this Excel spreadsheet that shows the latest cases and deaths for countries you choose and populations also added for you.Įxcel 365 for Windows has a separate download available here.

We’ve made a new version of our COVID-19 statistics workbook that’s compatible with Excel 365 for Mac. Thanks for joining us! You'll get a welcome message in a few moments.