Please note javascript is required for full website functionality.
MVP

News

News

Not Just Mary Can Have a Little LAMBDA / Excel Hits 500

27 July 2021

It’s busy times in the land of Excel 365 – if you want to live on the cutting edge. Microsoft has just announced the release of no less than seven new LAMBDA-associated functions (including a landmark 500th one – someone please bake Excel a cake) for the Beta...


Restrict Usage of Excel 4.0 (XLM) Macros with New Macro Settings Control

27 July 2021

A new Excel Trust Center (sic) settings option to further restrict the usage of Excel 4.0 (XLM) macros has now been made Generally Available. To better protect Microsoft 365 users against malicious macro-based threats, Microsoft recently expanded the integration...


July 2021 Updates for Power BI

23 July 2021

This month’s updates see small multiples become Generally Available, the new Model View / sensitivity labels in Desktop are propagated, plus there is a new Preview for streaming dataflows.


MVP Renewal

2 July 2021

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 2021-22.


Lifetime Achievement Award

28 June 2021

Even if it does appear to mean blowing smoke up our own proverbials, we have some great news! Congratulations to SumProduct’s very own Liam Bastick who won the inaugural Lifetime Achievement Award at last week’s Financial Modelling Summit 2021, held in London.


New Features in Excel for the Web

28 June 2021

The General Availability of Office Scripts is only one of the new features and improvements to help you better analyse your data. There is more.


Office Scripts now Generally Available in Excel for the web

28 June 2021

Microsoft has recently announced that Office Scripts in Excel for the web is now Generally Available for all “eligible users”.


June 2021 Updates for Power BI

27 June 2021

This month’s updates include DirectQuery support for Dataflows, which has now become Generally Available.


Import Data from Local Files using Power Query in Excel for Mac

20 May 2021

We are pleased to hear that there is new update to Power Query (PQ) in Excel for Mac – the ability to import data from local files, coming on the back of being able to refresh data from, er, about this time, last year. Tempus fugit indeed!


May 2021 Updates for Power BI

13 May 2021

This month’s updates include a new Preview of visual ToolTips, an ability to quickly create reports from SharePoint lists and an update on sensitivity labels so that they are now inherited “downstream”.


Newsletter