[Excel] What-if analysis

• Data table (資料 > 運算列表)
  quick comparison of business problems when one or two variables may change, e.g. calculate monthly payment given different loan principal and period
  
• Goal Seek (工具 > 目標尋找)
  provides a solution when one variable changes, e.g. calculate the max principal given a max monthly payment
  
• Solver
  provides solutions when more than variable may be changed under constraints, e.g. calculate the best production units under limited budget and sales %
  
• Scenario -
  

source:
http://www.cod.edu/people/faculty/houhain/1222Presentation/PPT%20Ch22%202003.ppt