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

overview

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.