Civil Engineering Projects
Being Aware of Advanced Functions and Functionality
In this chapter, I cover the functions that are most commonly used in financial modeling. If ...
VLOOKUP and HLOOKUP
The lookup functions — VLOOKUP and HLOOKUP — are very often used in build- ing financial models and are often the "go to" ...
Getting Familiar with the Most Important Functions
You've arrived at the meaty part of the chapter. This is where things get interest- ing! In ...
Using Functions in Excel
he power of Microsoft Excel lies in its ability to do math for you. (Shh! Don't tell your high school algebra teacher!) ...
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 ...
