Key Points

• Scenarios enable you to describe many potential business cases within a single workbook.

• It's usually a good idea to create a "normal" scenario that enables you to reset your worksheet.

• Remember that you can change up to 32 cells in a scenario, but no more.

• You can summarize your scenarios on a new worksheet to compare how each scenario approaches the data.

• Use Goal Seek to determine what value you need in a single cell to generate the desired result from a formula.

• If you want to vary the values in more than one cell to find the optimal mix of inputs for a calculation, use the Solver Add-In.

• Advanced statistical tools are available in the Analysis ToolPakuse them to go over your data thoroughly.