Contents
List of figures
List of tables
PART IExcel
1 Getting started
2 Formulas and functions
3 Charts and tables
4 What-if analysis
5 Data analysis
PART IIBasic finance
6 Time value of money
7 Investments
8 Risk and portfolio models
PART IIIValuation
9 Valuation of investments and projects
10 Real estate
11 Bonds
12 Stocks
13 Options
PART IVSimulations
14 Monte Carlo simulations
PART VVBA
15 Visual Basic for applications
16 Programming in VBA
17 Control structures
18 Working with VBA
19 Procedures
20 Arrays
21 UserForms
Index