Excel's "what-if" data analysis tools allow you to experiment with your
data to project future results, which can in turn lead to better
decision-making. For example, you could take a set of sales data and
forecast how lowering price per unit while increasing projected unit
sales might affect your profit margins. Beginning Excel What-If Data
Analysis Tools explores how to use Goal Seek, Data Tables, Scenarios,
and Solver to help you gain insights into your data.