Using Excel for Business and Financial Modelling, 3rd Edition

Index

•  
• Absolute referencing, 104–106, 128, 130, 133, 141, 152, 161
• Access (Microsoft), 9–12
• ActiveX controls, 16, 226
• Add-ins, 7, 12–13, 16
• Aggregation functions, 127
• Alignment, 185, 197, 333, 348, 386
• Amortisation schedule, 178, 182
• Ampersand, 63, 138
• Analysis ToolPak, 12
• AND, 119–122, 270, 294–295
• Area chart, 359, 363
• Array formulas, 234–236, 263, 313, 332
• Assumptions documentation, 6, 37, 41, 51, 55–59, 62, 64, 67
• Assumptions layout, 29
• Audit tool, 12
• AVERAGEIFS, 133, 136–140
• AVERAGE, 111–113, 126
• Axes, 372, 384

•  
• Balanced scorecard, 3, 5
• Bar chart, 97, 192, 356–363, 375, 391–392
• Benchmarking, 5
• Best practice, 3, 6–7, 22, 25, 37, 44–5, 47, 51–55, 67, 74, 77–80, 104, 107–108, 151, 153, 170, 189, 243, 273–274, 301, 316, 325, 387
• Binary code, 214, 225
• Boolean logic, 225
• Break-even analysis, 241, 295–300
• Break-even point, 295–299
• Bubble chart, 366–367, 384–387
• Bulletproofing, 199
• Business case, 2, 33, 55, 62, 73, 74, 275, 277, 327, 355

•  
• Cell link, 219, 221, 223, 345–346
• Cell referencing, 104–107, 119, 125–126, 128
• Charts, 5, 11, 34–35, 41, 43, 45, 96, 98, 195, 198, 210, 216, 253, 315, 318, 354–367, 373–377, 383, 387–388
• Chart type, 98–99, 162, 358–362, 364, 369, 373–375, 382
• Checkboxes, 34, 37, 197, 216–219, 225
• CHOOSE, 164–165, 218, 313, 345–346
• Circular Reference, 85–90, 261
• Colour coding, 31, 35–36, 226
• Colour scales, 193–195, 336, 365
• Column charts, 359–363
• Combo Boxes, 221–226, 260, 328–329, 344–347, 350
• Combination Charts, 364
• Communication, 21–22, 24
• Compounding, ...