Modeling Functions and Tools

Abstract

I have been asked often if there is a certain group of Excel functions, routines, and tools that are essential for financial modelers. It’s a tricky question because on the one hand, there are certain functions that are a must. But on the other, modeling is a strange beast and very often situations arise that require some thinking outside of the box. When these situations occur, modelers may need to ditch the must-have functions and either create their own or use a totally new function. This versatility is something that separates the good modeler from the exceptional modeler.