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 |
