Tile: Lesson 5 - What-If Analysis (Goal Seek) | E/LMS 715 Excel Intermediate

Lesson 5 - What-If Analysis (Goal Seek)

In this lesson we demonstrate the setup and execution of Goal Seek.

We will use the PMT function as the formula for setting up Goal Seek.
- Goal Seek
  
  The goal seek function is a method of solving for a desired output by changing an assumption that drives it. This function essentially uses a trial and error approach to back-solving the problem by plugging in guesses until it arrives at the answer.
- Goal Seek Example 1 File
  
  View
- Goal Seek Example 2 File
  
  View
- Working File : Goal Seek
  
  View