Please note javascript is required for full website functionality.



Year in Review 2017 Power BI Competition

4 January 2018

The Microsoft Data Journalism Program and Power BI teams have just announced that they are accepting submissions for the Power BI “2017 Year in Review” Data Story Contest.

Microsoft Tutorials for Excel 2016

3 January 2018

Microsoft has added two Excel tutorials to Excel 2016 for those new to Excel.

Upcoming Insights in Excel

27 December 2017

Now here is some truly exciting news for day-to-day Excel users: Insights is a new service (in Preview) coming soon to automatically highlights patterns detected in your data.

December 2017 Update for Power BI Desktop

27 December 2017

It will be a happy new year for many analysts - Q&A comes to Power BI Desktop, albeit in Preview.

Windows 10 Insider Program: Security Updates Ending for Early Editions

20 December 2017

Do be aware that if you have subscribed to the Windows Insider Program, you may be at risk if you haven’t updated your PC in a while. Support for early versions of Windows 10 has now ended.

December 2017 Update for Power BI Service

18 December 2017

Microsoft has taken a while to announce the updates, but they have been busy behind the scenes with more updates for the Power BI Service.

Custom Functions in Excel using Developer Preview and JavaScript

18 December 2017

Excel 2016 now supports custom functions in JavaScript, albeit in Developer Preview.

And Then There Were Two...

2 December 2017

SumProduct is pleased to announce that our Sydney director, Tim Heng, has been presented with Microsoft’s Most Valuable Professional (MVP) award for Excel for 2018-19 (he’s always been a little ahead of himself!).  This award recognises exceptional technical...

Goodbye CIMA, Hello CGMA

19 November 2017

After 102 monthly articles spanning nine years, SumProduct’s Spreadsheet Skills articles for CIMA Insight (the magazine for Chartered Institute of Management Accountants, but freely available to all) has ceased.  This is not due to the series being retired. ...

Power BI Desktop November 2017 Update

19 November 2017

November’s update saw conditional formatting getting a major update, with the ability to control the color based on rules.  Further, if you have a slow data source, there are now report options that help restrict the number of queries that are sent to the source....