Excel VBA for Finance

CPA Members only

CPA Australia has partnered with the Corporate Finance Institute (CFI) to curate a collection of data and digital courses exclusively for CPA members. CFI courses have an emphasis on hands-on, practical learning and skills acquisition. They teach in-demand industry practices, tools and techniques that help accounting and finance professionals build confidence, stand out from the competition, and make a positive impact on their careers.

This course will teach you the fundamentals of Excel VBA and is perfect for finance professionals who are comfortable with Excel and want to expand their knowledge. The course starts with the basics by teaching you how to set-up the VBA environment, when and why to use VBA, and how to build custom formulas. We will then use this foundation to progress to more advanced topics such as how to handle errors and exceptions, how to publish your functions and share it with your colleagues, set-up events & automation, and work with arrays. 

VBA is a great tool to automate repetitive tasks on Excel and is also able to streamline long and complex calculations. This course uses a case study of a multinational company to create a custom function, and explore various useful topics and concepts in VBA.

CPA Australia handles your personal information in accordance with the CPA Australia Privacy Policy. By proceeding you may be redirected to an external website to access the course.

Our Privacy Policy includes the following statement under the subsection 'Links to external websites':  
   We may provide links to websites operated by third parties. 
   We are not responsible for the privacy practices or the content of such websites which will be governed by their own privacy policies to which you are advised to refer. 
   Your satisfactory completion of the course may be recorded in your CPD Diary.

CFI programs will be supplied to CPA Australia members as standalone courses for 12 months from the date of purchase and as such, any associated CFI certifications are not able to be supplied. Refunds or extensions for purchases of CFI courses will only be available in exceptional circumstances and will be based on CPA Australia and CFIs cancellation terms.