News & insights for the everyday modeller

SketchUp Files

Microsoft announce the ability to add Sketchup files to Excel

New Text and Array Functions

Microsoft announce new Text and Array functions for Excel

LAMBDA – The Ultimate Excel Function?

The release of LAMBDA has been celebrated as a seminal moment for Microsoft Excel – paralleled only...

An Introduction to Financial Modelling Standards

The different modelling standards are more alike than they are different. They all emphasise...

The Future of Excel

In this series of articles, we will look at the future of Excel.

FAST Modelling – What’s it all about?

The FAST Standard For those of you unfortunate enough to have been within earshot when I start to...

The Top 8 Excel Functions for Financial Modelling

Discover the key Excel functions for financial modelling.

How to use Excel's SUMIFS Function

Sum rows that meet specifc criteria

How to use Excel's XLOOKUP Function

Looks up values from another table

How to use Excel's INDEX Function

Returns a value from a range based on the position specified