| Chapter Objectives (See related pages)
Learn how to use Excel's goal-seeking tools and concisely state a goal-seeking objective |
| | | Try to attain a desired goal by trial and error |
| | |
(See page(s) MOS XL03S-1-4)
Implement goal-seeking by using a graph |
| | | Create goal-seeking reports |
| | |
(See page(s) MOS XL03E-1-7)
Install the Excel Solver tool |
| | |
(See page(s) MOS XL03E-1-7)
Use Excel's Solver to unravel more complex problems |
| | |
(See page(s) MOS XL03E-1-7)
Identify the formula to be optimized |
| | |
(See page(s) MOS XL03E-1-7)
Specify constraints on the problem that the Solver must satisfy |
| | |
(See page(s) MOS XL03E-1-7)
Learn how to create Solver answer, limit, and sensitivity reports |
|