Chapter 27. Spin buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes

Questions answered in this chapter:

Image 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. Is there a way I can quickly vary these inputs and see the effect of the variation on the calculation of net present value, for example?

Image How do 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 ...

Get Microsoft Excel 2016 Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.