Please note javascript is required for full website functionality.


Situation Vacant – August 2020

28 August 2020

conomic downturns, bushfires, storm damage, pandemics, furloughed staff, Jobkeeper, Jobseeker et al. I think we can all agree 2020 has been a rough ride for everyone.

Excel for the Web Workbook Link Support

19 August 2020

Microsoft has just announced that workbook link support is now rolling out for its online cousin.

Coming Soon: Continuing Financial Modelling

13 August 2020

The second book in our modelling series, Continuing Financial Modelling, is to be released next month, albeit only in Kindle form initially.

August 2020 Updates for Power BI Desktop

13 August 2020

The latest updates released include support for Perspectives in Personalize visuals, a rectangular select for data points, and more.

May and June 2020 Updates for Power BI Service and Mobile

25 July 2020

Better late than never! You may have noticed these updates emanate more sporadically than their Desktop counterparts – but they do actually come out from time to time.

July 2020 Updates for Power BI Desktop

16 July 2020

This month’s updates include several enhancements to Q&A, gradient legend support and an ability to further customise slicer header text.

MVP Renewal 2020

2 July 2020

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

Have You Got What it Text? Introducing ARRAYTOTEXT and VALUETOTEXT

30 June 2020

The concern is though, for some people, this may be a little too much and they may very well just want to convert what they have to a text list. This is where the first of two new – and unannounced – Excel functions comes to the rescue.

Windows Insider Channels

29 June 2020

I know we mainly look at Excel, Power BI and Office products, but for those of us on a Windows Operating System, it is important to stay on top of the way Microsoft releases new Windows builds to us all.

Gone Too Soon: Chris "Smitty" Smith

25 June 2020

It’s been a terrible week for the Excel community, with the passing of Microsoft Excel team member and former Excel MVP Chris “Smitty” Smith