معرفی کتاب «Beginning Excel What-If Data Analysis Tools : Getting Started with Goal Seek, Data Tables, Scenarios, and Solver» نوشتهٔ Paul Cornell، منتشرشده توسط نشر Apress ; Distributed to the Book trade worldwide by Springer-Verlag New York در سال 2006. این کتاب در فرمت pdf، زبان انگلیسی ارائه شده است.
* 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.
Excels what-if data analysis tools let you experiment with your data to project future results. In turn, these predictions will lead to better decision making and unlock the mystery of many business analysis scenarios. For example, what-if data analysis tools will enable you to forecast how lowering the price per unitwhile increasing projected unit salesmight affect your profit margins.
Beginning Excel What-If Data Analysis Tools explores the use of Goal Seek, Data Tables, Scenarios, and Solver to help you get insight on your data. This book is focused and to the point, and it provides tutorial treatment of what-if tools in a practical, hands-on manner.
Table of Contents
- Goal Seek
- Data Tables
- Scenarios
- Solver
- Case Study: Using Excel What-If Tools
Excel's "what-if" data analysis tools let you experiment with your data to project future results. In turn, these predictions will lead to better decision making and unlock the mystery of many business analysis scenarios. For example, what-if data analysis tools will enable you to forecast how lowering the price per unit -- while increasing projected unit sales -- might affect your profit margins. Beginning Excel What-If Data Analysis Tools explores the use of Goal Seek, Data Tables, Scenarios, and Solver to help you get insight on your data. This book is focused and to the point, and it provides tutorial treatment of what-if tools in a practical, hands-on manner Presents a collection of tutorials and exercises to learn the tools found in Excel.
