Microsoft Excel VBA Training
Public VBA courses and On-site VBA Courses Nationwide.
Our Approach to Excel VBA training
Microsoft Excel VBA training is a specialty of ours. We pride ourselves on covering the fundamentals of VBA programming very well. Our VBA trainers will not let the subject go over anyone’s head (we feel strongly about this); so a potentially complex subject is always broken down into understandable sections which each build on one another as the training course unfolds. At the end of the training course we make sure the trainer who delivered the course is available to help with further questions users may have when they leave the training and start putting the theory into practice in the workplace.
- Led by our Excel specialist Chris James
- Small group sizes – max 6 users
- 1 Day start-up courses or 2 Day intensive courses
Upcoming public Excel VBA courses:
Excel VBA MASTERCLASS, (2 day course) – £600 + VAT per person
DATES:-
Virtual: Thursday 21st & Friday 22nd October |
In-Person: Please e-mail/call up for dates
This is 2-day workshop style course. The first day takes you through a Step-by-step approach with the fundamental principles involved in automating spreadsheet tasks. The 2nd day goes into more detail of the fundamentals of VBA coding.
Excel VBA INTRODUCTION, (1 day course) – £350 + VAT per person
DATES:-
Virtual: Thursday 21st October|
In-Person: Please e-mail/call up for dates
The 1st day of the above 2-day workshop style course, can be taken on its own and it takes you through a Step-by-step approach with the fundamental principles involved in automating spreadsheet tasks. The 2nd day is an optional extra for those who wish to do more with the fundamentals of VBA coding.
We are happy to offer onsite classes as well, please call 020 7183 7740 or email [email protected] to register your interest.
TO BOOK or to discuss our VBA Excel classes in more detail, please call 020 7183 7740 or email [email protected]
Microsoft Excel VBA Introduction (day 1)
VBA Training Course Aims
This one day workshop style course takes you through a Step-by-step approach with the fundamental principles involved in automating spreadsheet tasks.
VBA Course Objectives
To be able to create macro programs in Microsoft Excel to automate spread sheet tasks. Make changes to existing macros to meet your spread sheets requirements.
VBA Training Course Outline
- Getting the most out of your Macro Recorder – Relative & Absolute recordings
- Running macros from the Toolbar and from controls on your spread sheets
- Using the Visual Basic Editor (VBA) to manage existing macros
- Work with and understand Object-oriented concepts – Objects, Methods and Properties
- Create macros that execute automatically via workbooks events
- Debugging and managing macros errors
COST
- Public Course – £350 + VAT per person
- Private Small Group – £700 + VAT (up to 3 users)
- Private Medium Group – £800 + VAT (up to 6 users)
- Private Large Group – £900+ VAT (up to 8 users)
OR TO BOOK / discuss our VBA Excel classes in more detail, please call 020 7183 7740 or email [email protected]
Microsoft Excel VBA Intermediate (day 1 & day 2)
VBA Training Course Aims
This two day workshop style course takes you through a Step-by-step approach to start creating your own VBA programs.
This course will provide inexperienced macros users with enough knowledge of the fundamentals, to begin writing your own macro programs.
VBA Course Objectives
To be able to write macro programs using VBA code to automate repetitive spread sheets tasks. You will understand all the fundamentals needed to develop your programming skills with Microsoft Excel.
VBA Training Course Outline
Day 1
- Getting the most out of your Macro Recorder – Relative & Absolute recordings
- Running macros from the Toolbar and from controls on your spread sheets
- Using the Visual Basic Editor (VBA) to manage existing macros
- Work with and understand Object-oriented concepts – Objects, Methods and Properties
- Create macros that execute automatically via workbooks events
- Debugging and managing macros errors
Day 2
- Use Variables in your program code
- Use looping constructs to perform repetitive tasks
- Use IF THEN constructs to make decisions and control the flow of your programs
- Create and use Input Boxes and Message boxes use data from users
- Create User Defined Functions (UDFs)
- Troubleshooting macro errors with Error Handling code
COST
- Public Course – £600 + VAT per person
- Private Small Group – £1,200+ VAT (up to 3 users)
- Private Medium Group – £1,400 + VAT (up to 6 users)
- Private Large Group – £1,600 + VAT (up to 8 users)
OR TO BOOK / discuss our VBA Excel classes in more detail, please call 020 7183 7740 or email [email protected]
Onsite / Corporate VBA Excel Training
We can also provide corporate Microsoft Excel VBA courses nationwide. Delivered in the comfort and familiarity of your business setting, all levels of experience are catered for. Choose from pre-designed training courses – for beginners to advanced power-users – or tailored courses which are created to meet the specific needs of your business.
This approach to Excel VBA training offers exceptional value for money when you have more than two users needing training. We deliver:
- Agreed customised topics to suit your group’s learning requirements
- Group sizes to suit your team’s needs
- A qualified instructor who will be flexible in her/his approach and will engage well with your team
- Post Course help and support
We specialise in on-site training with several years of experience providing Excel training for large and medium size companies in the UK. These group training events can be made particularly relevant by incorporating typical or actual material from your workplace and can be tailored to cover the specific features your group needs.
COST (per day)
- Private Small Group – £700+ VAT (up to 3 users)
- Private Medium Group – £800 + VAT (up to 6 users)
- Private Large Group – £900 + VAT (up to 8 users)
Companies outside of London will incur a £100 travel fee
To discuss your options in more detail, please call 020 7183 7740 or email [email protected]
