Synopses & Reviews
Master the analysis and business modeling techniques that help you transform your data into bottom-line results. Award-winning business professor and corporate consultant Wayne Winston shares the best of his real-world experience in this practical guidenow updated for Excel 2007. Use Waynes proven practices and hands-on exercises to help you work smarter, make better decisions, and gain the competitive edge.
Solve real-world business problems with Excel 2007!
- Maximize profitsdetermine NPV, optimize your product mix, calculate ROI
- Create best, worst, and most-likely case scenarios for sales
- Analyze investment performance and help minimize risk
- Track your personal finances, calculate loan terms, and plan for retirement
- Use trend and seasonality to forecast revenue
- Estimate a products demand curve and manage inventory with precision Interpret the effects of price and advertising on sales
- Assign a dollar value to customer loyalty
- Solve work scheduling problems and shorten wait times for customer service queues
- PLUSpredict outcomes of sporting events, presidential elections, and more!
CD Includes:
- Sample files from each chapter
- Problem-and-solution setsbuild your expertise!
- Fully searchable eBook
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via OReilly Medias Digital Distribution services. To download this content, please visit OReillys web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Synopsis
Master the business modeling and analysis techniques that help you transform data into bottom-line results. Award-winning business professor and corporate consultant Wayne Winston shares the best of his real-world experience in this practical, scenario-focused guidefully updated for Excel 2010. Use Waynes proven practices and hands-on examples to help you work smarter, make better decisions, and gain the competitive edge.
Synopsis
Customer Service Note: We are sorry for the inconvenience, but the voucher with the online access code is missing from the first printing of this title. However, we do have the code, available upon request. Please contact O'Reilly Media Customer Service at mspbooksupport@oreilly.com or call 800-889-8969 to obtain your 24-character access code. This code will give you access to your online edition of this Microsoft Press book that is hosted on Safari Books Online! Once you have obtained your unique access code: Go to http://microsoftpress.oreilly.com/safarienabled and enter your unique 24-character access code, including the hyphens. Set up your free Safari account (required), following the instructions on-screen. Enjoy unlimited access to your online edition of the Web! PLEASE NOTE: Each access code may only be redeemed once. Again, for assistance, please contact O'Reilly Media Customer Service at mspbooksupport@oreilly.com or call 800-889-8969 or 707-827-7019.
Master the business modeling and analysis techniques that help you transform data into bottom-line results. Award-winning business professor and corporate consultant Wayne Winston shares the best of his real-world experience in this practical, scenario-focused guide—fully updated for Excel 2010. Use Waynes proven practices and hands-on examples to help you work smarter, make better decisions, and gain the competitive edge.
Synopsis
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!
- Model investment risks and returns
- Analyze your sales team’s effectiveness
- Create best, worst, and most-likely case scenarios
- Compare lease vs. buy, and calculate loan terms
- See how price, advertising, and seasonality affect sales
- Manage inventory with precision
- Quantify the value of customer loyalty
- Calculate your break-even number and ROI
- Maximize scheduling efficiency
- Express “home-field advantage” in real numbers
- Project company growth, predict election results, and more!
- Plus—introduce yourself to PowerPivot for Excel
Your companion web content includes:
- Downloadable eBook
- Hundreds of scenario-based practice problems
- All the book’s sample files—plus customizable templates
About the Author
Wayne L. Winston is a professor of Decision Sciences at Indiana University's Kelley School of Business and has earned numerous MBA teaching awards. For 20+ years, he has taught clients at Fortune 500 companies how to use Excel to make smarter business decisions. Wayne and his business partner Jeff Sagarin developed the player-statistics tracking and rating system used by the Dallas Mavericks professional basketball team. He is also a two time Jeopardy! Champion.
Table of Contents
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: Whats 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 Chapters Questions; 2.3 Problems; Chapter 3: Lookup Functions; 3.1 Syntax of the Lookup Functions; 3.2 Answers to This Chapters Questions; 3.3 Problems; Chapter 4: The INDEX Function; 4.1 Syntax of the INDEX Function; 4.2 Answers to This Chapters Questions; 4.3 Problems; Chapter 5: The MATCH Function; 5.1 Answers to This Chapters Questions; 5.2 Problems; Chapter 6: Text Functions; 6.1 Text Function Syntax; 6.2 Answers to This Chapters Questions; 6.3 Problems; Chapter 7: Dates and Date Functions; 7.1 Answers to This Chapters Questions; 7.2 Problems; Chapter 8: Evaluating Investments by Using Net Present Value Criteria; 8.1 Answers to This Chapters Questions; 8.2 Problems; Chapter 9: Internal Rate of Return; 9.1 Answers to This Chapters Questions; 9.2 Problems; Chapter 10: More Excel Financial Functions; 10.1 Answers to This Chapters Questions; 10.2 Problems; Chapter 11: Circular References; 11.1 Answers to This Chapters Questions; 11.2 Problems; Chapter 12: IF Statements; 12.1 Answers to This Chapters Questions; 12.2 Problems; Chapter 13: Time and Time Functions; 13.1 Answers to This Chapters Questions; 13.2 Problems; Chapter 14: The Paste Special Command; 14.1 Answers to This Chapters Questions; 14.2 Problems; Chapter 15: Three-Dimensional Formulas; 15.1 Answers to This Chapters Questions; Chapter 16: The Auditing Tool; 16.1 Answers to This Chapters Questions; 16.2 Problems; Chapter 17: Sensitivity Analysis with Data Tables; 17.1 Answers to This Chapters Questions; 17.2 Problems; Chapter 18: The Goal Seek Command; 18.1 Answers to This Chapters Questions; 18.2 Problems; Chapter 19: Using the Scenario Manager for Sensitivity Analysis; 19.1 Answer to This Chapters Question; 19.2 Problems; Chapter 20: The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions; 20.1 Answers to This Chapters Questions; 20.2 Problems; Chapter 21: The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions; 21.1 Answers to This Chapters Questions; 21.2 Problems; Chapter 22: The OFFSET Function; 22.1 Answers to This Chapters Questions; 22.2 Problems; Chapter 23: The INDIRECT Function; 23.1 Answers to This Chapters Questions; 23.2 Problems; Chapter 24: Conditional Formatting; 24.1 Answers to This Chapters Questions; 24.2 Problems; Chapter 25: Sorting in Excel; 25.1 Answers to This Chapters Questions; 25.2 Problems; Chapter 26: Tables; 26.1 Answers to This Chapters 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 Chapters 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 Chapters Questions; 29.2 Problems; Chapter 30: Using Solver to Schedule Your Workforce; 30.1 Answers to This Chapters Question; 30.2 Problems; Chapter 31: Using Solver to Solve Transportation or Distribution Problems; 31.1 Answer to This Chapters Question; 31.2 Problems; Chapter 32: Using Solver for Capital Budgeting; 32.1 Answer to This Chapters Question; 32.2 Problems; Chapter 33: Using Solver for Financial Planning; 33.1 Answers to This Chapters Questions; 33.2 Problems; Chapter 34: Using Solver to Rate Sports Teams; 34.1 Answer to This Chapters 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 Chapters Questions; 35.3 Problems; Chapter 36: Penalties and the Evolutionary Solver; 36.1 Answers to This Chapters Questions; 36.2 Problems; Chapter 37: The Traveling Salesperson Problem; 37.1 Answers to This Chapters Questions; 37.2 Problems; Chapter 38: Importing Data from a Text File or Document; 38.1 Answers to This Chapters Question; 38.2 Problems; Chapter 39: Importing Data from the Internet; 39.1 Answers to This Chapters Questions; 39.2 Problems; Chapter 40: Validating Data; 40.1 Answers to This Chapters Questions; 40.2 Problems; Chapter 41: Summarizing Data by Using Histograms; 41.1 Answers to This Chapters Questions; 41.2 Prooooooblems; Chapter 42: Summarizing Data by Using Descriptive Statistics; 42.1 Answers to This Chapters Questions; 42.2 Problems; Chapter 43: Using PivotTables and Slicers to Describe Data; 43.1 Answers to This Chapters Questions; 43.2 Problems; Chapter 44: Sparklines; 44.1 Answers to This Chapters Questions; 44.2 Problems; Chapter 45: Summarizing Data with Database Statistical Functions; 45.1 Answers to This Chapters Questions; 45.2 Problems; Chapter 46: Filtering Data and Removing Duplicates; 46.1 Answers to This Chapters Questions; 46.2 Problems; Chapter 47: Consolidating Data; 47.1 Answer to This Chapters Question; 47.2 Problems; Chapter 48: Creating Subtotals; 48.1 Answers to This Chapters Questions; 48.2 Problems; Chapter 49: Estimating Straight Line Relationships; 49.1 Answers to This Chapters Questions; 49.2 Problems; Chapter 50: Modeling Exponential Growth; 50.1 Answers to This Chapters Question; 50.2 Problems; Chapter 51: The Power Curve; 51.1 Answer to This Chapters Question; 51.2 Problems; Chapter 52: Using Correlations to Summarize Relationships; 52.1 Answer to This Chapters Question; 52.2 Problems; Chapter 53: Introduction to Multiple Regression; 53.1 Answers to This Chapters Questions; Chapter 54: Incorporating Qualitative Factors into Multiple Regression; 54.1 Answers to This Chapters Questions; Chapter 55: Modeling Nonlinearities and Interactions; 55.1 Answers to This Chapters Questions; 55.2 Problems for Through; Chapter 56: Analysis of Variance: One-Way ANOVA; 56.1 Answers to This Chapters Questions; 56.2 Problems; Chapter 57: Randomized Blocks and Two-Way ANOVA; 57.1 Answers to This Chapters Questions; 57.2 Problems; Chapter 58: Using Moving Averages to Understand Time Series; 58.1 Answers to This Chapters Question; 58.2 Problem; Chapter 59: Winterss Method; 59.1 Time Series Characteristics; 59.2 Parameter Definitions; 59.3 Initializing Winterss 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 Chapters Questions; 60.2 Problem; Chapter 61: Forecasting in the Presence of Special Events; 61.1 Answers to This Chapters Questions; 61.2 Problems; Chapter 62: An Introduction to Random Variables; 62.1 Answers to This Chapters Questions; 62.2 Problems; Chapter 63: The Binomial, Hypergeometric, and Negative Binomial Random Variables; 63.1 Answers to This Chapters Questions; 63.2 Problems; Chapter 64: The Poisson and Exponential Random Variable; 64.1 Answers to This Chapters Questions; 64.2 Problems; Chapter 65: The Normal Random Variable; 65.1 Answers to This Chapters Questions; 65.2 Problems; Chapter 66: Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project; 66.1 Answers to This Chapters Questions; 66.2 Problems; Chapter 67: Making Probability Statements from Forecasts; 67.1 Answers to This Chapters Questions; 67.2 Problems; Chapter 68: Using the Lognormal Random Variable to Model Stock Prices; 68.1 Answers to This Chapters Questions; 68.2 Problems; Chapter 69: Introduction to Monte Carlo Simulation; 69.1 Answers to This Chapters Questions; 69.2 Problems; Chapter 70: Calculating an Optimal Bid; 70.1 Answers to This Chapters Questions; 70.2 Problems; Chapter 71: Simulating Stock Prices and Asset Allocation Modeling; 71.1 Answers to This Chapters Questions; 71.2 Problems; Chapter 72: Fun and Games: Simulating Gambling and Sporting Event Probabilities; 72.1 Answers to This Chapters Questions; 72.2 Problems; Chapter 73: Using Resampling to Analyze Data; 73.1 Answer to This Chapters Question; 73.2 Problems; Chapter 74: Pricing Stock Options; 74.1 Answers to This Chapters Questions; 74.2 Problems; Chapter 75: Determining Customer Value; 75.1 Answers to This Chapters Questions; 75.2 Problems; Chapter 76: The Economic Order Quantity Inventory Model; 76.1 Answers to This Chapters Questions; 76.2 Problems; Chapter 77: Inventory Modeling with Uncertain Demand; 77.1 Answers to This Chapters Questions; 77.2 Problems; Chapter 78: Queuing Theory: The Mathematics of Waiting in Line; 78.1 Answers to This Chapters Questions; 78.2 Problems; Chapter 79: Estimating a Demand Curve; 79.1 Answers to This Chapters Questions; 79.2 Problems; Chapter 80: Pricing Products by Using Tie-Ins; 80.1 Answer to This Chapters Question; 80.2 Problems; Chapter 81: Pricing Products by Using Subjectively Determined Demand; 81.1 Answer to This Chapters Questions; 81.2 Problems; Chapter 82: Nonlinear Pricing; 82.1 Answers to This Chapters Questions; 82.2 Problems; Chapter 83: Array Formulas and Functions; 83.1 Answers to This Chapters Questions; 83.2 Problems; Chapter 84: PowerPivot; 84.1 Answers to This Chapters Questions; About the Author;