Please note javascript is required for full website functionality.

News

Power Fx

3 March 2021

Microsoft Power Fx has been announced as “…the newest member of the Microsoft Power Platform family…”. It is the low code language for expressing logic across the Microsoft Power Platform.


100th Newsletter

1 March 2021

We did it! 964 articles, 697 keyboard shortcuts, 47 readers’ questions answered and a total of 2,040 pages, detailing all things Excel, financial modelling and Power BI. Our humble little monthly newsletter has become a centurion.


February 2021 Updates for Power BI

24 February 2021

They’ve been on hiatus, but they’re now back with a vengeance! The raft of Power BI updates returns...


Office 2021 Coming Soon

22 February 2021

Microsoft has recently announced two new versions of Office 2021 (not Office 2022, as previously thought): a consumer Office 2021 version and Office Long-Term Servicing Channel (LTSC) for commercial customers.


Office Scripts Ask Me Anything

3 February 2021

We have talked about Office Scripts previously


Excel Roadmap Updates

11 January 2021

Microsoft is planning to add support for co-authoring protected Excel files. The new feature will allow users to protect Excel files using passwords yet still be able to share them with others who may edit these files without needing to remove the protection.This...


SumProduct Melbourne on the Move

11 January 2021

Having pretty much stayed stationary in 2020 with the COVID-19 lockdowns, the New Year sees the Melbourne office moving.


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.


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 for Word and PowerPoint too.


Newsletter