About Workshop
Financial modelling and risk management using Microsoft Excel are highly demanded professional affairs today. Though the course title emphasises heavily on finance and Microsoft Excel, development of sophisticated, comprehensive and dynamic financial model requires a little bit more than the skills in finance and spreadsheet applications. To be a professional financial modelling analyst it requires skills in system development, database, system security, project management and networking besides skills in finance and Microsoft Excel. Most of the contemporary training programs ignore these additional skills requirements. This course with the title “Advanced Financial Modelling with Microsoft Excel- Plan, Develop, Pack, Distribute and Protect” is developed with the objective of incorporating all these additional skills with the core finance and spreadsheet skills
Learning Outcomes
The course is designed for the professionals working in finance and accounting discipline having fundamental concepts of finance and Microsoft Excel.
1. Identify and Understand financial modelling scenarios and life cycle of a financial model and take necessary pre-development initiatives
2. Develop advance skills on Microsoft Excel Functions, Formulas and Referencing System
3. Understand and apply core and advance Financial functions needed in various financial activities
4. Understand risk management and take risk management decisions using What-if-analysis
5. Develop Costing, Budgeting and Other Financial Planning Models
6. Develop Investment analysis, Discounted Cash Flow Analysis and Portfolio Analysis Models
7. Making financial models dynamic using Control Tools
8. Implement security and sharing features as post-development activities
Workshop topics to be covered:
Session 1: Financial Modelling Scenarios and Life Cycle
Scopes of Financial Modelling
Life Cycle of a Financial Model
Data collection and Assumptions
Application of Microsoft Excel in Financial Models
Session 2: Formulas, Functions and Referencing
Formulas with Absolute and Relative Referencing
Logical Functions
Lookup Functions
Financial Functions (Basic)
Session 3: Advance Financial Functions
Time value of money functions
Financial Evaluation Functions
Costing and Budgeting Related Functions
Accounting Functions
Session 4: Risk Management and What-if-Analysis
Risk Management in Finance
Goal Seek Analysis for Risk Management
Scenarios and Simulation
Advanced Referencing for Risk Management Models
Session 5: Costing, Budgeting and Financial Planning Models
Develop model for costing and pricing products and services
Prepare production, overhead and sales budgets
Session 6: Costing, Budgeting and Financial Planning Models
Prepare cash budget
Prepare pro-forma Financial Statements
Session 7: Investment Analysis and Planning Models
Develop a Investment Planning Model
Evaluate an Investment Project
Session 8: Investment Analysis and Planning Models
Discounted Cash Flow Analysis for Stock Valuation
Portfolio Analysis Models
Session 9: Model Control Tools
Drop-down Box, Check-box and Radio Button
Vertical and Horizontal Scroll Bars
Buttons and other Components
Macros and VBA
Session 10: Post-Development Activities
Testing models, finding Errors using Excel’s Error Handling Tools
Assigning Security
Adding Help Files and other Documents
Packaging the Model and Distributing
![](Templates/"../images/bodyedge_tr.gif"width="2"){kind=small}
![](Templates/"../images/bodyedge_tl.gif"width="2"){kind=small}
