ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Building Blocks for Financial Modelling
2
3
TopicCovered in
4
5
Introduction to Excel Interface, Categories & Basic Functions
Session 2
6
7
Arithmetic Operations
8
SummationSession 2
9
Multiplicaitonsession 2
10
Divisionsession 2
11
Substractractionsession 2
12
Basic Formattingsession 2
13
Averagesession 2
14
Count (counts numbers)session 2
15
Minimumsession 2
16
Maximumsession 2
17
Extending Formulassession 2
18
19
Data Summary and Analysis
20
Classificationssession 2
21
Pivot Tablessession 2
22
Functions of Pivot Tables- Drill down capabilitiessession 2
23
Cross Checkingsession 2
24
Sortingsession 3
25
Sub Totalssession 3
26
27
Logical Functions
28
If Functions, Nestingsession 3
29
Conditional formattingsession 3
30
31
Financial Analysis
32
Ratio Analysissession 3
33
Formattingsession 3
34
IRRsession 3
35
NPVsession 3
36
37
Summarization and Classifications
38
Pivot Tablessession 2
39
Filtersession 4
40
Advanced Filtersession 4
41
42
43
Lookup Functions
44
Vlookupsession 4
45
Index-Matchsession 4
46
Transposing Datasession 4
47
Hlookupsession 4
48
49
50
Workbook Management
51
Moving Worksheetssession 4
52
Hiding/ Unhidingsession 4
53
Protecting Worksheets
54
Protecting Workboooks
55
Setting Print Options for Reportssession 4
56
Password Protecting Workbooks
57
58
Model Input Designs & Basic Calculation
59
Data Validation
60
Creating and Using Names in Workbooks
61
Designing Model Input Templates
62
Goal Seek
63
64
65
Principles of Modelling
66
Sample Weak Model
67
Proced to Lecture and Discussion in Class
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100