Sunday, September 23, 2007
Display Scenarios Using a Drop-Down List
In my finance classes at Metro State, I frequently use Excel as a presentation program. I prefer it to PowerPoint because it allows me to do a live demonstration of concepts, rather than showing static slides with static pictures.
One tool that is very often useful is Excel’s Scenario Manager. If you aren’t familiar with it, the Scenario Manager is a tool that lets you specify values to place into certain cells when you choose to display a scenario. So, you can have one worksheet, but display any of several scenarios (best base, base case, worst case, etc). The problem with this tool is
Comments (0) • Permalink • Tell-a-Friend
Monday, July 30, 2007
Video: Using Controls to Change Chart Data
One of the best things about Excel is its seemingly infinite flexibility. In this video I demonstrate how you can use controls from the Forms toolbar to change the data in charts. There are so many ways to use this technique for presentations that it was difficult to choose one. I decided to show a very simple example that compares some financial ratios for GE over time to the industry averages.
The basic idea is that you use a control (a drop-down list in this example) to choose which of several data series to display in the chart. As part of the formatting of the control, you will
Comments (4) • Trackbacks (0) • Permalink • Tell-a-Friend
