| |
| |
| Introduction | |
| |
| |
| |
| Range Names | |
| |
| |
| |
| Natural Language Range Names | |
| |
| |
| |
| Lookup Functions | |
| |
| |
| |
| The INDEX Function | |
| |
| |
| |
| The MATCH Function | |
| |
| |
| |
| Text Functions | |
| |
| |
| |
| Dates and Date Functions | |
| |
| |
| |
| Evaluating Investments with Net Present Value Criteria | |
| |
| |
| |
| Internal Rate of Return | |
| |
| |
| |
| Functions for Personal Financial Decisions: The PV, FV, PMT, PPMT, and IPMT Functions | |
| |
| |
| |
| Circular References | |
| |
| |
| |
| IF Statements | |
| |
| |
| |
| The Paste Special Command | |
| |
| |
| |
| The Auditing Tool | |
| |
| |
| |
| Sensitivity Analysis with Data Tables | |
| |
| |
| |
| The Goal Seek Command | |
| |
| |
| |
| Using the Scenario Manager for Sensitivity Analysis | |
| |
| |
| |
| Creating and Using Spinners for Sensitivity Analysis | |
| |
| |
| |
| The COUNTIF, COUNT, COUNTA, and COUNTBLANK Functions | |
| |
| |
| |
| The SUMIF Function | |
| |
| |
| |
| The OFFSET Function | |
| |
| |
| |
| The INDIRECT Function | |
| |
| |
| |
| Conditional Formatting | |
| |
| |
| |
| An Introduction to Optimization with the Excel Solver | |
| |
| |
| |
| Using Solver to Determine the Optimal Product Mix | |
| |
| |
| |
| Using Solver to Solve Transportation or Distribution Problems | |
| |
| |
| |
| Using Solver to Schedule Your Workforce | |
| |
| |
| |
| Using Solver for Capital Budgeting | |
| |
| |
| |
| Using Solver for Financial Planning | |
| |
| |
| |
| Using Solver to Rate Sports Teams | |
| |
| |
| |
| Importing Text or Microsoft Word Data into Excel | |
| |
| |
| |
| Importing Data from the Web into Excel | |
| |
| |
| |
| Validating Data | |
| |
| |
| |
| Summarizing Data with Histograms | |
| |
| |
| |
| Summarizing Data with Descriptive Statistics | |
| |
| |
| |
| Using PivotTables to Describe Data | |
| |
| |
| |
| Summarizing Data with Database Statistical Functions | |
| |
| |
| |
| Filtering Data | |
| |
| |
| |
| 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 | |
| |
| |
| |
| Forecasting with Moving Averages | |
| |
| |
| |
| Forecasting in the Presence of Special Events | |
| |
| |
| |
| An Introduction to Random Variables | |
| |
| |
| |
| The Binomial and Hypergeometric 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 | |
| |
| |
| |
| Determining the Reorder Point: How Low Should I Let My Inventory Level Go Before I Reorder? | |
| |
| |
| |
| Queuing Theory: The Mathematics of Waiting in Line | |
| |
| |
| |
| Estimating a Demand Curve | |
| |
| |
| |
| Pricing Products with Tie-ins | |
| |
| |
| |
| Pricing Products Using Subjectively Determined Demand | |
| |
| |
| |
| Nonlinear Pricing | |
| |
| |
| |
| Array Formulas and Functions | |
| |
| |
| |
| Picking Your Fantasy Football Team | |
| |
| |
| Index | |