| Unit 1 [Book] | |
| Financial Modelling, Introduction, Types and Purposes | VIEW |
| Difference between Spread sheet and Model | VIEW |
| Skills required for a Good Modeler | VIEW |
| Best practices in Spread sheet design | VIEW |
| Formatting of Excel Sheets, Data Filter and Sort, Conditional formatting, Use of Excel Formula Function, Lookup functions, Match & offset and Data Validation- Drop down) | VIEW |
| Advanced Modelling Techniques | VIEW |
| What if analysis | VIEW |
| Scenario Building | VIEW |
| Sensitivity Analysis | VIEW |
| Solver | VIEW |
| Macros | VIEW |
| Unit 2 [Book] | |
| Charting Techniques and Rules of creating a bar chart | VIEW |
| Pictures as linked objects in Spreadsheets | VIEW |
| Creating Dynamic charts, Using Name manager, Display or multiple chartsat the same time in same location using filter | VIEW |
| Now and Then Analysis chart | VIEW |
| Waterfall Charts | VIEW |
| Thermometer Charts, change in chart using sensitivity analysis | VIEW |
| Creation of Dashboards | VIEW |
| Pivot tables | VIEW |
| Pivot charts | VIEW |
| Unit 3 [Book] | |
| Loan Amortization | VIEW |
| Introduction to Financial Statements | VIEW |
| Understanding Income Statement | VIEW |
| Balance Sheet | VIEW |
| Cash Flow Statement | VIEW |
| Forecasting Models | VIEW |
| Ratio Analysis | VIEW |
| Du point Analysis | VIEW |
| Linking Spreadsheets | VIEW |
| Unit 4 [Book] | |
| Time Value of money | VIEW |
| Cost of Capital | VIEW |
| Measure of Leverage Project Finance | VIEW |
| Project evaluation, Stage of Project, construction and Development phase, Funding during Investment Phase, Costs during Investment Phase | VIEW |
| Life of Project | VIEW |
| Capital Budgeting Techniques (NPV, IRR, XNPV, MIRR, XIRR) | VIEW |