Beginning Excel What-If Data Analysis Tools

Getting Started with Goal Seek, Data Tables, Scenarios, and Solver

By Paul Cornell

Beginning Excel What-If Data Analysis Tools Cover Image

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 decisionmaking and unlock the mystery of many business analysis scenarios.

Full Description

  • ISBN13: 978-1-59059-591-6
  • 192 Pages
  • User Level: Beginner to Advanced
  • Publication Date: December 12, 2005
  • Available eBook Formats: PDF
  • Print Book Price: $44.99
  • eBook Price: $31.99
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full Description

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.

Table of Contents

Table of Contents

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

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

Please Login to submit errata.

No errata are currently published