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
Posted by Tim on 09/23 at 07:06 PM in
Controls
in
Combo Box
in
Functions
in
Financial Functions
in
NPV
in
Scenario Manager
in
VBA
Comments (0) • Permalink • Tell-a-Friend
Comments (0) • Permalink • Tell-a-Friend
Page 1 of 1 pages
