| Introduction |
|
ix | |
|
1 What's New in Excel 2010 |
|
|
1 | (8) |
|
|
|
9 | (12) |
|
|
|
21 | (8) |
|
|
|
29 | (4) |
|
|
|
33 | (6) |
|
|
|
39 | (10) |
|
7 Dates and Date Functions |
|
|
49 | (8) |
|
8 Evaluating Investments by Using Net Present Value Criteria |
|
|
57 | (6) |
|
9 Internal Rate of Return |
|
|
63 | (6) |
|
10 More Excel Financial Functions |
|
|
69 | (12) |
|
|
|
81 | (6) |
|
|
|
87 | (18) |
|
13 Time and Time Functions |
|
|
105 | (6) |
|
14 The Paste Special Command |
|
|
111 | (6) |
|
15 Three-Dimensional Formulas |
|
|
117 | (4) |
|
|
|
121 | (6) |
|
17 Sensitivity Analysis with Data Tables |
|
|
127 | (10) |
|
|
|
137 | (6) |
|
19 Using the Scenario Manager for Sensitivity Analysis |
|
|
143 | (6) |
|
20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK Functions |
|
|
149 | (8) |
|
21 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS Functions |
|
|
157 | (6) |
|
|
|
163 | (14) |
|
|
|
177 | (8) |
|
24 Conditional Formatting |
|
|
185 | (24) |
|
|
|
209 | (8) |
|
|
|
217 | (12) |
|
27 Spin Buttons, Scroll Bars, Option Buttons, Check Boxes, Combo Boxes, and Group List Boxes |
|
|
229 | (12) |
|
28 An Introduction to Optimization with Excel Solver |
|
|
241 | (4) |
|
29 Using Solver to Determine the Optimal Product Mix |
|
|
245 | (10) |
|
30 Using Solver to Schedule Your Workforce |
|
|
255 | (6) |
|
31 Using Solver to Solve Transportation or Distribution Problems |
|
|
261 | (6) |
|
32 Using Solver for Capital Budgeting |
|
|
267 | (8) |
|
33 Using Solver for Financial Planning |
|
|
275 | (6) |
|
34 Using Solver to Rate Sports Teams |
|
|
281 | (6) |
|
35 Warehouse Location and the GRG Multistart and Evolutionary Solver Engines |
|
|
287 | (10) |
|
36 Penalties and the Evolutionary Solver |
|
|
297 | (6) |
|
37 The Traveling Salesperson Problem |
|
|
303 | (4) |
|
38 Importing Data from a Text File or Document |
|
|
307 | (6) |
|
39 Importing Data from the Internet |
|
|
313 | (6) |
|
|
|
319 | (8) |
|
41 Summarizing Data by Using Histograms |
|
|
327 | (8) |
|
42 Summarizing Data by Using Descriptive Statistics |
|
|
335 | (14) |
|
43 Using PivotTables and Slicers to Describe Data |
|
|
349 | (32) |
|
|
|
381 | (6) |
|
45 Summarizing Data with Database Statistical Functions |
|
|
387 | (8) |
|
46 Filtering Data and Removing Duplicates |
|
|
395 | (16) |
|
|
|
411 | (6) |
|
|
|
417 | (6) |
|
49 Estimating Straight Line Relationships |
|
|
423 | (8) |
|
50 Modeling Exponential Growth |
|
|
431 | (4) |
|
|
|
435 | (6) |
|
52 Using Correlations to Summarize Relationships |
|
|
441 | (6) |
|
53 Introduction to Multiple Regression |
|
|
447 | (6) |
|
54 Incorporating Qualitative Factors into Multiple Regression |
|
|
453 | (10) |
|
55 Modeling Nonlinearities and Interactions |
|
|
463 | (8) |
|
56 Analysis of Variance: One-Way ANOVA |
|
|
471 | (6) |
|
57 Randomized Blocks and Two-Way ANOVA |
|
|
477 | (10) |
|
58 Using Moving Averages to Understand Time Series |
|
|
487 | (4) |
|
|
|
491 | (6) |
|
60 Ratio-to-Moving-Average Forecast Method |
|
|
497 | (4) |
|
61 Forecasting in the Presence of Special Events |
|
|
501 | (8) |
|
62 An Introduction to Random Variables |
|
|
509 | (6) |
|
63 The Binomial, Hypergeometric, and Negative Binomial Random Variables |
|
|
515 | (8) |
|
64 The Poisson and Exponential Random Variable |
|
|
523 | (4) |
|
65 The Normal Random Variable |
|
|
527 | (8) |
|
66 Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project |
|
|
535 | (6) |
|
67 Making Probability Statements from Forecasts |
|
|
541 | (4) |
|
68 Using the Lognormal Random Variable to Model Stock Prices |
|
|
545 | (4) |
|
69 Introduction to Monte Carlo Simulation |
|
|
549 | (10) |
|
70 Calculating an Optimal Bid |
|
|
559 | (6) |
|
71 Simulating Stock Prices and Asset Allocation Modeling |
|
|
565 | (10) |
|
72 Fun and Games: Simulating Gambling and Sporting Event Probabilities |
|
|
575 | (8) |
|
73 Using Resampling to Analyze Data |
|
|
583 | (4) |
|
|
|
587 | (14) |
|
75 Determining Customer Value |
|
|
601 | (6) |
|
76 The Economic Order Quantity Inventory Model |
|
|
607 | (6) |
|
77 Inventory Modeling with Uncertain Demand |
|
|
613 | (6) |
|
78 Queuing Theory: The Mathematics of Waiting in Line |
|
|
619 | (6) |
|
79 Estimating a Demand Curve |
|
|
625 | (6) |
|
80 Pricing Products by Using Tie-Ins |
|
|
631 | (4) |
|
81 Pricing Products by Using Subjectively Determined Demand |
|
|
635 | (4) |
|
|
|
639 | (8) |
|
83 Array Formulas and Functions |
|
|
647 | (18) |
|
|
|
665 | (10) |
| Index |
|
675 | |
