New Business Development Portal

Posts Tagged ‘Productivity’

Very interesting addition you can add to your excel models to emphasize a particular variable.

To quote the creator, S Anand, “Creating a slider-based model is quite useful. You can download a US Treasury yields example to see how this is done. As you move the slider, the yield curve moves over time, showing how it has fluctuated. The trick is to:

1. build the entire model based on a single cell. Cell H1 in this example acts as the index to the dates.
2. create a slider. Go to View – Toolbars – Control Toolbox and add a slider.
3. and link the slider to the cell. Right-click on the cell in design mode, select View Code, and type Range(“H1″).Value = ScrollBar1.Value in the Scrollbar change event.

Excel – Make your model visually obvious | s-anand.net.