Please note javascript is required for full website functionality.



Office Scripts Preview Rolling Out Now

8 January 2020

A public Preview of Office Scripts in Excel on the web has recently been announced by Microsoft. Office Scripts is a feature that enables you to record scripts and automate tasks. It is rolling out gradually, but it’s well worth a look as it will allow you to...

Excel Insights Book Out April 2020

1 January 2020

There’s another Excel book coming out. Written by 24 MVPs (there’s only 66 of us), including SumProduct’s very own Tim Heng and Liam Bastick, this book covers a myriad of the MVPs’ favourite topics.

Workbook Statistics Comes to Insider Fast

1 January 2020

Microsoft has gone “in with the new” in Excel – Workbook Statistics comes to Office 365 Insider Fast.

Happy New Year 2020!

1 January 2020

From our base at SumProduct HQ Down Under, we'd like to wish all our readers, clients and training attendees a Happy and Prosperous New Year!

December 2019 Updates for Power BI Desktop

17 December 2019

December sees the usual raft of Power BI Desktop updates, including in Preview, the new 'Customize theme' dialog.

October and November 2019 Updates for Power BI Service and Mobile

6 December 2019

It has taken a while to be announced, but there have been quite a few updates for Power BI Service and Mobile recently...

Dynamic Arrays Gradually Rolling Out on Monthly Channel

28 November 2019

Microsoft has begun the "gradual rollout" of dynamic arrays on the monthly channel of Office 365.

November 2019 Updates for Power BI Desktop

15 November 2019

There were some major updates this time, including a new, modern Ribbon that aligns Power BI Desktop and a new visualisation tool: the decomposition tree.

Dynamic Arrays Becoming Generally Available

5 November 2019

It's finally starting! We said we thought there might be an announcement at Microsoft Ignite - and we were right! The long awaited roll-out of dynamic arrays starts now.

XLOOKUP Presents Moving Arguments

5 November 2019

It was only in late August 2019 that Microsoft added XLOOKUP to its lookup fold, and already it has had a makeover. Back in February, RANDARRAY became the first function ever to have a syntax change after release – and now XLOOKUP joins this elite group of two.