Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th Edition

Chapter 26

Spin buttons, scrollbars, 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 Year 1 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 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 someone using my spreadsheet to determine the numberos hours an ...