• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

V. Advanced Data Analysis > 19. Scenarios and Goal Seeking

Chapter 19. Scenarios and Goal Seeking

Excel formulas are perfect when you need to analyze information from the past, like sales figures, census data, and experimental observations. But life becomes more complicated when you need to plan for the future. Some of the problems you can face include:

  • Missing data. Excel formulas require exact values—there’s no room for guessing or estimates.

  • Multiple possibilities. An Excel formula can only give you a single answer. If you need to make projections that take best-case and worst-case scenarios into consideration, you have to create multiple versions of the same worksheet.

  • Calculating backward. Often, when creating plans or projections, you need to


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint