News & insights for the everyday modeller
Blog
A Nightmare on Spread Sheet
Our top 5 financial modelling errors, and how they could have been avoided.
3 minute read
New Text Functions Released
Microsoft has released four awesome new text functions into Excel
1 minute read
How to use Excel's TEXTSPLIT Function
Splits text out across rows and/or columns
1 minute read
How to use Excel's TEXTBEFORE Function
Returns text from a cell that occurs before a given delimiter
1 minute read
How to use Excel's TEXTAFTER Function
Returns text from a cell that occurs after a given delimiter
1 minute read
How to use Excel's SWITCH Function
Compares values against a given expression and returns the corresponding result value
2 minute read
How to use Excel's TEXTJOIN Function
Concatenates values together from cells or ranges of cells
1 minute read
How to use Excel's IFS Function
Returns one value for a TRUE result, and another for a FALSE result for multiple conditions
2 minute read
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...
3 minute read