This CPD Accredited Introduction to VBA Course for Groups is delivered in a virtual or live classroom at your venue. This is a group booking for this VBA course, allowing up to 8 people to attend. The training is efficient and is delivered by an expert in the field who has years of experience in both the practical application of VBA and delivering training in VBA at all levels.
Introduction to VBA Course
The course is accredited, and successful completion will lead to accredited certification from the CPD Standard Institute.
Course Content
Macros and VBA
- Recording and running macros
- Assigning macros to menus, toolbars and buttons
- Understanding how to edit the VBA in your Macros
- Absolute vs Relative References in VBA
How to start writing your code
- Excel objects
- How to Build My Own Code
- Variables and constants in VBA
- If statements in VBA
How to repeat your code
- Looping and how it works practically
- Understanding Conversion functions
- User-defined functions
- User forms and dialog boxes
How to debug errors
- Error-handling and debugging
- Use the object browser
- Build codes that are less likely to incur errors
Taking VBA further
- Managing the Visual Basic editor
- Input boxes and Message boxes
- Understanding objects, properties, methods and events
- Workbook and Worksheet events
- Getting help in VBA
Training Course Outcome
- The ability to record, edit and run macros
- Edit and build code in Visual Basics
- Write your Visual Basic code
- Learn how and why to use loops, variables and if statements
- Write your own VBA code functions
- Understand and write object-oriented concepts
- How to build VBA code that will be less likely to have errors
- Working knowledge of the main Excel VBA objects/properties
- Understand Debug and how to correct errors
- Understand the Excel VBA functions
- Confidence and core knowledge required to move to Intermediate and Advanced Level training in VBA
Benefits of taking our VBA Training
- CPD Standards Institute accredited
- Taught by experienced and highly qualified tutors in small classes
- Highly practical and work-related training material
- Confidence to perform VBA in your work
- The ability to continue to study VBA at higher levels
- Certificate on completion
- Greater career options, job opportunities and earning potential with VBA skills
Training Course Timings
The course runs from 10:00 to 16:00 for one day. Please get in touch with our office to confirm the dates. This will depend on trainer availability. This product allows for virtual classroom delivery for up to 8 people. We can, however, arrange live classroom training at your location; please contact our office for a quote.
Trainers
Our instructor-led classes have a trainer with high professional and teaching experience and sound academic qualifications. This ensures that the learner gains from the expertise and guidance of a high-quality professional.
Accreditation
The CPD Standard Institute accredits them, and a certificate will be issued upon completion.
We offer a 2-day option to build on the introductory skills gained in this course and develop more advanced VBA skills. Please ask us if you feel you need a more extended training program.