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.
Duration Learning Credits
1 day-8 hours of 8 PDU’s
Session
Public Classroom Pricing:
Early Bird Price: CAD 649.00
Regular Price: CAD 799.00
Instructor-Led Virtual Live Pricing:
Early Bird Price: CAD 549.00
Regular Price: CAD 699.00
Private Group / In-House Learning:
Have a group of 5 or more people?
Register yourself with a special pricing and
request the training exclusively
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)
● Management Accountants
● Financial Accountants
● Cost Accountants
● Business Analysts
● Finance and Cost Analysts
● CFO’s
● Finance Managers
● Business Bankers
● Corporate Finance Analysts
● 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.