O'Reilly logo

The Basics of Financial Modeling by Jack Avon

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 3

Modeling Functions and Tools

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.

In this chapter, I will cover the functions that are of immediate value to modeling. These functions are indispensable and as you ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required