News & insights for the everyday modeller

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

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

How to use Excel's MAX Function

Returns the largest value from a range of numbers

How to use Excel's EOMONTH function

Returns the last day of the month after adding a specified number of months