Civil Engineering Projects
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 ...
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 ...
