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.
Beginning Excel What-If Data Analysis Tools
and over one million other books are available for Amazon Kindle.
Learn more
| ||||||||||||||||||
Book Description
Frequently Bought Together
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
Would you like to update product info or give feedback on images?
|
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,
By
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.
4 of 16 people found the following review helpful:
1.0 out of 5 stars
Not Worth The Price,
By
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.
Share your thoughts with other customers: Create your own review
|
|
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!
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!
What Other Items Do Customers Buy After Viewing This Item?
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
