Please note javascript is required for full website functionality.



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

Power BI for All?

19 November 2017

The recent general availability of Power BI Premium in June broadened the Power BI service’s reach, allowing organisations to distribute BI content broadly without requiring recipients to be licensed individually.  Accessibility has been extended further: now,...

Bulgaria Excel Days Not Confused

11 November 2017

This one has only just come onto our radar, so apologies for the short notice. The event, championed by local MVP Boriana Petrova, is he first of its kind in Bulgaria and is dedicated to various lecture sessions on the latest trends and practices in using...