ebook ebooks e-book e-books downloaden bei MyEbooks.ch downloaden

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

:	Paul Cornell
:	Beginning Excel What-If Data Analysis Tools Getting Started with Goal Seek, Data Tables, Scenarios, and Solver
:	Apress
:	9781430200987
:	1
:	CHF 42.70
:

:	Informatik
:	English

:	192
:	Wasserzeichen/DRM
:	PC/MAC/eReader/Tablet
:	PDF

* The only book on the market dedicated to the What-If functions and tools built into Excel, which are key to many business analysis scenarios.

* Focused and to the point - where other Excel books force the reader to wade through 100's of pages of related information and commit hours of reading, this book gets straight to the topic of teaching the reader about What-If scenario tools in Excel.

* Offers the deepest tutorial treatment of the Solver add-in, the Goal Seeker and the other What-If scenario analysis tools, in a practical, hands-on exercises approach to using Excel to get business results.

Paul Cornell works at Microsoft on the documentation team for Microsoft Visual Studio Tools for the Microsoft Office system. He worked as an editor, writer, and columnist on the MSDN Office Developer Center and edited the Microsoft Office Visual Basic Language Reference. Cornell also founded the Power User Corner, on Microsoft Office Online, where he was a frequent contributor.

	Contents at a Glance	4
	Contents	6
	Preface	12
	About the Author	14
	About the Technical Reviewer	16
	Acknowledgments	18
	Introduction	20
	CHAPTER 1 Goal Seek	24
	What Is Goal Seeking?	24
	When Would I Use Goal Seek?	24
	How Do I Use Goal Seek?	25
	Try It: Use Goal Seek to Solve Simple Math Problems	27
	Speed,Time, and Distance Math Problems	27
	Circle Radius, Diameter, Circumference, and Area Math Problems	28
	Algebraic Equation Math Problem	30
	Try It: Use Goal Seek to Forecast Interest Rates	32
	Home Mortgage Interest Rate	33
	Car Loan Interest Rate	34
	Savings Account Interest Rate	36
	Try It: Use Goal Seek to Determine Optimal Ticket Prices	37
	Number of Tickets Sold	38
	Ticket Prices	40
	Troubleshooting Goal Seek	41
	Summary	42
	CHAPTER 2 Data Tables	44
	What Are Data Tables?	44
	When Would I Use Data Tables?	45
	How Do I Create Data Tables?	47
	Working with One-Variable Data Tables	47
	Working with Two-Variable Data Tables	49
	Clearing Data Tables	50
	Converting Data Tables	50
	Adjusting Data Table Calculation Options	51
	Try It: Use Data Tables to Forecast Savings Account Details	51
	One-Variable Data Table to Forecast Savings Account Details	52
	Two-Variable Data Table to Forecast Savings Account Details	53
	Try It: Use Data Tables to Determine Royalty Payments	54
	One-Variable Data Table to Determine Royalty Payments	55
	Two-Variable Data Table to Determine Royalty Payments	56
	Try It: Use Data Tables to Calculate Stock Dividend Payments	58
	One-Variable Data Table to Calculate Stock Dividend Payments	58
	Two-Variable Data Table to Calculate Stock Dividend Payments	59
	Troubleshooting Data Tables	60
	Summary	61
	CHAPTER 3 Scenarios	62
	What Are Scenarios?	62
	When Would I Use Scenarios?	63
	How Do I Use Scenarios?	64
	Creating a New Scenario	65
	Displaying a Scenario	66
	Editing an Existing Scenario	67
	Deleting a Scenario	67
	Creating a Scenario Summary Report	67
	Merging Scenarios from Another Worksheet	68
	Preventing Changes to a Scenario	70
	Try It: Use Scenarios to Forecast Development Costs	71
	Worst-Case Scenario	71
	Best-Case Scenario	72
	Scenario Results	73
	Try It: Use Scenarios to Forecast Sales	74
	Summer Scenario	75
	Winter Scenario	75
	Scenario Results	76
	Try It: Use Scenarios to Forecast Rental Volumes	77
	Blockbuster Week Scenario	77
	Regular Week Scenario	78
	Scenario Results	79
	Troubleshooting Scenarios	80
	Summary	81
	CHAPTER 4 Solver	82
	What Is Solver?	82
	When Would I Use Solver?	83
	How Do I Use Solver?	84
	Installing Solver	86
	Setting Solver Parameters	86
	Adding and Changing Constraints	88
	Setting Solver Options	89
	Saving and Loading Solver Models	92
	Working with the Solver Results	94
	Working with the Show Trial Solution Dialog Box	96
	Creating Solver Reports	96
	Try It: Use Solver to Solve Math Problems	100
	Cube Volume Problem	100
	Object Velocity Problem	101
	Try It: Use Solver to Forecast Auction Prices	102
	Average Daily Bid Increase for One Item	103
	Average Daily Auction Bid Increase for All Items	104
	Try It: Use Solver to Determine a Home Sales Price	106
	Try It: Use Solver to Forecast the Weather	108
	Minimum Yearly Precipitation Total for Seattle	109
	Average December Precipitation Total for All Cities	110
	Try It: Experiment with the Default Solver Samples	112
	Quick Tour	112
	Product Mix	114
	Shipping Routes	115
	Staff Scheduling	117
	Maximizing Income	119
	Portfolio of Securities	122
	Engineering Design	123
	Troubleshooting Solver	125
	General Excel Error Messages	125
	Solver Dialog Box Error Messages	126
	General Troubleshooting Tips