Please note javascript is required for full website functionality.



October 2021 Updates for Power BI

18 October 2021

This month’s updates see the release of additional functionality and performance improvements for DirectQuery and optimisation for the SWITCH function, amongst other enhancements.

Happy Spreadsheet Day 2021

17 October 2021

Ah, to have been working 43 years ago...

Excel Virtually Global 2021 - Coming Soon!

30 September 2021

It's not far off now!! We are back for a SEVENTH time! Do you think a pandemic will stop us..? 50+ presenters from all over the globe speaking on all things Excel and Power BI. It's for charity!

Comments and Notes Upgraded in Excel for the Web

28 September 2021

There have been some recent updates to the threaded comments and notes experience in Excel.

September 2021 Updates for Power BI

22 September 2021

This month’s updates see new improvements for buttons, line charts and DAX functions, amongst other updates.

A Top Excel Blog?

26 August 2021

We are pleased to announce that according to Feedspot, SumProduct has been named one of the web’s Top 70 Excel blogs. That’s nice to know someone is reading our rambles!

August 2021 Updates for Power BI

15 August 2021

This month sees updates for Q&A, shapes and automatic aggregations for DirectQuery, amongst other inclusions.

Navigation Not Such a Pane

6 August 2021

Microsoft has made a “big thing” – quite rightly – about accessibility for all of their products, to ensure they are inclusive to everyone, including more than one billion people with various disabilities around the world.

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