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

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.

About the Author

For the past six years, Paul Cornell has been involved in creating documentation for Microsoft Office System business solution developers. Paul has contributed to developer documentation for Microsoft Office VBA Language References, Microsoft Office Primary Interop Assemblies, Microsoft Office Web Services Toolkits, and other Office development technologies. Paul has worked as a web site editor and frequent web columnist for the Office Developer Center on the Microsoft Developer Network (MSDN). Paul is currently the Documentation Manager for Microsoft Visual Studio Tools for the Microsoft Office System and the Microsoft Visual Studio core integrated development environment (IDE).