# 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

hi

i am using ms excel from last five years, i used ms excel 1997, 2003, xp, 2007. it is good material which helped me a lot for learning new things and making my vision broad.

thanks