Financial Modelling and Asset Valuation with Excel

Figures

1.1      A formula in Excel

1.2      The ribbon in Excel 2010

1.3      The Excel Options dialogue box

1.4      Spreadsheet tabs and status bar

1.5      Arrange windows

1.6      The Object dialogue box

1.7      The Microsoft Equation editor

1.8      Equation tools in Excel 2010

1.9      Page Setup

1.10    Sales figures

1.11    Sorting data

1.12    Custom Lists

1.13    Comment

1.14    The Format Cells dialogue box

1.15    Conditional formatting

1.16    Data Validation

2.1      Calculation in Excel

2.2      Formula auditing

2.3      Circular reference warning

2.4      Financial statements

2.5      Financial statements

2.6      Function library

2.7      The Insert Function dialogue box

2.8      Autocomplete

2.9      The SUMPRODUCT function ...