Introduction to Excel VBA

Print Friendly, PDF & Email
in-house CPD training course

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
Training in Excel VBA
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
Introduction to Excel VBA In-house Training Course
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

Spreadsheet (Excel) Skills for Finance Quote

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

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.

 
 

Make Enquiry or Book Now in-house CPD training course

Simply fill in the form below or contact us.

Your Name (required)

Your Email (required)

Your Organisation

Your Phone Number

Your Message

We value your privacy and have a strict anti-spam policy.

Individual Learners
Please note that this is an in-house course offered to organisations.
For individual learners, we offer:
• a selection of open / public courses
• a range of over 80 online courses
• a range of finance and tax publications.