Introduction to Excel VBA
Excel VBA Introduction
In-house Training Course
We deliver in-house courses in VBA (Visual Basic for Applications). Our VBAs courses can be tailored to meet individual requirements. We offer training in VBA from an introduction level through to an advanced level.
The course outline below is for a one day introduction to VBA which has been popular with some of our clients. This course is designed to give enough knowledge of VBA for everyday users of excel, who can subsequently choose to pursue further if required.
Contents of Introduction to Excel VBA
Please find example contents for a one day introduction to VBA course. This outline can be tailored and the course extended as required.
Excel VBA, the fundamentals
• What is VBA?
• The Visual Basic Editor
Excel macros and automation
• Macro tools and the developer tab
• Recording a set of tasks
• Playback and testing
• Debugging
Learning the VBA language
• Procedures: interpreting the script
• Declaring variables
• IntelliSense
• Common terms
• VBA Objects
Relative referencing
• Recording with relative referencing
• Offset and variable offset
• Jump selection
Controlling objects, applications and macros
• Executing application open and shutdown
• The PivotTable Object
Incorporating failsafe techniques
• Error handling
• IF THEN ELSE statements
• Checking cell contents
Coding functions
• Using in-built functions
• User-defined functions (UDF)
• Variable values
• Replacing nested IF functions
Building programs for end-users
• Message boxes/screen prompts
• Input boxes and declaring variables
• Processing user input
• Working with UserForms
Security
• Macro security settings
• VBA project properties
Introduction to Excel VBA Course Delivery
We take an open friendly and enthusiastic approach to learning finance. We believe that people learn more effectively when they are enjoying themselves. We make finance interesting for you. We love questions and welcome as many as possible.
We encourage an open atmosphere which in our experience accelerates the learning process. We always use lots of exercises, case studies and real life examples in our training as we believe this really helps our clients to understand concepts.
We find that people only really learn when they test their understanding through practice. We offer traditional training, facilitation, interactive simulations, coaching and online training.
Tailored Introduction to Excel VBA
All our courses are tailored to meet our client’s specific needs. We like to spend time getting to know our clients as we strongly believe that training is most effective and valuable when tailored and focused.
In-house Introduction to Excel VBA
Our training can be held within your office or an external venue of your choice.
We can also secure venues on your behalf through our venue sourcing agency.
