Learn
Restricting and Validating Data After you finish building a financial model, you may be tempted to keep it to your- self, because you don't want ...
Using Shortcuts If you're spending a lot of time modeling in Excel, you can save yourself a lot of time by learning some keyboard shortcuts. For ...
Linking in Excel As discussed in Chapter 1, the definition of financial modeling is that when the inputs change, the outputs change as well. ...
Naming Ranges Many financial modelers like to include named ranges in their models. Named ranges are just a way of naming a cell, or a range of ...
Excel Tools and Techniques for Financial Modeling hen you're using Excel for the purpose of financial modeling, much of the emphasis is on ...
FINDING CIRCULAR REFERENCES If you inadvertently link a formula to itself somehow, this will cause a circular reference, which is a form of error ...
Using Audit Tools to Find and Correct Errors When inheriting a model, there are several factors to come to grips with: the layout, design, ...
Inheriting a File: What to Check For When you're inheriting someone else's model, the best-case scenarios is a model handover meeting where you ...
Using Someone Else's Financial Model s a consultant, my favorite scenario is when a client comes to me and asks me to build a new model from ...
Applying conditional formatting to an error check To make the error check even more prominent to the user, consider using condi- tional ...
