Microsoft Office Tutorials and References
In Depth Information
▪ 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.