About Workshop
Business and financial modelling using Microsoft Excel are highly demanded professional affairs today. Though the course title emphasises heavily on business, finance and Microsoft Excel 2010, 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:
Day One:
Session One:
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 Two:
Formulas, Functions and Referencing
Formulas with Absolute and Relative Referencing
Advanced Logical Functions
Advanced Lookup/Match/Index Functions
Accounting and Financial Functions
Session Three:
Advance Financial Functions
Time value of money functions
Financial Evaluation Functions
Costing and Budgeting Related Functions
Accounting Functions
Session Four:
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 Five:
Costing, Budgeting and Financial Planning Models
Develop model for costing and pricing products and services
Prepare production, overhead and sales budgets
Day Two:
Session One:
Costing, Budgeting and Financial Planning Models
Prepare cash budget
Prepare pro-forma Financial Statements
Session Two:
Investment Analysis and Planning Models
Develop a Investment Planning Model
Evaluate an Investment Project
Session Three:
Investment Analysis and Planning Models
Discounted Cash Flow Analysis for Company Valuation
Portfolio Analysis Models
Session Four:
Model Control Tools
Drop-down Box, Check-box and Radio Button
Vertical and Horizontal Scroll Bars
Buttons and other Components
Macros and VBA
Session Five:
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}
