Excel VBA course
In this course you will learn to automate common tasks in Excel using VBA. You will work with the VBA editor, procedures, variables and Userforms. Optionally, attention is also given to Copilot.
NRTO quality mark- Automate Excel with powerful VBA code
- You work efficiently with the VBA editor
- Practical examples from your own work
- Optional attention to Copilot in Excel
- Personal guidance at your level
Your trainer: Pascal, Bart, Raoul or Hans 1.773 evaluations in total, averaging 8,5. View the trainers
With VBA you take your Excel work to a higher level. You automate tasks, write your own functions and build smart forms. Optionally, you also look at Excel with Copilot, so that you learn to use AI and VBA alongside each other.
Description
In this Excel VBA course you work on automating common tasks in Excel using VBA code. You learn how to generate and adapt code via the VBA editor and how to use Excel's object model for smarter spreadsheets. You create procedures, work with variables and program your own functions and Userforms. Error handling and automatically starting procedures are also covered. The course optionally pays attention to working with Microsoft 365 Copilot in Excel, so that you also gain experience with AI support alongside VBA.
Topics
- Insight into the Excel object model and the basic concepts of VBA
- Working effectively with the VBA editor
- Creating procedures and sub-procedures
- Creating and using variables
- Writing your own functions in VBA
- Applying programming techniques for loops and conditions
- Programming forms and UserForms
- Procedures that start automatically
- Handling error messages and debugging
- Optional: using Excel with Microsoft 365 Copilot
Result
After this course you can independently automate recurring tasks in Excel using VBA. You write and adapt code in the VBA editor, work with variables, procedures and custom functions, and build Userforms for data entry. You know how to handle error messages and how to start procedures automatically. The result: working with Excel faster and more enjoyably. If you have opted for the optional Copilot module, you can also use AI to speed up your VBA work in Excel.
Target audience
This course is intended for Excel users who work with macros on a regular basis and want to take their spreadsheets to a higher level with VBA. Think of staff in finance, controlling, data or analysis departments who want to automate recurring tasks and build their own bespoke solutions in Excel. Some experience with Excel and macros is a useful basis.
Teaching method
You follow this training course in our open learning format: one day on location, where you work in a small group with your own laptop and course material. The trainer walks around, answers your questions and helps you on your way as soon as you get stuck.
Because everyone works at their own pace, you decide what to focus on. Do you have an example from your own practice? Bring it along and you can work directly on an issue from your job. Would you optionally also like to get acquainted with Copilot in Excel? That is possible during the same course day.
Prior knowledge
You work with Excel regularly and know the basics of formulas and functions. Experience with macros is useful, but not essential. You do not need any programming experience yet. Would you like to get more out of your spreadsheets? Then this is the right place for you.
Comments
You follow the course in our open learning format: a single course day in which you work with VBA in Excel under the guidance of an experienced trainer. You work at your own pace and decide for yourself which topics receive extra attention. Feel free to bring along an example from your own practice, so that you can get to work on your own questions straight away. When booking, please indicate which version of Excel you use, so that our planners can arrange the right course material. Optionally, we also cover working with Copilot in Excel.
Course format
This training is offered on the basis of our Open Learning teaching method. This means that you work independently, with active guidance from our trainer, to master the material. That way you can achieve your learning objectives at your own pace, without being held back by fellow participants working faster or slower. The trainer makes sure that you stay on schedule and meet your learning objectives. This form of learning leaves room for a tailored approach. You have the opportunity to bring in examples from your own practice and IT environment, so that your learning is even more specific. more...
Practical information
- Number of days
- 2 days
- Course times
- from 10 am to 5 pm
- Teaching hours
- 12 hours
- Education level
- Suitable for all levels
- Preparation time
- None
- Included
- Course materials and lunch on site
- Certificate
- At the end of the course you will receive a certificate of attendance
Language
The course is given in Dutch as standard. The trainer speaks English. English-language course materials can be used. If at least 3 participants register, the course can also be given entirely in English.
This course for your team?
Plan your own group on a date that suits you, at your office, at our premises or online. We tailor the content to your day-to-day work, and training a whole group is cheaper than individual bookings.
- Your date and location
- Tailored content
- Multiple groups or an academy are also possible
- More than 25 years' experience
The trainers for this course
Ratings from participants after completing their course, across all courses by this trainer.
What others say about this course
Excel VBA course: average 8.6 from 10 reviews
“The Excel 2010 VBA course is a good introduction to macros and how to program them!”
“A good course for laying a structured foundation for working with and programming in VBA.”
"Good impression. You understand the structure and set-up of VBA much better. Recommended for all editors, you now understand how it really works!"
“The course material builds up well and the trainer knows what he is talking about, also beyond the books. So it is also possible to ask questions about issues you run into yourself.”
“It is enjoyable and very instructive, definitely recommended. I learned a great deal from it and it will be of much use to me in the future.”
“In a short space of time you get to grips with the basics of VBA/Excel, with the opportunity to use your own practical examples.”
“Enjoyable, inspiring course, I learnt things and picked up ideas I didn't know were possible with Excel and VBA. Even though I normally use Excel a lot in my daily work as a tool.”
"Excellent course if you want to understand the working methods and logic behind VBA/macros. It ultimately means that, in addition to recording macros, you are also able to write formulas and programs yourself. Gives you plenty to go on when exploring what is possible with VBA. I already knew something about recording macros, but this gave me insight into how VBA works and what to look out for. Great!"
“Everything about this course was good. Well organised beforehand, a good venue, a good lunch and above all good, clear course materials and a knowledgeable trainer. I am very enthusiastic and would certainly recommend it to others.”
“Well-organised course with a good trainer at an excellent location and a well-prepared lunch.”
“Anyone who works with a computer will really benefit from this.”
“Good course. The material ties in well with the Excel advanced course. The instruction book is clearly structured. A calm atmosphere in which working on your own is easy to do.”
“The course is of good quality and is well geared to practical use.”
“The open learning format is a good way to follow a course. You can take the course at your own pace, with or without prior knowledge.”
"Learned a lot in a short time, and in a pleasant way"
"A. Effendi, Plan-it by Praxis B.V. - "For anyone looking for a tailor-made course, this is the right solution. The groups are small and the trainer is sufficiently qualified. You can state your learning objectives in advance and you receive fairly precise advice on which course suits you best. The course material is to the point and concludes with a case that you have to solve to see whether you can actually apply what you have learned. In any case, I learned what I wanted to know, and that is ultimately what it is all about." Rating: 8.0."
“Do you want to get more out of Excel in your daily work? Then this is a good step in the right direction!”
“Clear and well-structured Excel course! You go home with far more knowledge and ways to apply it”
“If you run into problems with Excel in practice, take this course. Alongside the standard course material there is plenty of time to work through your own practical examples.”
“Excellent course for people who want to achieve their own learning goals at their own pace.”
"Excellent course! Mastering the Excel course at your own pace and with answers to the questions you ask. Very illuminating. I thought I knew a lot about Excel..."
“The open learning format is a good way to follow a course. You can take the course at your own pace, with or without prior knowledge.”
“The Excel course for beginners is a practical, useful and pleasant course to take. Afterwards you can take the course material home with you, so you can use it as a reference. The training group is not too large, and the trainer has a very good command of the subject. If I take another computer training course in future, I will certainly look at what Learnit has to offer.”
"I found the pace of the course and the trainer's assertiveness refreshing and dynamic."
"F. Van den Berg - "Good training. Good course material. Recommended!" - Rating: 8.0"
“I took the Excel 2007 pivot tables course for advanced users and I thought it was a good course, with a highly capable trainer. Questions are answered well and the trainer's knowledge can only be described as very good. Highly recommended!”
“Effective training based on clear course material.”
"The course was useful, I enjoyed it, the trainer was great and I would certainly recommend it."
“What appealed to us about Learnit's teaching method: everyone in the group can work through the material in their own way, and if there are questions or comments, the trainer explains the right approach. That way, everyone worked through the material at their own level and pace.”
“Learned a great deal in a short time, in a very clear and accessible way. A very efficient method for me!”
"Very practically oriented, brought my own documents to practise with, so that what you learn can be put into practice straight away. A pleasant way of taking a course, plenty of practice material."
"An excellent course at a lovely venue. The trainer's personal approach makes sure it never gets boring. I learnt a great deal."
"This course gives you insight into the possibilities of VBA, teaches you to understand existing macros, and gives the candidate a basis for building modules 'from scratch'."
“Good course, you get a lot of practical information that you can really put to use.”
“Had two days of training in Excel Basic 2013. The enjoyable assignments in the course material achieved more than years of struggling and trying on my own. Definitely worth it!”
“For anyone reading this who deals with Excel a lot at work, this is definitely worth recommending. Even though you think you know Excel, there are certainly plenty of possibilities within the program that you did not yet know about and that you can practise and apply at work after the course.”
“Simply a valuable course. Professional, up to date, high-calibre trainers. All in all: a course like this is not to be missed.”
“It is an excellent course with clear course materials. I learned a great deal from it.”
“The Excel Advanced course fully met our expectations. The learning objectives were completely achieved and both the less experienced and the more advanced users learned new Excel applications.”
"A.E. van Wezel - "A very practical course designed above all to make the most of the standard functions" - Rating: 8.6"
"Hans gives you as a course participant the feeling that you can learn Excel perfectly well, even if you are more visually inclined or more of an arts than a science person; that is extremely pleasant."
"Self-study, but with something extra. A good teacher with a great deal of subject knowledge, who genuinely thinks along with you about applying your objectives in your own working environment."
“Pleasant training course, small group, plenty of time for individual attention! Bring your own files so you can apply what you have learned straight away – I found that very worthwhile. You then come up against different questions than with the practice material.”
“If you are looking for a programme to improve your chances on the job market, I would certainly recommend one of the courses, if only to refresh your knowledge!”
“If you want to know the ins and outs in a short space of time, do register!”
“Excellent training, fits my role well, certainly if you have no experience with Excel. The guidance is excellent too.”
“Clear and useful course with practical topics. The trainer is enthusiastic and motivating.”
“The instruction/explanation is very clear; you can get started yourself straight away, with the convenience of support where needed.”
"Even if you think you already know a lot about Excel, you always learn something new. The possibilities are enormous."
"My opinion of the course is positive. The quality of the course material was good, the level was good, the duration was good, the pace was perfect, the variety between the three participants was just right, the exercises were complete, the set-up of the course was good and the trainer was professional (and cheerful)."
Training formats
Classroom
2 days€ 1100,-- Pleasant venue with a good trainer
- Small groups
- Inspiring and motivating
In-company
Bespoke trainingOn request- 100% for your group
- Bespoke training
- At your place or ours
Workshop
Up to 4 hours for groupsOn request- Suitable for events
- Interactive and inspiring
- Large groups too
Private training
At our place or yoursOn request- 100% just for you
- Achieve a lot in little time
- Whenever you want