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: Tutorial
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, Technique 2 Comments
OFFSET Function Tutorial
OFFSET is a useful function that adds lots of flexibility to your Excel models.
Using it can help you transform what would have been formula modifications into simple inputs changes. A common example is to use it to automatically compute monthly figures into year-to-date results by changing one input instead of changing formulas each month.
Download the [download id="4"] file, to learn how to use this function.