• Smaller Text
  • Larger Text
  • Print

Intensive Finance Series: Visual Basic

This workshop is available via the following modes of delivery:

  • In-house training: Make an in-house training enquiry to have this course delivered at your organisation
  • Expression of interest: Let AFMA know that you are interested in attending a public workshop in your city

TITLE: Visual Basic for Finance
CE: Up to 14hrs
FEE: Member - $2,530.00 including GST
Non Member - $3,168.00 including GST
available via in-house or
expression of interest


Visual Basic is a powerful but often underused resource that enables you to automate routine work, increase efficiency and customise Microsoft Office applications to your individual needs. This intermediate, two-day workshop will explain the programming concepts you need to use the Visual Basic tools that design, develop, debug and integrate workflows across Office applications. 

Who is it for?

This workshop is designed for those who wish to support, build and enhance Visual Basic MS Office applications. You will work with a computer for the majority of the course on the financial applications of Visual Basic.

If you’d like to check whether this course might be right for you, click here for a course abstract and free self-assessment.

What will you learn?

Participating in this workshop will equip you to:

  • record, play back and modify macros to automate repetitive tasks
  • move personal macros from one machine to another
  • deploy network accessible add-ins to groups of users
  • control security and access rights to macros and add-ins
  • use Visual Basic language to assemble complete Visual Basic applications
  • add controls and forms to Office applications to increase their usability
  • create new functions and make them available within Excel formulae
  • customise Office products to your individual needs
  • integrate workflows across Office applications.


Alex Palfi, Principal, Tykoh Group Pty Ltd

Alex Palfi is a Principal of Tykoh Group Pty Ltd – an Australian based training provider specialising in tailored one and two day workshops on technical finance and business topics.  Prior to setting up Tykoh Alex was a Division Director at Macquarie Group in Sydney. In that role he developed a range of finance workshops and presented those in Australia and at other international locations. Those workshops focused on financial modelling, valuation, derivatives, credit risk and Visual Basic programming.


The best VBA training I have ever attended!

Great workshop. Increased my awareness and skills in VBA.

The material covered will be very useful at work as the CD and workbook provided.

Good cover of topic. It was very useful for work.