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

## Publisher resources

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