Microsoft Excel 2010: Data Analysis and Business Modeling - Brossura

Winston, Wayne L.

Brossura

ISBN 10: 0735643369 ISBN 13: 9780735643369

Casa editrice: Microsoft Pr, 2011

Riassunto

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

Customer Service Note: We are sorry for the inconvenience, but the code for accessing the eBook version of this title was accidentally left out of the first printing. However, the code is available for buyers of the first printing by contacting O'Reilly Media, the official distributor for Microsoft Press books, at mspbooksupport@oreilly.com or 800-889-8969. All subsequent printings include the access code and instructions inside the book.

Su questo libro

L'autore

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.

Contenuti

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 Probl...

Dettagli dell?edizione

• Editore: Microsoft Pr
• Data di pubblicazione: 2011
• ISBN 10: 0735643369
• ISBN 13: 9780735643369
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero edizione: 1
• Numero di pagine: 700