Automated reporting with VBA in banking


Training objectives

Do you spend significant time to creating monotone reports at your work? Excel's built-in Visual Basic application is a solution for your problem.

No matter whether you have any programming knowledge or background; our VBA course will guide you through the basics of the most important programming techniques. Our experts present you tasks arising during your work, they will translate into programming language and show how they can effectively be solved using Visual Basic.

Who is this course for? 

This course is aimed at individuals with a basic or no grounding in Excel VBA, who wish to improve their skills with introducing more sophisticated automation into their workflows.

  • IT
  • Controlling
  • HR
  • Risk Management
  • Internal Audit
  • Finance

Estimation of PD and LGD risk parameters


Details of industry standard credit risk parameter estimation methodologies are the main focus of this course. Basel 2/3 compliant solutions are presented in detail supported by in-depth case studies solved by participants.

Participating in this course will allow banking experts to learn the details of creation, parameterization and testing of probability of default (PD) and loss given default (LGD) estimation methodologies. Through various case studies, participants can try out these newly presented techniques, by estimating their own risk parameter sets.

Recommended to:

  • Credit risk managers, credit analysts
  • Monitoring, internal audit and work-out experts
  • Basel II team members


If you are interested in tailor-made English courses or you seek other locations, do not hesitate to contact us. It would be a pleasure for us to carry out a proposal that fits to your requirements.

For further information please contact us:
László Madar, +36/1/2240709