Beginning Excel What-If Data Analysis Tools
Getting Started with Goal Seek, Data Tables, Scenarios, and Solver
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.
Autor: | Cornell, Paul |
---|---|
ISBN: | 9781590595916 |
Sprache: | Englisch |
Seitenzahl: | 192 |
Produktart: | Kartoniert / Broschiert |
Verlag: | APRESS |
Veröffentlicht: | 13.12.2005 |
Untertitel: | Getting Started with Goal Seek, Data Tables, Scenarios, and Solver |
Schlagworte: | Calc Calculation Excel constraint data analysis decision making form mathematical programming object optimization |
Anmelden