QCon Special

Beginning Excel What-If Data Analysis Tools

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

By Paul Cornell

  • eBook Price: $31.99 $19.19
Buy eBook Buy Print Book

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

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

Related Titles

  • Beginning F# 4.0
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

If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.
No errata are currently published

Best-Sellers

    1. PHP Objects, Patterns, and Practice

      $38.99

      View Book

    2. Beginning Android 3D Game Development

      $34.99

      View Book

    3. Troubleshooting Oracle Performance

      $41.99

      View Book

    4. Beginning Amazon Web Services with Node.js

      $38.99

      View Book