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

Hour 17. Analyzing Your Data > Using the Scenario Manager

Using the Scenario Manager

Excel's Scenario Manager feature enables you to analyze your data to see how changing one or more values in the worksheet affects the other cells in the worksheet. This feature comes in handy for figuring out what would happen if certain factors in your business changed.

After you create a simple scenario in this hour, you'll learn about hiding and protecting scenarios to prevent others from making changes to them. Then you will view different scenarios on the worksheet. Finally, you will create a scenario summary to view all scenarios from your worksheets in one report.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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