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.

MicrosoftR Office ExcelR 2007 Step by Step
MicrosoftВ® Office ExcelВ® 2007 Step by Step (Step By Step (Microsoft))
ISBN: 073562304X
EAN: 2147483647
Year: 2004
Pages: 143
Authors: Curtis Frye

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: