Please note javascript is required for full website functionality.



Personalising PivotTables

16 May 2017

The latest Office 365 update provides a ‘pivotal’ new Excel feature.  Now, you can finally personalise the default layout for your PivotTables.  It’s been a popular request over at Excel UserVoice for some time and now it’s finally happened. 

There are two ways...

CPA Unlock Excel Wraps Up

12 May 2017

Today saw the final day of the two week tour Down Under for seven Excel MVPs, two Microsoft staff, an academic and several CPA staff, as the Unlock Excel event drew to a close in Auckland.

Over the eight days, in excess of 500 Excel users listened to various...

Are You Ready for Office 365 Pro Plus?

12 May 2017

Microsoft has just announced new tools to support the application compatibility readiness for Office 365 Pro Plus.  Over the next year, the intention is to roll out tools to catalogue all of an organisation’s add-ins, in order to assess the status of VBA...

Key Changes Happening to Power BI Free from June 1

4 May 2017

Microsoft is making some significant changes to this dashboard reporting tool from the beginning of June.  On the positive side, this update will provide you with enhanced data capacity and refresh rates, as well as unlimited access to all data sources.  However,...

Unlock Excel Flash Sale

4 May 2017

If you haven't already booked your place on this year's Excel MVP tour of Australia and New Zealand, there are still places left - and there are some last minute bargains to be had - at some locations.  If you are interested, head for the official website here and...

New Excel Add-In Script Lab Launched

19 April 2017

Microsoft said they would do it and now they have kept their promise with the release of Script Lab, an add-in for Excel (and other applications) described as a "Microsoft Garage" project (isn't that a type of '80's music?).

Script Lab is a tool for anyone who...

April 2017 Updates for Get & Transform / Power Query Add-In

18 April 2017

Get & Transform (Excel 2016) / the Power Query add-in (Excel 2010 and 2013) have had their monthly updates put through.  April’s improvements cover five new data transformation and connectivity features.

These updates include the following new or improved data...

Unlock Excel Back InTheBlack

13 April 2017

Our upcoming Unlock Excel event has made the news again.  Fellow presenters and Excel MVPs Inge Hawighorst and Ken Puls have passed on their thoughts with "deep diving" into Excel's functionalities and features, notably some of the visualisation tools and Power...

Power BI Desktop - April Updates Out Now

7 April 2017

April sees a raft of new features - some in Preview - for Power BI for Desktop. Updates include enhancements to data connectivity, query editing, matrix reporting and, er, Spanish.

If you haven't already tried out Power BI Desktop, it can be downloaded from here -...

Phoney Excuse

5 April 2017

Apologies in advance, but on Friday 7 April, between 21:30 and 22:15 Australian Eastern Standard Time (AEST), upgrades to our IT systems will mean we will be without our landline phones for a maximum of 45 minutes.