News & insights for the everyday modeller

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

How to use Excel's IFS Function

Returns one value for a TRUE result, and another for a FALSE result for multiple conditions

5 Reasons Why You Should Adopt a Data Driven Modelling Approach

I was preparing for some face to face training for a client recently and I was struck by two things...

Top 10 Reasons to Join Full Stack

Here are the top 10 reasons why joining Full Stack Modeller is the right decision for you. 1 You...

The 9 Cs FBP Formula® for Finance Business Partnering Success!

As fabulous financial modellers, it can be equally helpful to consider how to partner effectively...

Import data from a picture into Excel

Microsoft announce exciting new data import feature

Are you a real financial modeller?

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