- Shopping Bag ( 0 items )
Want a NOOK? Explore Now
Master the business modeling and analysis techniques that help you transform data into bottom-line results. For more than a decade, Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Excel to solve business problems and make better decisions. Now this award-winning educator shares the best of his expertise in this hands-on, scenario-focused guide—fully updated for Excel 2010!
Use Excel to solve real business problems—and sharpen your edge!
Introduction; What You Should Know Before Reading This Book; How to Use This Book; Using the Companion Content; How to Access Your Online Edition Hosted by Safari; How to Download the Online Edition to Your Computer; Errata and Book Support; We Want to Hear from You; Stay in Touch; Acknowledgments; Chapter 1: What’s New in Excel 2010; 1.1 Customizable Ribbon; 1.2 Sparklines; 1.3 Slicers; 1.4 PowerPivot; 1.5 New Excel Solver; 1.6 File Tab; 1.7 New Excel Functions; 1.8 New Equation Editor; 1.9 Improved Data Bars; 1.10 Paste Special Live Preview; Chapter 2: Range Names; 2.1 How Can I Create Named Ranges?; 2.2 Answers to This Chapter’s Questions; 2.3 Problems; Chapter 3: Lookup Functions; 3.1 Syntax of the Lookup Functions; 3.2 Answers to This Chapter’s Questions; 3.3 Problems; Chapter 4: The INDEX Function; 4.1 Syntax of the INDEX Function; 4.2 Answers to This Chapter’s Questions; 4.3 Problems; Chapter 5: The MATCH Function; 5.1 Answers to This Chapter’s Questions; 5.2 Problems; Chapter 6: Text Functions; 6.1 Text Function Syntax; 6.2 Answers to This Chapter’s Questions; 6.3 Problems; Chapter 7: Dates and Date Functions; 7.1 Answers to This Chapter’s Questions; 7.2 Problems; Chapter 8: Evaluating Investments by Using Net Present Value Criteria; 8.1 Answers to This Chapter’s Questions; 8.2 Problems; Chapter 9: Internal Rate of Return; 9.1 Answers to This Chapter’s Questions; 9.2 Problems; Chapter 10: More Excel Financial Functions; 10.1 Answers to This Chapter’s Questions; 10.2 Problems; Chapter 11: Circular References; 11.1 Answers to This Chapter’s Questions; 11.2 Problems; Chapter 12: IF Statements; 12.1 Answers to This Chapter’s Questions; 12.2 Problems; Chapter 13: Time and Time Functions; 13.1 Answers to This Chapter’s Questions; 13.2 Problems; Chapter 14: The Paste Special Command; 14.1 Answers to This Chapter’s Questions; 14.2 Problems; Chapter 15: Three-Dimensional Formulas; 15.1 Answers to This Chapter’s Questions; Chapter 16: The Auditing Tool; 16.1 Answers to This Chapter’s Questions; 16.2 Problems; Chapter 17: Sensitivity Analysis with Data Tables; 17.1 Answers to This Chapter’s Questions; 17.2 Problems; Chapter 18: The Goal Seek Command; 18.1 Answers to This Chapter’s Questions; 18.2 Problems; Chapter 19: Using the Scenario Manager for Sensitivity Analysis; 19.1 Answer to This Chapter’s Question; 19.2 Problems; Chapter 20: The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions; 20.1 Answers to This Chapter’s Questions; 20.2 Problems; Chapter 21: The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions; 21.1 Answers to This Chapter’s Questions; 21.2 Problems; Chapter 22: The OFFSET Function; 22.1 Answers to This Chapter’s Questions; 22.2 Problems; Chapter 23: The INDIRECT Function; 23.1 Answers to This Chapter’s Questions; 23.2 Problems; Chapter 24: Conditional Formatting; 24.1 Answers to This Chapter’s Questions; 24.2 Problems; Chapter 25: Sorting in Excel; 25.1 Answers to This Chapter’s Questions; 25.2 Problems; Chapter 26: Tables; 26.1 Answers to This Chapter’s Questions; 26.2 Problems; Chapter 27: Spin Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes, and Group List Boxes; 27.1 Answers to This Chapter’s Questions; 27.2 Problems; Chapter 28: An Introduction to Optimization with Excel Solver; 28.1 Problems; Chapter 29: Using Solver to Determine the Optimal Product Mix; 29.1 Answers to This Chapter’s Questions; 29.2 Problems; Chapter 30: Using Solver to Schedule Your Workforce; 30.1 Answers to This Chapter’s Question; 30.2 Problems; Chapter 31: Using Solver to Solve Transportation or Distribution Problems; 31.1 Answer to This Chapter’s Question; 31.2 Problems; Chapter 32: Using Solver for Capital Budgeting; 32.1 Answer to This Chapter’s Question; 32.2 Problems; Chapter 33: Using Solver for Financial Planning; 33.1 Answers to This Chapter’s Questions; 33.2 Problems; Chapter 34: Using Solver to Rate Sports Teams; 34.1 Answer to This Chapter’s Question; 34.2 Problems; Chapter 35: Warehouse Location and the GRG Multistart and Evolutionary Solver Engines; 35.1 Understanding the GRG Multistart and Evolutionary Solver Engines; 35.2 Answer to This Chapter’s Questions; 35.3 Problems; Chapter 36: Penalties and the Evolutionary Solver; 36.1 Answers to This Chapter’s Questions; 36.2 Problems; Chapter 37: The Traveling Salesperson Problem; 37.1 Answers to This Chapter’s Questions; 37.2 Problems; Chapter 38: Importing Data from a Text File or Document; 38.1 Answers to This Chapter’s Question; 38.2 Problems; Chapter 39: Importing Data from the Internet; 39.1 Answers to This Chapter’s Questions; 39.2 Problems; Chapter 40: Validating Data; 40.1 Answers to This Chapter’s Questions; 40.2 Problems; Chapter 41: Summarizing Data by Using Histograms; 41.1 Answers to This Chapter’s Questions; 41.2 Prooooooblems; Chapter 42: Summarizing Data by Using Descriptive Statistics; 42.1 Answers to This Chapter’s Questions; 42.2 Problems; Chapter 43: Using PivotTables and Slicers to Describe Data; 43.1 Answers to This Chapter’s Questions; 43.2 Problems; Chapter 44: Sparklines; 44.1 Answers to This Chapter’s Questions; 44.2 Problems; Chapter 45: Summarizing Data with Database Statistical Functions; 45.1 Answers to This Chapter’s Questions; 45.2 Problems; Chapter 46: Filtering Data and Removing Duplicates; 46.1 Answers to This Chapter’s Questions; 46.2 Problems; Chapter 47: Consolidating Data; 47.1 Answer to This Chapter’s Question; 47.2 Problems; Chapter 48: Creating Subtotals; 48.1 Answers to This Chapter’s Questions; 48.2 Problems; Chapter 49: Estimating Straight Line Relationships; 49.1 Answers to This Chapter’s Questions; 49.2 Problems; Chapter 50: Modeling Exponential Growth; 50.1 Answers to This Chapter’s Question; 50.2 Problems; Chapter 51: The Power Curve; 51.1 Answer to This Chapter’s Question; 51.2 Problems; Chapter 52: Using Correlations to Summarize Relationships; 52.1 Answer to This Chapter’s Question; 52.2 Problems; Chapter 53: Introduction to Multiple Regression; 53.1 Answers to This Chapter’s Questions; Chapter 54: Incorporating Qualitative Factors into Multiple Regression; 54.1 Answers to This Chapter’s Questions; Chapter 55: Modeling Nonlinearities and Interactions; 55.1 Answers to This Chapter’s Questions; 55.2 Problems for Through; Chapter 56: Analysis of Variance: One-Way ANOVA; 56.1 Answers to This Chapter’s Questions; 56.2 Problems; Chapter 57: Randomized Blocks and Two-Way ANOVA; 57.1 Answers to This Chapter’s Questions; 57.2 Problems; Chapter 58: Using Moving Averages to Understand Time Series; 58.1 Answers to This Chapter’s Question; 58.2 Problem; Chapter 59: Winters’s Method; 59.1 Time Series Characteristics; 59.2 Parameter Definitions; 59.3 Initializing Winters’s Method; 59.4 Estimating the Smoothing Constants; 59.5 Remarks; 59.6 Problems; Chapter 60: Ratio-to-Moving-Average Forecast Method; 60.1 Answers to This Chapter’s Questions; 60.2 Problem; Chapter 61: Forecasting in the Presence of Special Events; 61.1 Answers to This Chapter’s Questions; 61.2 Problems; Chapter 62: An Introduction to Random Variables; 62.1 Answers to This Chapter’s Questions; 62.2 Problems; Chapter 63: The Binomial, Hypergeometric, and Negative Binomial Random Variables; 63.1 Answers to This Chapter’s Questions; 63.2 Problems; Chapter 64: The Poisson and Exponential Random Variable; 64.1 Answers to This Chapter’s Questions; 64.2 Problems; Chapter 65: The Normal Random Variable; 65.1 Answers to This Chapter’s Questions; 65.2 Problems; Chapter 66: Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project; 66.1 Answers to This Chapter’s Questions; 66.2 Problems; Chapter 67: Making Probability Statements from Forecasts; 67.1 Answers to This Chapter’s Questions; 67.2 Problems; Chapter 68: Using the Lognormal Random Variable to Model Stock Prices; 68.1 Answers to This Chapter’s Questions; 68.2 Problems; Chapter 69: Introduction to Monte Carlo Simulation; 69.1 Answers to This Chapter’s Questions; 69.2 Problems; Chapter 70: Calculating an Optimal Bid; 70.1 Answers to This Chapter’s Questions; 70.2 Problems; Chapter 71: Simulating Stock Prices and Asset Allocation Modeling; 71.1 Answers to This Chapter’s Questions; 71.2 Problems; Chapter 72: Fun and Games: Simulating Gambling and Sporting Event Probabilities; 72.1 Answers to This Chapter’s Questions; 72.2 Problems; Chapter 73: Using Resampling to Analyze Data; 73.1 Answer to This Chapter’s Question; 73.2 Problems; Chapter 74: Pricing Stock Options; 74.1 Answers to This Chapter’s Questions; 74.2 Problems; Chapter 75: Determining Customer Value; 75.1 Answers to This Chapter’s Questions; 75.2 Problems; Chapter 76: The Economic Order Quantity Inventory Model; 76.1 Answers to This Chapter’s Questions; 76.2 Problems; Chapter 77: Inventory Modeling with Uncertain Demand; 77.1 Answers to This Chapter’s Questions; 77.2 Problems; Chapter 78: Queuing Theory: The Mathematics of Waiting in Line; 78.1 Answers to This Chapter’s Questions; 78.2 Problems; Chapter 79: Estimating a Demand Curve; 79.1 Answers to This Chapter’s Questions; 79.2 Problems; Chapter 80: Pricing Products by Using Tie-Ins; 80.1 Answer to This Chapter’s Question; 80.2 Problems; Chapter 81: Pricing Products by Using Subjectively Determined Demand; 81.1 Answer to This Chapter’s Questions; 81.2 Problems; Chapter 82: Nonlinear Pricing; 82.1 Answers to This Chapter’s Questions; 82.2 Problems; Chapter 83: Array Formulas and Functions; 83.1 Answers to This Chapter’s Questions; 83.2 Problems; Chapter 84: PowerPivot; 84.1 Answers to This Chapter’s Questions; About the Author;
Wayne L. Winston is a professor of Decision Sciences at Indiana University’s Kelley School of Business and the recipient of more than 30 teaching awards. For the past 20 years, Wayne has also taught Fortune 500 companies how to use Excel to make smarter business decisions. He has written 15 books on Excel, management science, and mathematics in sports.
Anonymous
Posted March 29, 2011
Illustrations of computer screens are impossible to read. The book is too large for reasonable access on the Nook. Nook drops back to opening screen while trying to read the book. Reference materials such as this are poor candidates for the Nook. I ordered it for the Nook by mistake and B&N wouldn't let me cancel the order. I had to buy a second copy to get the hard-copy book. I can't comment on the contents of the book until I get the hard-copy.
1 out of 1 people found this review helpful.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.Jchang
Posted May 25, 2012
I thought this book was fantastic! It shows you exactly how to do about a 100 different business/stock market/probability models you can do in Excel. This book is for beginners. However, if you have NO working knowledge of excel I recommend learning up at least a little bit before buying this book. Go on youtube for some of the basics then you can have a crack at this!
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
Master the business modeling and analysis techniques that help you transform data into bottom-line results. For more than a decade, Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Excel to solve business problems and make better decisions. Now this award-winning educator shares the best of his expertise in this hands-on, ...