Please note javascript is required for full website functionality.



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

Mac Excel Version 16 - Now Available for Insider Fast Participants

11 November 2017

No more version 15.xx for Mac users - Build 16.6 (171001) is here for the guinea pig / trailblazer brigade.

Power BI Report Server November 2017 Update

2 November 2017

Today sees the release of a new version of Power BI Report Server, Microsoft's on-premises solution for reporting.

Ask Me Anything October 2018

18 October 2017

It's that time of the year again. Microsoft are having another of their "Ask Me Anything" (AMA) sessions...

Excel Office 365 Performance Improvements

15 October 2017

You remember when you installed Office and the installation process asked you whether you wanted to submit telemetry back to Redmond? Well, some of you said “yes” and as a consequence, Microsoft has been identifying some specific examples of slow, high CPU or out...