Beginning Excel What-If Data Analysis Tools: Getting Started with Goal Seek, Data Tables, Scenarios, and Solver (Paperback)

Description

Beginning Excel 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.

描述

Excel的What-If數據分析工具讓您可以對數據進行實驗，以預測未來的結果。這些預測將有助於更好地做出決策，並解開許多商業分析情境的謎團。例如，What-If數據分析工具可以讓您預測降低每單位價格並增加預計銷售量對利潤率的影響。

《Beginning Excel What-If數據分析工具》探討了使用目標搜索、數據表、情境和求解器來幫助您獲得對數據的洞察力。本書專注且直接，以實用的、實際操作的方式提供了對What-If工具的教學。