Microsoft announced a new function, TRIMRANGE, and an accompanying set of new reference operators today...

This month’s updates see Excel reach a new watermark – quite literally!

It’s that time of the month again. This month’s updates see you now able to ask Copilot questions against your semantic model. But there is always more. For example, updated Save and ‘Upload to OneDrive Flow’ in Power BI, plus the Narrative visual with Copilot is now available in SaaS embed.

The term “regex” is an abbreviation of “regular expressions” and is a language used for pattern-matching text content. Regular expressions are starting to infiltrate Excel. In the latest release, currently in Preview, you may take further advantage of regex within the existing XLOOKUP and XMATCH functions...

Congratulations to SumProduct’s very own Kathryn Newitt who has just contributed / co-contributed her 400th Power Query / Get & Transform article.

This month sees you able to use Copilot in Excel to unlock insights from data, work on data ranges resembling tables and prompt for step-by-step instructions including formula examples. But that’s not all...

One of the most common questions we are ever asked is how to translate a number into words...

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…).

Another month, another load of updates for Power BI. The latest round allows you to customise your reference layers in Azure Maps visual, DAX query view is now available in live connect and there is also an update to the Power BI enhanced report format (PBIR)...

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.