Learn
Model with Consistent Formulas If you're getting a model audited by a third party, one of the many things they'll check for is the number of ...
Create Dynamic Formulas Using Links In financial modeling, you need to understand the difference between linked and hard-coded numbers. A linked ...
Building a Financial Model by the Rulebook ecause Excel is such a wonderfully flexible and universal tool, you can pretty much do anything with ...
Determining your audience Who will be viewing or using your model in the future? If it's for only your own use, you should still follow good ...
Considering the Layout andDesign of Your Model The problem that needs to be solved and the output required often influence the layout and design ...
FINDING AN RGB COLOR If you don't know the RGB color that's been used in your company logo or the image you'd like to insert in the model, you ...
Designing How the Problem's Answer Will Look When you've identified the problem that needs to be solved, it's very tempting to dive straight in ...
Planning and Designing Your Financial Model lanning and design can sometimes be the most difficult part of building a financial model — ...
Looking at Alternatives and Supplements to Excel Excel is often called the "Swiss Army knife of software" or the "second-best solu- tion" because ...
Recognizing the Dangers of Using Excel Financial modelers, like anyone working extensively with Excel, are very aware of the inherent risks ...
