Financial Modeling in Excel For Dummies, 2nd Edition

Index

Symbols and Numerics

• ###### error, 301

• & (ampersand), 277

• * (asterisk), 101

• (∑) Autosum button, 134, 135

• $ (dollar sign), 101, 106

• 32-bit Excel, 27

• 64-bit Excel, 27

A

• absolute cell reference, 101, 103–106
• accessibility, checking, 83
• accountancy qualification, 9
• accuracy, checking models for, 85–87
• Active filters feature (Inspect Document), 82
• ActiveX controls feature (Inspect Document), 81
• Adaptive Insights, 31, 32
• adding
  • data tables to bar charts, 208
  • data tables to models, 198–199
  • labels to line charts, 202
  • scenarios, 48
  • series names to line charts, 203–205
• add-ins
  • to Excel, 31–33
  • for model building, 32
• adjusting
  • line charts to stacked area charts, 205–206
  • pie charts to doughnut charts, 213–214
• advanced functions, 170–172
• Alt key, 123
• Alt+= keyboard shortcut, 135
• Alteryx, 31
• amortization. See depreciation and amortization (D&A)
• ampersand (&), 277
• analysis, comparing types of, 174
• Anaplan, 31
• applying
  • conditional formatting to error checks, 67–68
  • formats to scenarios, 178–180
  • Scenario Manager, 191–193
  • scenarios, 173–193
  • sensitivity analysis with data tables, 181–189
• arrays, dynamic, 17
• assets
  • on balance sheet, 253
  • calculating cash requirements for budgeted purchases of, 277–282
  • calculating written-down value of for balance sheet, 288–290
  • useful life of, 283–284
  • written-down date for, 284
• assumptions
  • about, 29
  • documenting, 53–59, 297
  • entering, 231–234
  • expense, 233
  • redundant, 88
  • revenue, 232
  • scenario, 258–259
• assumptions ...