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:
Find out more about the Master Financial Modeler (MFM) qualification from the Financial Modeling Institute (FMI).
Microsoft announce exciting new data import feature
Microsoft announce the ability to add Sketchup files to Excel
Microsoft announce new Text and Array functions for Excel
The release of LAMBDA has been celebrated as a seminal moment for Microsoft Excel – paralleled only by the Pivot Table back in 1994. And this comes hot on the heels of Data Types and Dynamic Array functionality. It’s an exciting time for us Excel geeks.
See where you stand with your Excel, Financial Modelling, data visualisation & analytics, and modelling tech skills
