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.