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
Category Archives: Excel Functionality
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, [...]
Using Data Validation – The Trigger Technique
If you don’t know about data validation yet, I suggest you read the following document before getting familiar with this method.
http://www.contextures.com/xlDataVal01.html
Data validation is certainly one of the best tools to perform what-if analysis, along with sensitivity tables. There many types of sensitivity analysis that can be performed with data validation. These can be used alone [...]
Excel’s GO TO Functionality
In my previous post, I showed you how to improve the clarity of your models by identifying inputs.
However, you might sometimes be having to work on someone else’s model and therefore having no idea of its structure. In such cases, you’ll find that the GO TO functionality can be very helpful.
For example, in the following [...]
Conditional Formats Control – The Warm-Up