This month’s updates include several enhancements to Q&A, gradient legend support and an ability to further customise slicer header text.

SumProduct is pleased to announce that two of our Directors, Liam Bastick and Tim Heng, have been re-awarded Microsoft’s Most Valuable Professional (MVP) award for Excel for 2020-21.

The concern is though, for some people, this may be a little too much and they may very well just want to convert what they have to a text list. This is where the first of two new – and unannounced – Excel functions comes to the rescue.

I know we mainly look at Excel, Power BI and Office products, but for those of us on a Windows Operating System, it is important to stay on top of the way Microsoft releases new Windows builds to us all.

It’s been a terrible week for the Excel community, with the passing of Microsoft Excel team member and former Excel MVP Chris “Smitty” Smith

If you are presently subscribing to the Beta channel of Microsoft 365 (for either Windows or MacOS), then you have a 50% chance of finding that with the latest update you now have limited additional language support for the Stocks and Geography Data Types.

Microsoft announces a new Excel function for Microsoft 365, Excel for Microsoft 365 for Mac and Excel for the web.

This update sees several features become Generally Available, including automatic page refresh, the hierarchy slicer, the modern Ribbon and AI insights.

Microsoft’s Most Valuable Professionals, or MVPs, are technology experts who passionately share their knowledge with the community. They are always on the “bleeding edge” and have an unstoppable urge to get their hands on new, exciting technologies.

Now I know not everyone uses Office 365 / Microsoft 365 / whatever it’s going to be called next week. And I know even fewer use the Insider / Beta channel. But just in case you do, there seems to be a problem for some of us (not everyone) with installing the latest Windows and Microsoft 365 updates.