Learn
Deciding Which Type of Chart to Use When deciding how to display the output of your model, you have a lot of choices, especially in the later ...
Conveying Your Message by Charting Scenarios As I mention in Chapter 8, the major limitation of drop-down scenarios such as the one built in the ...
Charting and Presenting Model Output he final stage of the model building process is to present the outcome of the model. You've spent a lot of ...
Using Scenario Manager to Model Loan Calculations Scenario Manager is grouped together with Goal Seek and Data Tables in the What-If Analysis ...
Applying Sensitivity Analysis with Data Tables Data tables are among the more advanced and complex financial modeling tools available. Data ...
Applying Scenarios to Your Financial Model ne of the things that makes a financial model a financial model and not a spreadsheet is that it ...
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!) ...
