O'Reilly logo

Microsoft Excel 2013: Data Analysis and Business Modeling by Wayne L. Winston

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 26. Spinner buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes

Questions answered in this chapter:

  • I need to run a sensitivity analysis that has many key inputs, such as Year 1 sales, annual sales growth, Year 1 price, and unit cost. How can I quickly vary these inputs and see the effect of the variation on the calculation of net present value, for example?

  • How can I set up a simple check box that toggles conditional formatting on and off?

  • How can I set up my worksheet so that my supply-chain personnel can click a button to choose whether we charge a high, low, or medium price for a product?

  • How can I create an easy way for a user of my worksheet to enter a day of the week without having to type any text? ...

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