Beginning Excel What-If Data Analysis tools : Getting started with goal seek, data tables, scenarios, and solver

Beginning Excel What-If Data Analysis tools : Getting started with goal seek, data tables, scenarios, and solver

المؤلف
Paul Cornell
سنة النشر
2006
الناشر
Springer
لغة الملف
انكليزي
نوع الملف
Book
تصنيف الكتاب
Computer Science

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.


الكلمات المفتاحية: Professional and Applied Computing / Calc / Calculation / Excel / Constraint / Data analysis / Decision making / Form / Mathematical programming / Object / Optimization / Tool / Variable