Nigerian Seminars and Trainings

Search conferences, training, seminars, courses and workshops in Nigeria and around the world

business logo

Advanced Financial Modelling in Excel

By: Euromoney Financial Training

South Africa

26 - 28 Feb, 2014  3 days

Follow Event

  

The principal aim of the course will be to learn to build and use financial models as tools to understand transactions, identify risk and perform sensitivity analyses. The learning methods used are practical, as practice of newly-learned techniques enables a deeper and more effective building of skills.
Each section will be covered briefly as a module in a traditional class style, but the real learning experience will be found in the exercises within each module. 

Course Aim
The course is designed to support junior and middle-ranking staff in setting-up their own financial models, or in using models received from other sources. The principal aim of the course will be to learn to build and use financial models as tools to understand transactions, identify risk and perform sensitivity analyses.

Course Methodology
the learning methods used are practical, as practice of newly learned techniques enables a deeper and more effective building of skills.
Each section will be covered briefly as a module in a traditional class style, but the real learning experience will be found in the exercises within each module.
Suggested solutions to each exercise will be provided and discussed, and participants will be encouraged to review their work independently.
The course covers:

  • Best practice structuring in Excel models
  • Use of advanced Excel functions
  • Techniques for dealing with inflation, time shifts, circularity
  • Creating cash flow waterfalls in Excel
  • Excel tools for sensitivity analysis
  • Advanced consolidation techniques and pivot tables
  • Introduction to using macros
Johannesburg, South Africa Feb 26 - 28 Feb, 2014
£2,850.00
(Convert Currency)

+44 (0)207 779 8543