Microsoft Office Tutorials and References
In Depth Information
Key points
You can use data tables to create useful what-if scenarios by changing one or two
variables that provide input to a summary formula.
You can use Goal Seek to determine what value you need in a single cell to generate
the result you want 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 ToolPak. You can use them to
examine your data thoroughly.
Search JabSto ::

Custom Search