Tips & Tricks for Excel-Based Financial Modeling, Volume II

Index

ActiveX controls, 12, 27, 105

ampersand (&), 8

bubble chart, 80–81

Button (Form Control), 15–16

CAPEX (Capital Expenditure), 52–55

cash flow, 44–49

consolidated, 47–48

Data Table function on, 53

to illustrate Scenario Manager, 60

using Goal Seek, 51–52

chart(s)

bubble, 80–81

dynamic, 81–88

guidelines, 77–80

interactive, 105–107

multivariable, 101–105

scatter, 107–112

spider, 100–101

tornado, 95–100

waterfall, 88–95

Check Box (Form Control), 18–21

Combo Box (Form Control), 17–18

CONSOLIDATE function, 44–49

according to position, 44–47

into existing template, 47–48

using formula, 48–49

control(s)

ActiveX, 27

Form Control, 12–27

CORREL function, 108–109

correlating variables, 107–112

creating

dependent dropdown list, 3–12

dynamic chart,