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.

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 sees the usual raft of Power BI Desktop updates, including in Preview, the new 'Customize theme' dialog.

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

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

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.

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.

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.

The latest update provides improvements in several areas. In the data preparation area, Microsoft has introduced query diagnostics, which allow you to see which queries are being run behind the scenes. On the reporting side, real-time reporting has been improved,...

Thanks for being patient. SumProduct is proud to announce, in conjunction with Mr. Excel, An Introduction to Financial Modelling is now available directly in the United States.