## Book Description

Master the techniques that business analysts at leading companies use to transform data into bottom-line results. For more than a decade, well-known consultant and business professor Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Microsoft Office Excel for data analysis, modeling, and decision making. Now this award-winning educator shares the best of his classroom experience in this practical, business-focused guide—updated and expanded for Excel 2007. Each chapter advances your data analysis and modeling expertise using real-world examples and learn-by-doing exercises. You’ll learn how to create best, worst, and most-likely scenarios for sales, estimate a product’s demand curve, forecast using trend and seasonality, and determine which product mix will yield the greatest profit. You’ll even discover how to interpret the effects of price and advertising on sales and how to assign a dollar value to customer loyalty.

## Table of Contents

- Microsoft® Office Excel® 2007: Data Analysis and Business Modeling
- A Note Regarding Supplemental Files
- Preface
- Introduction to Excel 2007: What’s New?
- 1. Range Names
- 2. Lookup Functions
- 3. The INDEX Function
- 4. The MATCH Function
- 5. Text Functions
- 6. Dates and Date Functions
- 7. Evaluating Investments by Using Net Present Value Criteria
- 8. Internal Rate of Return
- 9. More Excel Financial Functions
- 10. Circular References
- 11. IF Statements
- 12. Time and Time Functions
- 13. The Paste Special Command
- 14. The Auditing Tool
- 15. Sensitivity Analysis with Data Tables
- 16. The Goal Seek Command
- 17. Using the Scenario Manager for Sensitivity Analysis
- 18. The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions
- 19. The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions
- 20. The OFFSET Function
- 21. The INDIRECT Function
- 22. Conditional Formatting
- 23. Sorting in Excel
- 24. Tables
- 25. Spin Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes, and Group List Boxes
- 26. An Introduction to Optimization with Excel Solver
- 27. Using Solver to Determine the Optimal Product Mix
- 28. Using Solver to Schedule Your Workforce
- 29. Using Solver to Solve Transportation or Distribution Problems
- 30. Using Solver for Capital Budgeting
- 31. Using Solver for Financial Planning
- 32. Using Solver to Rate Sports Teams
- 33. Importing Data from a Text File or Document
- 34. Importing Data from the Internet
- 35. Validating Data
- 36. Summarizing Data by Using Histograms
- 37. Summarizing Data by Using Descriptive Statistics
- 38. Using PivotTables to Describe Data
- 39. Summarizing Data with Database Statistical Functions
- 40. Filtering Data and Removing Duplicates
- 41. Consolidating Data
- 42. Creating Subtotals
- 43. Estimating Straight Line Relationships
- 44. Modeling Exponential Growth
- 45. The Power Curve
- 46. Using Correlations to Summarize Relationships
- 47. Introduction to Multiple Regression
- 48. Incorporating Qualitative Factors into Multiple Regression
- 49. Modeling Nonlinearities and Interactions
- 50. Analysis of Variance: One-Way ANOVA
- 51. Randomized Blocks and Two-Way ANOVA
- 52. Using Moving Averages to Understand Time Series
- 53. Winter’s Method
- 54. Forecasting in the Presence of Special Events
- 55. An Introduction to Random Variables
- 56. The Binomial, Hypergeometric, and Negative Binomial Random Variables
- 57. The Poisson and Exponential Random Variable
- 58. The Normal Random Variable
- 59. Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project
- 60. Introduction to Monte Carlo Simulation
- 61. Calculating an Optimal Bid
- 62. Simulating Stock Prices and Asset Allocation Modeling
- 63. Fun and Games: Simulating Gambling and Sporting Event Probabilities
- 64. Using Resampling to Analyze Data
- 65. Pricing Stock Options
- 66. Determining Customer Value
- 67. The Economic Order Quantity Inventory Model
- 68. Inventory Modeling with Uncertain Demand
- 69. Queuing Theory: The Mathematics of Waiting in Line
- 70. Estimating a Demand Curve
- 71. Pricing Products by Using Tie-Ins
- 72. Pricing Products by Using Subjectively Determined Demand
- 73. Nonlinear Pricing
- 74. Array Formulas and Functions
- A. About the Author
- Index
- About the Author
- Copyright

## Product Information

- Title: Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition
- Author(s):
- Release date: May 2007
- Publisher(s): Microsoft Press
- ISBN: 9780735623965