Share this blog
The Financial Modeler- Conditionnal Format Controls – Part Deux
- Spotting Errors
- How to Model Depreciation
- Improve Table Visualization using OFFSET and Conditional Formatting
- OFFSET Function Tutorial
- Getting More From Your Pivot Tables
- Conditional Formats Control – The Warm-Up
- Improve your model now! #REF Editions
- Back to School – The Excel Model
- R1C1 Enlightenment
Tag Archives: Technique
Powerful Sensitivity Tables
In my previous post, I showed you how to do sensitivity analysis with Excel’s data tables. However the functionality allow us to do sensitivity on 2 variables only. Today I’m following up with a way to overcome this limitation.
As an example, an investment might be sensitive to many variables (e.g. lauch dates, set-up costs, marginal [...]
Discovering Sensitivity Tables
Excel has a built-in functionality for sensitivity analysis, hidden under the unclear name of “Data tables” (“tables” in Excel 97-2003).
Two options are available in using these “Data tables”:
Evaluate the impact of one variable on one or more resulting elements (with 2 possible layouts)
Evaluate the impact of two variable on one resulting elements
In my next post, [...]
Posted in Excel Functionality, Model Techniques Also tagged Data Tables, Sensitivity, Tutorial 2 Comments
Seven tips to develop a structured model
Create A Modular Design For Your Model
Don’t put everything on a single worksheet. Separate your model’s components on multiple worksheets, i.e. Revenues, COGS, Other Costs, Financing, Amortization etc…
Keep Your Sheet Names As Short As Possible
It will help keep formulas legible and you’ll see more sheet tabs at once which will help browse within the workbook. [...]
Conditionnal Format Controls – Part Deux
In this post, I'll show you how I like to use Conditional Formatting in my Excel models to add a disabled look to some cells based on a criteria. With this technique, you will get clear visual indications that will simplify inputs and help you avoid errors.