【图书简介】 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 guideupdated and expanded for Excel 2007. Each chapter advances your data analysis and modeling expertise using real-world examples and learn-by-doing exercises. Youll learn how to create best， worst， and most-likely scenarios for sales， estimate a products demand curve， forecast using trend and seasonality， and determine which product mix will yield the greatest profit. Youll even discover how to interpret the effects of price and advertising on sales and how to assign a dollar value to customer loyalty. You get all the books problem-and-solution files on CDfor all the practice you need to solve complex problems and work smarter with Excel.
【本书目录】 Preface Introduction 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 CO.IF. 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 …… Index
【图书简介】
【购买本书】
