O'Reilly logo

Tips & Tricks for Excel-Based Financial Modeling, Volume II by M.A. Mian

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 1

Creating Dropdown Lists

In this chapter, we will show how to develop dropdown lists or menus to control data entry and user choices available in the model. Dropdown lists can greatly facilitate data entry by limiting user entries and forcing users to choose a value from a controlled list. The data validation dialog box in the Excel’s Data tab is used to construct dropdown lists of various types and complexities.

Creating Simple Dropdown List

It is very helpful in financial models to be able to pick option from a dropdown menu of various options available in the model. For example, I have a worksheet that has products’ pricing scenarios under (a) Low Case, (b) Base Case, and (c) High Case. If I have a dropdown menu of these three pricing ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required