Microsoft Excel 2016 Data Analysis and Business Modeling

Chapter 27. Spin 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. 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?

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 ...