Islandsbanki Under-prices Stake Sale

450 million shares were undervalued.

Happy Birthday Full Stack Modeller

Full Stack Modeller has just celebrated its two-year anniversary, and I thought this would be a...

A Nightmare on Spread Sheet

Our top 5 financial modelling errors, and how they could have been avoided.

The Financial Modelling Awards 2022

The winners for this year's Financial Modelling Awards have been announced.

New Text Functions Released

Microsoft has released four awesome new text functions into Excel

How to use Excel's TEXTSPLIT Function

Splits text out across rows and/or columns

How to use Excel's TEXTBEFORE Function

Returns text from a cell that occurs before a given delimiter

How to use Excel's TEXTAFTER Function

Returns text from a cell that occurs after a given delimiter

How to use Excel's SWITCH Function

Compares values against a given expression and returns the corresponding result value

How to use Excel's TEXTJOIN Function

Concatenates values together from cells or ranges of cells