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.

8