Browse by Category
View AllAbout Camilla Culley
Circular References
Financial Modelling Principles
General Interest
Technical
-
Avoiding Black Boxes #1: Structuring Formulae
Not surprisingly, financial models are frequently described as black boxes. -
Macros: Yes or No?
What are macros and are they a hindrance or a help in financial modelling? -
Avoiding IF Functions #3: Using CHOOSE or INDEX
As part of my mission to encourage modellers to reduce reliance on the IF function, this month’s blog looks at situations when either CHOOSE or INDEX with MATCH can replace ... -
Avoiding IF Functions #2: Using MIN and MAX
As part of my mission to encourage modellers to reduce reliance on the IF function, this month’s blog looks at how MAX and MIN can replace IF. -
Avoiding IF Functions #1: Logical Statements
IF. Perhaps the most commonly used Excel function in financial modelling. My early models were almost entirely created around this function. There is nothing intrinsically wrong with an IF function. ... -
Usain Bolt and Excel Shortcuts
Whilst watching international athletes competing in the world athletics championships, I cannot help but think about Excel shortcuts. Sad, but true.