It is amazing what AI can do – and even more amazing what members of our team can do with it. Our very own Lennon & McCartney (all rolled into one), Ilgar Zarbaliyev, has “composed” the SumProduct Groove. If you need a laugh (with tongue firmly positioned in cheek), feel free to singalong a SumProduct. No doubt Ed Sheeran will be covering it on his next album, ∑∏!!

July sees several new features in Excel that enhance user productivity and collaboration across platforms.

As Power BI turns 10, the software continues to improve with changes coming thick and fast. There appears to be no sign of abatement. Features this month include updated connections to Microsoft 365, smarter Copilot features and the integration of reporting through PBIRS and SQL Server 2025.

Whilst you have been able to refresh a PivotTable upon opening a file for years in Excel, refreshing the PivotTable when the source data changes has been more problematic. Not yet announced in the Excel Updates, Microsoft Excel now provides you with the ability to update your PivotTable automatically whenever you make changes to the data source.

SumProduct is pleased to announce that two of our staff, Tim Heng and Ilgar Zarbaliyev, have been re-awarded Microsoft’s Most Valuable Professional (MVP) award for Excel and Data Platform respectively for 2025-26.

The updates for June introduce further features that enhance Copilot's capabilities in Excel and deliver an improved iOS experience for the Insiders program.

This month sees an important update to the Azure Maps visual in Power BI that gives you greater control over data residency and governance, whilst also simplifying the experience for administrators.

This month’s update highlights several new Preview features and an important action-required item for Power BI users.

This month introduces another raft of improvements, the majority of which revolve around Copilot.

As part of Microsoft’s ongoing efforts to enhance the performance and security of Power BI, the company has announced the deprecation of the 32-bit build of Power BI Desktop.