The winners for this year's Financial Modelling Awards have been announced.
Microsoft has released four awesome new text functions into Excel
Splits text out across rows and/or columns
Returns text from a cell that occurs before a given delimiter
Returns text from a cell that occurs after a given delimiter
Compares values against a given expression and returns the corresponding result value
Concatenates values together from cells or ranges of cells
Returns one value for a TRUE result, and another for a FALSE result for multiple conditions
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:
See where you stand with your Excel, Financial Modelling, data visualisation & analytics, and modelling tech skills
