Intensive Finance Series: Visual Basic
Intensive Finance Series: Visual Basic for Finance
Increase the ‘wow’ factor of Microsoft Office applications by using Visual Basic to automate routine work and customise applications to your individual needs.
Registration Options
Register by fax or email
You will need to download this registration form
-
Download fax or email registration form
PDF, 130kB
Downloads
-
Program Outline
PDF, 645kB -
Course Sample
PDF, 688kB
Related links
Program Summary
| TITLE: | Visual Basic for Finance |
| CE: |
Up to 14hrs |
| FEE: |
Member - $2,365.00 including GST Non Member - $2,695.00 including GST |
|
Sydney May 22 - 23, 2012 |
9.00am - 5.00pm |
About the Speaker
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.
In earlier roles Alex worked for a number of financial services organisations as a financial software developer and lectured at Technical Institutes in New Zealand in programming and electrical engineering. Alex’s university qualifications are in engineering. He obtained Masters and Bachelors degrees in Electrical Engineering from the University of Canterbury in New Zealand.
About this program
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 course will explain the programming concepts you need to use the Visual Basic tools that design, develop, debug and integrate workflows across Office applications.
What is the Visual Basic for Finance course like and would it be useful to you? Click through for a course abstract and free self-assessment to help you judge if this course is right for you.
What will you learn?
By participating in this two-day workshop you’ll learn how 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; and
- Integrate workflows across Office applications.
Presumed knowledge
It is expected that attending delegates will have Excel skills at an intermediate level or higher.
Testimonials
Presenter was very knowledgeable of the topic area.
The material covered will be very useful at work as the CD and workbook provided.
The best VBA training I have ever attended!
Good cover of topic. It was very useful for work.