Course Overview:

This VBA course is an introduction to VBA macro programming for automating accounting and finance functions.

This VBA course assumes participants have little or no prior programming experience, although it will be highly beneficial if participants have at least recorded a macro previously and have examined the VBA code a little.

Target Audience:

• Management Accountants
• Financial Accountants
• Cost Accountants
• Business Analysts
• Finance and Cost Analysts
• CFO’s
• Finance Managers
• Business Bankers
• Corporate Finance Analysts

Learning Objectives:

• The skills and abilities required to write your own VBA macros.
• The ability to identify opportunities to utilise macros effectively.
• A sound introduction to VBA best-practice programming concepts.

Prerequisites:

None

Course Materials:

Students will receive a course manual with presentation slides and reference materials.

Examination:

There is no exam for this course.

Technical Requirements:

For eBooks:

Internet for downloading the eBook

Laptop, tablet, Smartphone, eReader (No Kindle)

Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)

eBook download and activation instructions

Agenda:

Days 1 and 2: Introduction to Excel VBA

Introduction to VBA

• An introduction to all the building blocks required to write macros in Excel’s VBA.

Introduction to Programming

• An introduction to programming concepts and writing code.
• Best practices to make your VBA easier to read, quicker to run, and more robust.

Controlling Code

• How to make code do what you want it to do.
• How to write code that can be easily modified.
• How to make your macros run as fast as possible.

Interacting with Excel

• How to automate common Excel functions such as copy, move, format, print, delete etc.
• Getting responses from users.
• How to read/write data from/to Excel worksheets.
• How to write your own functions and extend the range of functions available in Excel.
• How to link your macros to buttons and other controls.

Debugging

• How to use VBA’s tools to quickly find problems and errors then resolve them.

Files

• How to create new Excel files within VBA.
• How to open existing Excel files via VBA.
• How to save Excel files using VBA.
• How to work with multiple Excel files and copy or move data between them.

Related Courses

High-Powered Excel for Finance (1 day)