Finance Modeling with Excel Training
Objective:
MS Excel ® is today unarguably the most commonly used spreadsheet utility globally to do finance. In spite of this, according to various surveys on Excel usage, a rather minuscule percentage of Excel Users use it to its full potential. The focus of the course is to help the participants learn the tools and capabilities of this spreadsheet application to perform from the simplest to the most complicated and elaborate financial analysis.
Duration: 16 Hrs / 2 days
Who can Join ?
Corporate Finance Professionals ,Quantitative analysts ,Investment Bankers , Risk professionals ,Treasury managers ,Controllers etc. (e.g Chartered Accountants, MBA Finance professionals, Finance BPO Professionals)
Prerequisites:
Participants should be clear with financial fundamentals. Basic excel functions and formulas hands in experience is must.
What you will learn:
Master the use of Excel’s financial modeling tools and capabilities .
How to design a model to suit your purpose .
Understand the different types of financial models and when each should be applied .
Construct financial models making use of a broad range of Excel methods and techniques .
Accurate forecasting corporate cash flows for project finance deals and structures .
Incorporate elements such as risk, sensitivity, optimization and forecasting into financial Models .
Produce meaningful management reports and charts for communication .
How to identify and control key sensitivities through advanced spreadsheet simulation .
How to design a model to maximize flexibility and reliability .
Practical tips for checking and debugging the mode .
Why Excelrocker !!!
Training will be delivered by a Experienced Chartered Accountant.
Personal attention and Non-mechanical approach.
Focus on real world application.
Comprehensive take home material.
If you are looking for a detailed course outline or interested for a demo, please fill the contact form, we will get back to you with no time.
MS Excel ® is today unarguably the most commonly used spreadsheet utility globally to do finance. In spite of this, according to various surveys on Excel usage, a rather minuscule percentage of Excel Users use it to its full potential. The focus of the course is to help the participants learn the tools and capabilities of this spreadsheet application to perform from the simplest to the most complicated and elaborate financial analysis.
Duration: 16 Hrs / 2 days
Who can Join ?
Corporate Finance Professionals ,Quantitative analysts ,Investment Bankers , Risk professionals ,Treasury managers ,Controllers etc. (e.g Chartered Accountants, MBA Finance professionals, Finance BPO Professionals)
Prerequisites:
Participants should be clear with financial fundamentals. Basic excel functions and formulas hands in experience is must.
What you will learn:
Master the use of Excel’s financial modeling tools and capabilities .
How to design a model to suit your purpose .
Understand the different types of financial models and when each should be applied .
Construct financial models making use of a broad range of Excel methods and techniques .
Accurate forecasting corporate cash flows for project finance deals and structures .
Incorporate elements such as risk, sensitivity, optimization and forecasting into financial Models .
Produce meaningful management reports and charts for communication .
How to identify and control key sensitivities through advanced spreadsheet simulation .
How to design a model to maximize flexibility and reliability .
Practical tips for checking and debugging the mode .
Why Excelrocker !!!
Training will be delivered by a Experienced Chartered Accountant.
Personal attention and Non-mechanical approach.
Focus on real world application.
Comprehensive take home material.
If you are looking for a detailed course outline or interested for a demo, please fill the contact form, we will get back to you with no time.
|
|