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