January 2011
Beginner to intermediate
720 pages
23h 29m
English
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 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 ...