Microsoft has announced Office for Mac Insider Slow Version 16.42 (Build 20100402.
With version 16.42 (Build 20100402), Microsoft has introduced a couple of new features to Microsoft Excel on Mac.
Excel, Word, and PowerPoint
Premium creative content
You can now easily add high quality, curated images, stickers, and icons to their personal or professional files. Jazz up your content in Excel, Word, and PowerPoint by picking from thousands of royalty-free images and icons that best suit your mood and the information you want to share.
Excel
Use your Excel data to generate diagrams automatically
The Data Visualizer add-in will enable all Excel users on Mac to generate high quality Visio Diagrams directly from Data within Excel. Convert your Excel data into high quality flowcharts, swim line diagrams, and org charts. These diagrams can be viewed in Visio, saved as image, print, etc. They can also be opened in Visio for richer editing capabilities.
Speedy SUMIFS and SUMIF
Experience faster performing SUMIFS, COUNTIFS, AVERAGEIS, MAXIFS, MINIFS and their singular counterparts. For example, calculating 1,200 SUMIFS, AVERAGEIFS, and COUNTIFS formulas aggregating data from 1 million cells on a 4 core 2 GHz CPU that took 20 seconds to calculate using Excel 2010, now takes 8 seconds only, on Excel M365 2006.
Refresh from SharePoint and OData on Mac
You can now refresh queries on Mac that pull data from files on SharePoint, SharePoint folder, SharePoint list, and OData.Â
Source: Microsoft
 released on October 5, 2020.){kind=link}