Beginning Excel What-If Data Analysis Tools
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 |
Paul Cornell works at Microsoft on the documentation team for Microsoft Visual Studio Tools for the Microsoft Office system. He worked as an editor, writer, and columnist on the MSDN Office Developer Center and edited the Microsoft Office Visual Basic Language Reference. Cornell also founded the Power User Corner, on Microsoft Office Online, where he was a frequent contributor.