Case Study: Using Excel What-If Tools

Summary

In this chapter, you completed several exercises that demonstrated in case-study format how to do the following:
  • Use Goal Seek to forecast a running club’s membership dues.

  • Use one-variable and two-variable data tables to forecast race paces.

  • Use scenarios to forecast race-day cash flow.

  • Use Solver to forecast race-day finish times and pair up race relay teams.

Keywords

Cash Flow Elapse Time Finish Time Select Cell Operator List 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Paul Cornell 2006

Personalised recommendations