Beginning Excel What-If Data Analysis Tools

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

By Paul Cornell

  • eBook Price: $31.99
  • Print Book Price: $44.99
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

  • Moving to Office 365
  • Develop on Yammer
  • Custom SharePoint Solutions with HTML and JavaScript
  • File Management Made Simple, Windows Edition
  • Microsoft Azure
  • Beginning Windows 10
  • Introducing SQL Server
  • Expert SQL Server in-Memory OLTP
  • Beginning Big Data with Power BI and Excel 2013
  • Extending SSIS with .NET Scripting
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

Best-Sellers

    1. Pro SQL Server Internals

      $41.99

      View Details

    2. Beginning 3D Game Development with Unity 4

      $34.99

      View Details

    3. Beginning iPhone Development with Swift

      $31.99

      View Details

    4. Financial Modeling for Business Owners and Entrepreneurs

      $31.99

      View Details