Home / Financial Modelling in Microsoft Excel

Financial Modelling in Microsoft Excel

What is this about?

Financial Modelling is an interactive programme that involves instruction, discussion and extensive participant activity. It is aimed at developing knowledge and skills in building a financial model by making a decision regarding investment in a project or company.

Participants will also learn effective auditing techniques on existing models. The “mouse less” excel techniques taught as part of this training, when employed dramatically reduces model coding time and are indispensable to the effective use of financial spreadsheets for any industry or sector.

Why should you enroll?

The programme aims at addressing different training needs of the employees in terms of empowering them with data processing and modelling skills. This in turn will greatly increase return on investment (ROI) for your organisation and improve career advancement prospects for learners. All the basics of advanced Excel are covered, enabling the delegates to move on to an exhaustive treatment of the main modelling techniques available thus building financial models that are robust, tested and scalable.

What are the topics covered?

  • Introduction and overview to Financial Modelling
  • Model Tools & Functions
  • Financial Functions
  • Modelling Techniques
  • Rebuilding and Inherited Model
  • Bullet proofing your model
  • Scenarios and Sensitivity Analysis
  • Presentation of Model Output

Credits Awarded

2 credits

What is the duration?

This is a 2.5 days course

Who should attend?

  • Financial Managers
  • Chartered Accountants
  • Management Accountants
  • Cost Accountants
  • Technical Accountants
  • Financial Accountants
  • Financial Officers
  • Financial Planners
  • Financial Controllers
  • Financial Project Administrators
  • Finance Supervisors
  • Financial and Business Analysts