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 2024-25. Our third MVP, Steve Kraynak, did not need to bite his fingernails for this round as he was only recently awarded the honour (we think he just chewed on his toenails instead…).

SumProduct are running two free webinars on Wed 17 July, one at 12 noon AEST and one at 12 noon BST. Join us for an insightful session on ChatGPT.

There are two new translation functions out in Preview now, TRANSLATE and DETECTLANGUAGE. Be careful using these: their signature and results may change substantially before being broadly released, based upon feedback from those fortunate enough to be able to access them. Therefore, we strongly recommend you do not rely on these functions in important workbooks until they are Generally Available.

Checkboxes are finally released to production in Excel. These are useful for checklists (obviously!), managing tasks and visualising your data quickly. With just a few clicks, you can insert Checkboxes into any cell, making your spreadsheets more dynamic and user-friendly.

This month sees you able to prompt Copilot in Excel to work with columns and formulae in Excel for web, Windows and Mac...

Amongst other announcements, you can now download large semantic models, there is a Power BI enhanced report format (PBIR) and there is also now Subfolder support in Power BI Report Builder...

It’s a little quieter on the Excel front this month, but I suppose it’s more about quality than quantity. This month sees two key announcements...

Today sees the release of three [3] new Excel functions to the Beta versions of Excel...

This month’s updates see new On-object Interaction updates, DAX query view now Generally Available, and you can find out how to view reports in OneDrive and SharePoint with live connected semantic models...

Back in November last year, Microsoft announced several new functions, including PIVOTBY, and eta lambdas such as PERCENTOF. On the quiet, they have added a new argument which makes PIVOTBY just that little bit more powerful...