Updates
Latest Tweet
What's New?
Check out for latest innovation, a computer based training video collection
Like this Page
Beginning Excel What-If Data Analysis Tools: Getting Started with Goal Seek, Data Tables, Scenarios, and Solver Review by David
Good Information, But Needs Updating
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.