News & insights for the everyday modeller

Are you a real financial modeller?

“If you build any sort of financial forecast, using any type of spreadsheet tool to predict the...

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

FAST Modelling – What’s it all about?

FAST is a financial modelling standard which promotes a set of modelling (or spreadsheet design)...

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

The Excel Navigation Pane

Quickly understand how a workbook is structured

How to use Excel's MIN Function

Returns the smallest value from a range of numbers