- r-edaab.pdf
16 The Auditing Tool 121
17 Sensitivity Analysis with Data Tables 127
18 The Goal Seek Command . 137
19 Using the Scenario Manager for Sensitivity Analysis 143
20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and
COUNTBLANK Functions 149
21 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS
Functions . 157
22 The OFFSET Function . 163
23 The INDIRECT Function . 177
24 Conditional Formatting . 185
25 Sorting in Excel 209
26 Tables . 217
27 Spin Buttons, Scroll Bars, Option Buttons, Check Boxes,
Combo Boxes, and Group List Boxes 229
28 An Introduction to Optimization with Excel Solver 241
29 Using Solver to Determine the Optimal Product Mix 245
30 Using Solver to Schedule Your Workforce . 255
31 Using Solver to Solve Transportation or Distribution
Problems . 261
32 Using Solver for Capital Budgeting . 267
33 Using Solver for Financial Planning . 275
34 Using Solver to Rate Sports Teams 281
本书使用Excel软件介绍了各种商业模型,包括蒙特卡洛模拟等高级应用,对于学习Excel 和商业模型都非常有用。