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

ISBN-13: 9781590595916 / Angielski / Miękka / 2005 / 194 str.

Paul Cornell

Opis

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.

Spis treści

1. Goal Seek
2. Data Tables
3. Scenarios
4. Solver
5. Case Study: Using Excel What-If Tools

O autorze

Paul Cornell works at Microsoft on the documentation team for Microsoft Visual Studio Tools for the Microsoft Office system. He worked as an editor, writer, and columnist on the MSDN Office Developer Center and edited the Microsoft Office Visual Basic Language Reference. Cornell also founded the Power User Corner, on Microsoft Office Online, where he was a frequent contributor.