Microsoft Excel 2010: Data Analysis and Business Modeling, 3rd Edition

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 Wayne’s proven practices and hands-on examples to help you work smarter, make better decisions, and gain the competitive edge.

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

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.

Book Details

• Paperback: 720 pages
• Publisher: Microsoft Press; Third Edition (January, 2011)
• Language: English
• ISBN-10: 0735643369
• ISBN-13: 978-0735643369