Ebooks
Excel What If Data Analysis Tools~tqw~ darksiderg
Torrent info
Torrent Files List
Torrent description
*******************************************************************************
Excel What-If Data Analysis Tools
*******************************************************************************
-------------------------------------------------------------------------------
General Information
-------------------------------------------------------------------------------
Type.................: Ebook
Part Size............: 3,077,889 bytes
-------------------------------------------------------------------------------
Post Information
-------------------------------------------------------------------------------
Posted by............: ~tqw~
-------------------------------------------------------------------------------
Release Notes
-------------------------------------------------------------------------------
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 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 unit--while increasing projected unit sales--might 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
Preface xi
About the Author xiii
About the Technical Reviewer xv
Acknowledgments xvii
Introduction xix
CHAPTER 1 Goal Seek 1
CHAPTER 2 Data Tables 21
CHAPTER 3 Scenarios 39
CHAPTER 4 Solver 59
CHAPTER 5 Case Study: Using Excel What-If Tools 109
APPENDIX A Excel What-If Tools Quick Start 131
APPENDIX B Summary of Other Helpful Excel Data Analysis Tools 139
APPENDIX C Summary of Common Excel Data Analysis Functions 149
APPENDIX D Additional Excel Data Analysis Resources 155
INDEX 157
Product Details
* ISBN: 1590595912
* ISBN-13: 9781590595916
* Format: Paperback, 192pp
* Publisher: Apress L. P.
* Pub. Date: December 2005
-------------------------------------------------------------------------------
Install Notes
-------------------------------------------------------------------------------
Adobe Acrobat Reader