Our classroom training provides you the opportunity to interact with instructors and benefit from face-to-face instruction.
Excel VBA Training
VIRTUAL TRAINING
Catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning.
CORPORATE TRAINING
Our Corporate training provides you the opportunity to interact with instructors and benefit from face-to-face instruction.
TRAINING HIGHLIGHTS
High quality training from Certified & Industry Experts
Earn 8 PDUs
Course Completion Certificates
Extensive documentation provided
Reimbursement guaranteed if the training is not satisfied
Our approach is both practical and inspirational. Our training is carefully designed and tested to develop the key skills and confidence needed while being highly participatory and fun
This VBA training is an introduction to VBA macro programming for automating accounting and finance functions.
This VBA training 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.
- 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.
Learning Objectives:
- The skills and abilities required to write your own VBA macros.
- The ability to identify opportunities to utilize macros effectively.
- A sound introduction to VBA best-practice programming concepts.
- Management Accountants
- Financial Accountants
- Cost Accountants
- Business Analysts
- Finance and Cost Analysts
- CFO’s
- Finance Managers
- Business Bankers
- Corporate Finance Analysts
What Does Academy for Pros provide me on the day of the course?
We provide Course Materials, Course Completion Certificate and Refreshements
What experience does Instructor has?
All our Instructors are Certified & Industry Experts and they have years of experience in teaching Agile Courses
Does this course includes exam?
This course does not include exams as this is non-certifications course. once after the training we provide course completion certificate with each credit per hour (SEU,s or PDU’s)
