Please note javascript is required for full website functionality.
MVP

News

News

Faster PivotTables in Excel 2016

16 July 2016

PivotTables are now faster for those working in Excel 2016 with connections to Online Analytical Processing (OLAP) servers, either directly to an OLAP server or through a collection of data tables with relationships - known as a Data Model - in Excel.  The recent...


Microsoft Wins Data Privacy Appeal

15 July 2016

A court has ruled on appeal that the US government cannot force Microsoft to give investigative authorities access to the firm's servers located in other countries.


Excel 2016 July Updates

11 July 2016

Last week saw some updates / additions to Excel 2016, chiefly for Office 365 (yes, Microsoft continues to try and sway you to buy a subscription). The key updates this month include:

  • Shape recognition: Automatically transform your drawings into shapes

  • New...

Room Without a Power View

24 June 2016

For those using Excel 2016, you may have noticed that the Power View button has been removed from the Insert Ribbon.  Power View is still supported, but users have to work a bit harder to restore the button to their Ribbon.  In the next couple of months, an update...


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

22 June 2016

It's been a month!  It's about time Microsoft issued more updates for Get & Transform (Excel 2016) / Power Query (Excel 2010 and Excel 2013) and they have duly obliged with four new / improved features.

These updates are available in Excel 2016 if you have an Offi...


SumProduct Blog Launch

2 June 2016

Just a mere nine months after the launch of our new-look website, we’ve finally got our act together and set up a Blog section (to be fair, we have been busy!).  The blogs will be informal and cover items such as upcoming training, quick Excel tips, office moves...


Microsoft Survey Available

28 May 2016

If you are working on, or interested in, R and other Advanced Analytics (AA) tools in Power BI, then Microsoft wants to hear from you.  Desperately seeking Susan, partners and customers of these tools, the giant software company has devised a survey where you can...


Bringing Windows 10 to a Close

25 May 2016

If you are feeling (red) cross with Windows 10 seemingly installing without your say-so, you may have reason to feel aggrieved.  Microsoft has come in for criticism from various IT fora this week for changing the pop-up box encouraging Windows users to upgrade to...


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

25 May 2016

And there's more from Microsoft...  Late May sees the announcement of 10 new data transformation and connectivity features for Get & Transform (Excel 2016) / Power Query (Excel 2010 and Excel 2013).

These updates are available in Excel 2016 if you have an Office...


More Memory for 32-bit Click-To-Run Excel 2016

10 May 2016

Now this is good news.  The 32-bit version of Microsoft Excel 2016 can take advantage of the Large Address Aware (LAA) functionality after you have installed the May 3, 2016, update for Office 365 for Windows, build 16.0.6868.2060 for Office 365 Current Channel...


Newsletter