| |
| |
| Preface | |
| |
| |
| Introduction to Excel 2007: What's New? | |
| |
| |
| |
| Range Names | |
| |
| |
| |
| Lookup Functions | |
| |
| |
| |
| The INDEX Function | |
| |
| |
| |
| The MATCH Function | |
| |
| |
| |
| Text Functions | |
| |
| |
| |
| Dates and Date Functions | |
| |
| |
| |
| Evaluating Investments by Using Net Present Value Criteria | |
| |
| |
| |
| Internal Rate of Return | |
| |
| |
| |
| More Excel Financial Functions | |
| |
| |
| |
| Circular References | |
| |
| |
| |
| IF Statements | |
| |
| |
| |
| Time and Time Functions | |
| |
| |
| |
| The Paste Special Command | |
| |
| |
| |
| The Auditing Tool | |
| |
| |
| |
| Sensitivity Analysis with Data Tables | |
| |
| |
| |
| The Goal Seek Command | |
| |
| |
| |
| Using the Scenario Manager for Sensitivity Analysis | |
| |
| |
| |
| The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions | |
| |
| |
| |
| The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions | |
| |
| |
| |
| The OFFSET Function | |
| |
| |
| |
| The INDIRECT Function | |
| |
| |
| |
| Conditional Formatting | |
| |
| |
| |
| Sorting in Excel | |
| |
| |
| |
| Tables | |
| |
| |
| |
| Spin Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes, and Group List Boxes | |
| |
| |
| |
| An Introduction to Optimization with Excel Solver | |
| |
| |
| |
| Using Solver to Determine the Optimal Product Mix | |
| |
| |
| |
| Using Solver to Schedule Your Workforce | |
| |
| |
| |
| Using Solver to Solve Transportation or Distribution Problems | |
| |
| |
| |
| Using Solver for Capital Budgeting | |
| |
| |
| |
| Using Solver for Financial Planning | |
| |
| |
| |
| Using Solver to Rate Sports Teams | |
| |
| |
| |
| Importing Data from a Text File or Document | |
| |
| |
| |
| Importing Data from the Internet | |
| |
| |
| |
| Validating Data | |
| |
| |
| |
| Summarizing Data by Using Histograms | |
| |
| |
| |
| Summarizing Data by Using Descriptive Statistics | |
| |
| |
| |
| Using PivotTables to Describe Data | |
| |
| |
| |
| Summarizing Data with Database Statistical Functions | |
| |
| |
| |
| Filtering Data and Removing Duplicates | |
| |
| |
| |
| Consolidating Data | |
| |
| |
| |
| Creating Subtotals | |
| |
| |
| |
| Estimating Straight Line Relationships | |
| |
| |
| |
| Modeling Exponential Growth | |
| |
| |
| |
| The Power Curve | |
| |
| |
| |
| Using Correlations to Summarize Relationships | |
| |
| |
| |
| Introduction to Multiple Regression | |
| |
| |
| |
| Incorporating Qualitative Factors into Multiple Regression | |
| |
| |
| |
| Modeling Nonlinearities and Interactions | |
| |
| |
| |
| Analysis of Variance: One-Way ANOVA | |
| |
| |
| |
| Randomized Blocks and Two-Way ANOVA | |
| |
| |
| |
| Using Moving Averages to Understand Time Series | |
| |
| |
| |
| Winter's Method | |
| |
| |
| |
| Forecasting in the Presence of Special Events | |
| |
| |
| |
| An Introduction to Random Variables | |
| |
| |
| |
| The Binomial, Hypergeometric, and Negative Binomial Random Variables | |
| |
| |
| |
| The Poisson and Exponential Random Variable | |
| |
| |
| |
| The Normal Random Variable | |
| |
| |
| |
| Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project | |
| |
| |
| |
| Introduction to Monte Carlo Simulation | |
| |
| |
| |
| Calculating an Optimal Bid | |
| |
| |
| |
| Simulating Stock Prices and Asset Allocation Modeling | |
| |
| |
| |
| Fun and Games: Simulating Gambling and Sporting Event Probabilities | |
| |
| |
| |
| Using Resampling to Analyze Data | |
| |
| |
| |
| Pricing Stock Options | |
| |
| |
| |
| Determining Customer Value | |
| |
| |
| |
| The Economic Order Quantity Inventory Model | |
| |
| |
| |
| Inventory Modeling with Uncertain Demand | |
| |
| |
| |
| Queuing Theory: The Mathematics of Waiting in Line | |
| |
| |
| |
| Estimating a Demand Curve | |
| |
| |
| |
| Pricing Products by Using Tie-Ins | |
| |
| |
| |
| Pricing Products by Using Subjectively Determined Demand | |
| |
| |
| |
| Nonlinear Pricing | |
| |
| |
| |
| Array Formulas and Functions | |
| |
| |
| About the Author | |