Please note javascript is required for full website functionality.



#N/A No Longer a Waste of Space

13 October 2017

Every now and then an improvement comes through in Excel that is truly newsworthy. Most features and functions we put in the Thought section in due course – but this one is different. Loads of users want this. I am talking about gaps in charts.

Mac Excel Gets PivotCharts

7 October 2017

At last!! It took just 30 years, but PivotCharts come to MacExcel (well, sort of). For spreadsheeters using the latest Excel for Mac Insiders Fast release, there is now PivotChart support.

Excel (and Office) 2019

29 September 2017

Earlier this week at Microsoft Ignite in Orlando (Florida), the software giant announced Office 2019 — the next "perpetual update" for Office.  This release, scheduled for the second half of 2018, will include perpetual versions of the Office apps (including Word,...

Out and About in October 2017

26 September 2017

It’s been a while since we’ve travelled, but we are off and away again – pretty much for the rest of 2017!  October will see us all over Australia as well as in London en masse and Singapore.  Drop us a line at if you’d like to meet up.  We’d...

September 2017 Update for Power BI Desktop

12 September 2017

This is the one the world has been waiting for!  You'll get no overstatements here... 

Power BI Desktop finally releases two features that were demoed back at the Data Insights Summit that really got everyone talking: drillthrough and report insights.  That’s not...

Load Data from External Data Sources to the Common Data Service using Power Query

24 August 2017

And the award for the catchiest news title of the year... does not go to the above.  Anyway, some of you will be interested to learn that Microsoft has announced "initial Preview availability" of a new feature that allows you to create custom entities based on data...

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

24 August 2017

We are suspecting these are beginning to taper off now, as the updates are becoming progressively more difficult to find and they are not being summarised in such detail (if the laws of grammar allow you to do such a thing!). 

Anyway, Microsoft has just released...

August 2017 Update for Power BI Desktop

14 August 2017

The Power BI Desktop juggernaut continued to speed forward at a rate of knots.  Probably the key one this month (certainly many users have been excited about this since it was revealed at the Data Insights Summit) is the ability to interact with controls on a...

Mac Can Run and Now IDE

4 August 2017

Microsoft has announced that the Visual Basic Development Editor is set to return to Office 2016 for Mac.  This is a dramatic U-turn for the software giant as the current Visual Basic development environment is a little, er, “limited” to say the least.

Within the...

Get and Transform - Transformed July 2017

24 July 2017

Microsoft has just announced the latest major update to data import and shaping functionality in Excel. Now, Excel’s data import functionality has been "enhanced" (i.e. rearranged) on the Ribbon so that end users may find it easier to look for the right tools. Just...