Goal Seek -- Data tables -- Scenarios -- Solver -- Case study: Using Excel what-if tools -- Appendix A: Excel what-if tools quick start -- Appendix B: Summary of other helpful Excel data analysis tools -- Appendix C: Summary of common Excel data analysis functions -- Appendix D: Additional Excel data analysis resources
Summary
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
Analysis
systemen
systems
computerwetenschappen
computer sciences
Information and Communication Technology (General)
Informatie- en communicatietechnologie (algemeen)
Bibliography
Includes bibliographical references (page 155) and index