Beginning Excel What-If Data Analysis Tools and over one million other books are available for Amazon Kindle. Learn more

Buy New

or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
Buy Used
Used - Very Good See details
$3.30 & eligible for FREE Super Saver Shipping on orders over $25. Details

or
Sign in to turn on 1-Click ordering.
 
   
More Buying Choices
Have one to sell? Sell yours here
Beginning Excel What-If Data Analysis Tools: Getting Started with Goal Seek, Data Tables, Scenarios, and Solver
 
 
Start reading Beginning Excel What-If Data Analysis Tools on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

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

Paul Cornell (Author)
1.5 out of 5 stars  See all reviews (2 customer reviews)

Price: $39.99 & this item ships for FREE with Super Saver Shipping. Details
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Want it delivered Monday, January 30? Choose One-Day Shipping at checkout. Details

Formats

Amazon Price New from Used from
Kindle Edition $17.59  
Paperback $39.99  

Book Description

December 13, 2005

Excel’s "what-if" data analysis tools allow you to experiment with your data to project future results, which can in turn lead to better decision-making. For example, you could take a set of sales data and forecast how lowering price per unit while increasing projected unit sales might affect your profit margins. Beginning Excel What-If Data Analysis Tools explores how to use Goal Seek, Data Tables, Scenarios, and Solver to help you gain insights into your data.


Frequently Bought Together

Customers buy this book with A Complete Guide to PivotTables: A Visual Approach $22.97

Beginning Excel What-If Data Analysis Tools: Getting Started with Goal Seek, Data Tables, Scenarios, and Solver + A Complete Guide to PivotTables: A Visual Approach
  • This item: Beginning Excel What-If Data Analysis Tools: Getting Started with Goal Seek, Data Tables, Scenarios, and Solver

    In Stock.
    Ships from and sold by Amazon.com.
    This item ships for FREE with Super Saver Shipping. Details

  • A Complete Guide to PivotTables: A Visual Approach

    In Stock.
    Ships from and sold by Amazon.com.
    Eligible for FREE Super Saver Shipping on orders over $25. Details



Editorial Reviews

About the Author

Paul Cornell is the author of successful books showing intermediate to advanced Excel users the finer points of Excel. His books include the successful Apress A Complete Guide to Pivot Tables (Apress, ISBN: 1-59059-432-0) and Accessing and Analyzing Data with Microsoft Excel (Microsoft Press, ISBN: 0-73561-895-X).

Paul works at Microsoft as a manager of the documentation teams for Microsoft Visual Studio Tools for the Microsoft Office System and Microsoft Visual Studio core features. He has also served as an editor and writer on several developer-oriented documentation projects for the MSDN Office Developer Center and Microsoft Office Online.


Product Details

  • Paperback: 192 pages
  • Publisher: Apress; 1 edition (December 13, 2005)
  • Language: English
  • ISBN-10: 1590595912
  • ISBN-13: 978-1590595916
  • Product Dimensions: 9.1 x 7 x 0.6 inches
  • Shipping Weight: 14.4 ounces (View shipping rates and policies)
  • Average Customer Review: 1.5 out of 5 stars  See all reviews (2 customer reviews)
  • Amazon Best Sellers Rank: #1,586,489 in Books (See Top 100 in Books)

 

Customer Reviews

2 Reviews
5 star:    (0)
4 star:    (0)
3 star:    (0)
2 star:
 (1)
1 star:
 (1)
 
 
 
 
 
Average Customer Review
1.5 out of 5 stars (2 customer reviews)
 
 
 
 
Share your thoughts with other customers:
Most Helpful Customer Reviews

3 of 4 people found the following review helpful:
2.0 out of 5 stars Good Information, But Needs Updating, July 19, 2010
By 
David (Irving, Texas, United States) - See all my reviews
(REAL NAME)   
This review is from: Beginning Excel What-If Data Analysis Tools: Getting Started with Goal Seek, Data Tables, Scenarios, and Solver (Paperback)
The information contained in this book is very good. Most Excel users have little, or no experience with Excel's What-If analysis tools. The Goal Seek and What-if scenerios are foreign to most beginning and casual Excel users.

This book does a good job of introducing those tools to the user and explains them well, using real-life examples to illustrate how the tools are to be used.

However, the book needs to be updated. The book is written based upon the 2003 verson of Excel. Microsoft made a major revision in the user interface in Excel 2007. If you are using Excel 2003 or older, the book is fine for you. But if you have upgraded to Excel 2007 or Excel 2010, the book will be confusing. Instead of using menus, the newer versions of Excel use the ribbon. Unless you already know where the Data Anallysis tools are located, the instructions in the book will not direct you to the Data Analysis tools. You will have to hunt and find them on your own.

The book presents good material, but needs to be updated to the 2007 or 2010 version of Excel in order to be relevant to the user today.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


4 of 16 people found the following review helpful:
1.0 out of 5 stars Not Worth The Price, February 22, 2008
By 
David L. Johnson (Globe, AZ United States) - See all my reviews
(REAL NAME)   
This review is from: Beginning Excel What-If Data Analysis Tools: Getting Started with Goal Seek, Data Tables, Scenarios, and Solver (Paperback)
This book is totally not worth the money. There should be some sort of warning on the front cover.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No

Share your thoughts with other customers: Create your own review
 
 
 
Only search this product's reviews



Inside This Book (learn more)
Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
bird registration fee, worksheet cell values, single worksheet cell, regular registrants, target finish time, other sort options, forecast matrix, regular registration fee, adjustable cells, senior tickets, cell box, click the scenario, worksheet cell reference, target pace, kids dash, operator box, most profitable mix, box office income, click cell, panes split, scenario summary report, data analysis functions, stock dividend payments, changing cells, child tickets
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Click the Cell Reference, Click the Constraint, Scenario Manager, Click Solve, Click the By Changing Cells, Assume Linear Model, Show Trial Solution, Help Figure, Add Scenario, Click Options, Max Time, Change Constraint, Click Currency, Close By Changing Cells, Guess Subject, Microsoft Office, Save Scenario, Add Constraint, Click Format, Edit Scenario, Ridge Running Exercises, Save Model, Click the Result Cells, Microsoft Excel, Source Code
New!
Concordance | Text Stats
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Search Inside This Book:


Tags Customers Associate with This Product

 (What's this?)
Click on a tag to find related items, discussions, and people.
 

Your tags: Add your first tag
 

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 

Search Customer Discussions
Search all Amazon discussions
   



So You'd Like to...


Create a guide


Look for Similar Items by Category


Look for Similar Items by Subject