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
“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.”
"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!"
“A good course for laying a structured foundation for working with and programming in VBA.”
“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.”
“Well-organised course with a good trainer at an excellent location and a well-prepared lunch.”
"Good impression. You understand the structure and set-up of VBA much better. Recommended for all editors, you now understand how it really works!"
“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.”
“The Excel 2010 VBA course is a good introduction to macros and how to program them!”
“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.”
“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.”
"Informative, pleasant, clear material, step-by-step method."
"Excellent trainer, very patient and willing to help. You can also bring your own practical examples to the lesson, to look at them together with the trainer and practise how to apply them. He is even willing to answer your questions by email after the course. Great service!"
“An intensive 2-day course from which you learn a great deal, and because there is room to discuss your work-related questions with the trainer, it fitted my personal learning objectives well.”
“If you want to get to grips with a program for work or privately, this course is a perfect solution. It may take some investment, but the results are far better than having to fit it in on the side. You are out of your work environment, but fully focused on the course. For me it was absolutely spot on!”
“Very useful training course! You take home a good reference manual in which you can look things up. The trainer has a great deal of knowledge and explains things well. Recommended!”
“'Taking courses with Learnit comes highly recommended!'”
“Thoroughly recommended for everyone”
“Especially if you work with lists, this is a very useful advanced/expert course”
“Professional, no-nonsense, practice-oriented course”
"I thought it was a good and worthwhile course. I learned a great deal from it. The trainer gave clear explanations and has extensive knowledge of Excel."
“Very instructive course: recommended for anyone who works with Excel occasionally or regularly!”
“Good training, learnt a lot, very usable in practice!”
“Excellent training - nice to be able to set my own pace - good support - clear course material - directly applicable in practice.”
"It shows how Excel works in a simple way, very accessible for people who are not familiar with Excel."
“Everything was interesting and useful.”
“Good course, I learned a great deal from it and will certainly get a lot of use out of it at work.”
“Very good course! Everything is perfectly organised and I would certainly recommend taking a course at Learnit.”
“Good, clear explanations. The trainer also takes the time to answer questions along the way.”
“A clear and straightforward teaching method that is certainly of use in practice. It is not a training course that is pointless and will never be used again.”
“The trainer had a pleasant way of dealing with participants and explains things well and with empathy. He also thinks along with participants' practical problems and is helpful in doing so.”
“Good course, you get a lot of practical information that you can really put to use.”
“A good coursebook with exercises that let you work at your own pace. You can ask the trainer for help at any time.”
“I found the training very clear, a patient trainer, a pleasant atmosphere and working environment.”
“This training is excellent and very comprehensive, you can learn an enormous amount from it”
“A good, instructive course.”
“A good, instructive, interesting course. I discovered new functions in Excel that I didn't even know existed! So I definitely learned new things!”
“Good course, you get a lot of practical information that you can really put to use.”
“Used Learnit for the first time and was pleasantly surprised by the concept. Small group and plenty of individual attention. There were enough training methods available through the extensive course materials.”
"I have very good impression of the content of the training and specially of the trainer"
“Highly recommended; good level, professional guidance and good materials. I particularly enjoy the keyboard shortcuts and knowing new, quick solutions.”
“With the help of visuals and working with the material ourselves, it was an enjoyable interactive training tailored to the questions we asked. In short, a very applicable course.”
“Over the past 2 days I followed the Excel Basics course and it has made me a good deal more skilled with Excel.”
“Professional, with a clear answer to every question.”
“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.”
“An intensive 2-day course from which you learn a great deal, and because there is room to discuss your work-related questions with the trainer, it fitted my personal learning objectives well.”
"Very practical Excel training that you can join at any level. The trainer gives you real knowledge of Excel. The practical handy tricks during the training in particular mean that afterwards you can apply everything in practice."
“Very concrete course which gives a good insight into the possibilities of Excel.”
"Enjoyable course in which you learn the tricks of creating macros through simple but engaging exercises. Even a small part of Visual Basic is included, which gives you some idea of how a macro is built up in programming language."
“An independent, person-focused course. Thanks to this, Excel has prompted me to think far more creatively about the ways I can use Excel in my work.”
“Plenty of enjoyable exercises that you can join in with and apply straight away. A good, clear trainer who gives everyone attention.”
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