Analyzing Alternative Data Sets - Key Points

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.

 Python   SQL   Java   php   Perl 
 game development   web development   internet   *nix   graphics   hardware 
 telecommunications   C++ 
 Flash   Active Directory   Windows