Please note javascript is required for full website functionality.

News

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

20 May 2017

Could it be Microsoft is starting to slow down? For this month's updates for Get & Transform (Excel 2016) / Power Query (Excel 2010 and 2013), there's only three new updates. Come on guys, are you really trying? This month, the updates focus on the following new...


AutoSave is Coming to Get YOU!! Action Required

19 May 2017

Microsoft has added a new feature to help users co-author files.  Whether you are for or against this feature is not my point here: it needs Excel's AutoSave switched on to work.  That's fine.  But it shouldn't be the default.  It is accepted...


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


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


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


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


Newsletter