ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Core Functions for Financial Modelling
2
3
Introduction to Excel Interface, Categories & Basic Functions
4
5
Arithmetic Operations
6
7
Summation
8
Multiplicaiton
9
Division
10
Substractraction
11
Basic Formatting
12
Average
13
Count (counts numbers)
14
Minimum
15
Maximum
16
Extend Formulas
17
Sub Totals- Sorting
18
Pivot Tables
19
Cross Checking
20
Functions of Pivot Tables- Drill down capabilities
21
Setting Print Options for Reports
22
Classifications
23
24
Logical Functions
25
If Functions
26
Conditional formatting
27
Embedded function
28
Formula referencing
29
30
Financials
31
IRR
32
NPV
33
34
Summarizationa and Classifications
35
Pivot Tables
36
Sub Totals
37
Filter
38
Advanced Filter
39
40
41
Lookup
42
Vlookup
43
Hlookup
44
Index-Match
45
46
47
Goal Seeker
48
Solver
49
50
51
52
Creating and Using Names in Workbooks
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
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