That’s because, when it comes to formulas, we aim for simplicity and readability. Complex functions with poor audit trails (I’m thinking of OFFSET, for example) are less useful when your primary objective is transparency. Here are 12 functions that we use again and again in building financial models for our clients. We’ve shared them so […]
Colour is a transparent and effective way to communicate meaning within excel models.