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

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

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

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

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

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

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

We’ve talked about Power Map for Excel before, but now seemed like an opportune time to provide a timely reminder (see the video demonstration below – like many TV programmes, it’s a repeat!). Power Map is a three-dimensional data visualisation tool that lets you look at information in new ways by plotting data on Bing renders of the globe – all embedded in Excel. Not only can you plot geographic and temporal data on a 3-D globe, you can also show it over time and create visual tours you can share with other people. We’ve actually used to embed informative videos in a PowerPoint display for example. You can use Power Map to:

Yes, it’s that time of year again when the Excel MVP army descends upon Redmond to talk shop with the Excel Product Team. Whilst many of the topics will have to remain confidential for the time being, we do get the opportunity to pass on ideas and comments to those...

September 30 marks Excel’s 30th birthday. Did you know Version 1.0 debuted for the Mac all those years ago? There’s probably a few financial analysts who weren’t even born back then (sigh…). Whilst Excel was neither the first spreadsheet program nor the first...