Please note javascript is required for full website functionality.



Continuing Financial Modelling - Paperback Release Imminent

6 January 2021

Continuing Financial Modelling is finally released in paperback format on Saturday 16 January (we hope!).

LAMBDA Formulaic Recursion: It’s All About ME!

5 January 2021

As I mentioned previously, LET was recently made Generally Available, followed by its sister function, LAMBDA, now released into the Office 365 Beta world. This function “completes” Excel and provides you with the ability to create your own reusable formulae.

Universal app support for Macs with M1 is here

22 December 2020

Announced last week, Microsoft has been releasing new versions of their Microsoft 365 for Mac apps that will now run natively on Macs with M1. This means that the popular Office apps – including Excel – will run faster and take advantage of the performance...

Apple iOS Announcement

22 December 2020

Announced recently, Microsoft has made it possible to open multiple documents in Excel on iPad OS. With this latest update, you may take advantage of Split view for better multi-tasking on the iPad. It’s not just in Excel either: this feature is also available...

December 2020 Updates for Power BI

17 December 2020

The last update for the year provides two long-awaited features available in Preview: small multiples, and DirectQuery for Power BI datasets and Azure Analysis Services.

LAMBDA Slaughter: Creating Custom Functions Using LAMBDA

4 December 2020

For those in Office 365 Beta, there is a fantastic announcement for Excel out today. After LET was made Generally Available just a couple of weeks ago, its sister function, LAMBDA, has been released into the wild. The power of this latest addition to the Excel...

LET Off the Leash

18 November 2020

March 2020 saw Microsoft announce a new Excel function, LET, for Office 365, albeit at the time of writing, only to the Insiders – now Beta – Channel. This allowed you to stop writing the same expressions time and time again in a formula or allowed portability of...

Power BI Anomaly Detection in Preview

16 November 2020

We know we have done it before with Smart narratives, but we think we have found another newsworthy item in this month’s Power BI updates. Not sure if doing this twice means it’s an anomaly though…

November 2020 Updates for Power BI

13 November 2020

There are no anomalies in this month's updates - none that we've detected...

Unhide Multiple Sheets

13 November 2020

We have all been here. You have an Excel file and you need to unhide some hidden sheets. There are a few of them, and you know it’s time to get Repetitive Strain Injury.