Please note javascript is required for full website functionality.



New Updates for Get & Transform in Excel 2016 / Power Query in Excel 2010 and 2013

4 May 2016

The Power Query train rolls on and on: it seems Microsoft has been busy.  No less than 13 new features have been released in two sequential updates to the Get & Transform capabilities in Excel 2016 and their counterpart Power Query add-ins for Excel 2010 and Excel...

Weather You Want To Or Not...

30 April 2016

Hurricane Cortana ravaged the weather report on KCCI News, as the media meteorologist attempted to forecast the conditions around Des Moines in Iowa (USA).  Maybe if she had upgraded and did not like the weather, all could have been reset with a simple CTRL + ALT +...

Microsoft Data Insights Summit - Free Online Sessions

18 March 2016

Microsoft's Data Insight Summit, the inaugural Power BI and Excel user conference, takes place on Tue 22 March to Wed 23 March in Redmond (US West Coast time).  We'll actually be there - but if you don't already have a ticket, you can still attend.

Microsoft has...

Excel 2016 / Office 365: New Functions and Features

1 March 2016

If you are an Office 365 subscriber and have access to Excel 2016, you will notice some brand new features and functions coming your way very soon - if not already - in Excel 2016.

Microsoft has added six new functions, IFS, SWITCH, CONCAT, TEXTJOIN, MAXIFS and MI...

Excel Summit South - Limited Time Discount Offer

7 February 2016

There's only a month to go until the Excel Summit South heads for Auckland, Sydney and Melbourne in a series of two-day sessions.

Sponsored by PwC and the Chartered Accountants of Australia and New Zealand, this is a unique opportunity to learn from some of the...

MVP 2016

2 January 2016

SumProduct is pleased to announce that our MD, Liam Bastick, has been re-awarded Microsoft’s Most Valuable Professional (MVP) award for Excel for 2016.  This award recognises exceptional technical community leaders from around the world who voluntarily share their...

Summit to Say?

21 December 2015

Microsoft has announced its inaugural Data Insights Summit, a two-day event for business analysts to connect with each other and with industry experts, in Bellevue WA on March 22 and 23 next year.  It is an interactive opportunity to discover best practices, new...

CIMA Christmas Quiz

9 December 2015

SumProduct, in conjunction with the Chartered Institute of Management Accountants (CIMA), is pleased to announce the annual Christmas quiz.  It’s open to everyone, not just accountants.  Check out the Excel challenge – with prizes – in the December issue of Insight...

Excel Summit South - Registration Now Live

17 November 2015

For the first time ever the world's leading authorities on Excel and spreadsheet modelling are coming together to share their knowledge.  There are over 20 topics covered over three two-day sessions in Auckland, Sydney and Melbourne.

Sponsored by PwC and the...

Power Pivot in Excel 2013 Updated

16 November 2015

The recently released November Power Pivot for Excel 2013 updates make changes to how Power Query interacts with Power Pivot as well as providing support for Key Performance Indicators (KPI).

For data in Power Pivot that has been added through Power Query, the...