Please note javascript is required for full website functionality.


Accessing dBASE

24 September 2016

Now we haven’t lost track of the fact that this newsletter is really about Excel, its ancillary products (e.g. the Power tools) and Windows impacts thereon. Having said that, we know many of you also use Excel’s sister product, Microsoft Access, and we thought we had...

Excel World Champ

20 September 2016

We talk about ModelOff every now and then but it seems Microsoft has decided to launch its own rival online Excel competition to help connect with Excel fans and drive awareness of features in modern Excel and Power BI.Let us introduce you to the Excel World Champ,...

August Update for Get & Transform / Power Query

3 September 2016

OK, so supposedly out in late August but only across our desk now, we thought we ought to bring you up to speed on the latest features to the ever-improving Power Query (Excel 2010 and Excel 2013) / Get & Transform (Excel 2016).

August Update for Power BI for Excel

26 August 2016

Microsoft has continued its regular updates of Power BI Publisher for Microsoft Excel with its late August update.

Windows 10 Anniversary Update

16 August 2016

We mentioned recently that it was Windows 10’s first birthday. Well… it bought itself a present and came up with an “anniversary update”.

Give the New Excel API a REST

13 August 2016

Early August has seen the Microsoft Excel team announce the general availability of the Microsoft Excel REST API for Office 365. You will be able to take a REST from now and never work again. Er no, that's apparently not how it works.This new Microsoft REST API for...

ModelOff 2016

2 August 2016

ModelOff has just announced the dates for the 2016 ModelOff "World Championship", with Round 1 kicking off on Saturday 22 October.We still think it's slightly aimed at the aggressive end of financial modelling (effectively, have you tried coding with boxing gloves?),...

Power Query / Get and Transform - July Updates

26 July 2016

Late July saw Microsoft announce 12 new data transformation and connectivity features. These updates are available as part of an Office 365 subscription, or if you have Excel 2010 or Excel 2013 you can also take advantage of these updates by downloading the latest...

July Power BI Updata

22 July 2016

That’s not a typo.With this month’s release of Power BI publisher for Excel, Analyze in Excel has become easier to use and can now be initiated directly from Excel using the Power BI publisher. With this release, there’s no longer any need to download .odc files or...

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