3 min to read
Blog
The Financial Modelling Awards 2022
The winners for this year's Financial Modelling Awards have been announced.
3 min to read
Blog
New Text Functions Released
Microsoft has released four awesome new text functions into Excel
2 min to read
Blog
How to use Excel's TEXTSPLIT Function
Splits text out across rows and/or columns
2 min to read
Blog
How to use Excel's TEXTBEFORE Function
Returns text from a cell that occurs before a given delimiter
2 min to read
Blog
How to use Excel's TEXTAFTER Function
Returns text from a cell that occurs after a given delimiter
3 min to read
Blog
How to use Excel's SWITCH Function
Compares values against a given expression and returns the corresponding result value
2 min to read
Blog
How to use Excel's TEXTJOIN Function
Concatenates values together from cells or ranges of cells
3 min to read
Blog
How to use Excel's IFS Function
Returns one value for a TRUE result, and another for a FALSE result for multiple conditions
4 min to read
Blog
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 when looking through their spreadsheets: