Beginning Excel What-If Data Analysis Tools
Getting Started with Goal Seek, Data Tables, Scenarios, and Solver
Buch in deiner Nähe kaufen
Beschreibung
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.
The only book on the market dedicated to the What-If functions and tools built into Excel, which are key to many business analysis scenarios Focused and to the point – where other Excel books force the reader to wade through 100’s of pages of related information and commit hours of reading, this book gets straight to the topic of teaching the reader about What-If scenario tools in Excel Offers the deepest tutorial treatment of the Solver add-in, the Goal Seeker and the other What-If scenario analysis tools, in a practical, hands-on exercises approach to using Excel to get business results
Autor*in
Paul Cornell
Themen in »Beginning Excel What-If Data Analysis Tools«
Calc Calculation Excel constraint data analysis decision making form mathematical programming object optimization tool variable