Learnit Training
Course Excel VBA
  • Learn how to easily automate tasks with the VBA Editor
  • Extensive attention to various programming techniques
  • Very experienced teacher with a broad knowledge
  • Small group with a lot of personal guidance
  • Laptop and lunch we provide

With VBA you can automate and customize common actions and procedures in Excel. In this training and learn in two days to program in VBA using the VBA editor of Excel.

Yes, I want to know more

"A good course to lay a structured foundation for working with/programming in VBA."-Rating: 9.2

learnit Excel VBA

Course Excel VBA

Using macros to automate actions in Excel can be very useful. But if you work with macros in Excel, using VBA can deliver time-saving and faster-created spreadsheets.

In this training you will learn how to automate common tasks with VBA. You will learn how to generate and modify codes with the help of the VBA editor. You will also get acquainted with the object model and the specific objects (library) of Excel.

Topics

  • Understanding the Excel object model and VBA concepts
  • Working effectively with the VBA editor
  • Making procedures and subprocesss in VBA
  • Creating and Using Variables
  • Creating and using user-defined functions in VBA
  • Using various programming techniques
  • Programming Forms and Userforms
  • Create Procedures that start automatically
  • Handling Error messages

The Trainer

You will be accompanied by a very experienced trainer in this training. The trainer discusses at the beginning of the training what your entry level is and what you want to get out of the training, so that you can focus on subjects and exercises that are important to you. Our trainer knows everything about VBA and helps you to get to know your level to master everything.

Practice

If you have run into problems yourself or would like to perform certain actions more efficiently, it can be enlightening to take an example from your work environment to the training. You can still get more practice-oriented.

After

At the end of the training, you know how to convert Excel to your hand using VBA, which results in faster and more enjoyable work with Excel.

Prior knowledge

Knowledge and skill at the level of the course Excel sequel is recommended.

To determine how much prior knowledge you have and which course is suitable for you, we make an online course guide available!

Note

During this course we use English language course material. This training can be followed in different versions. Please indicate whether you are using Excel 2007, 2010, 2013 or 2016.

Lesvorm

This training is offered on the basis of our Open learning form-teaching method. This means that under the active supervision of our trainer, you are working independently to make your own substance. You can achieve your learning goals at your own pace without being bothered by a faster or slower pace of your fellow students. The trainer will ensure that you stay on track and achieve your learning goals. This form of learning offers space for customised work. You will have the opportunity to create examples from your own practice and IT environment that will make you more specific. more...

Language

The training is provided by default in Dutch. The trainer controls the English language. English course material can be used. When registering at least 3 participants, the training can also be provided entirely in English.

Investment

Mentioned prices are per person, including course material. Lunch is included in the training on location.

On location Online
Duration 2 days 4 sessions of three hours
Price per day, excl. VAT € 400,- € 315,-
Total, incl. VAT € 968,- € 762,30

Certificate

After completing the training, a LEARNIT certificate will be issued as proof of participation.


Online

We also organize this training online. For this we use Webbex or Zoom. Logging in with Skype is also possible. On request this training can also be organized with Microsoft Teams.

The training lasts 4 sessions of 3 hours, spread over 4 weeks.

  • Until one year after the training you can participate for free.
  • Against payment of the catering costs you can also participate in a classroom training.

References

The Excel VBA course has been assessed with an average of 8.4.

"Well-groomed training with a good trainer in a great location and well-groomed lunch." - Review: 7.8

A. Stevens, Drillmasters - Excel VBA

"It's fun and very instructive. I've learned a lot from it and will benefit a lot in the future." - Rating: 8.0

Youri de Beurs, Excel VBA - Excel VBA

"A good course to lay a structured foundation for working with/programming in VBA." - Assessment: 9.2

D.J.H. Berens, Detailresult Services - Excel VBA

"The Excel 2010 VBA Course gives a good start on Macros and its programming!" - Review: 7.8

Tuncay Sahin - Excel VBA

"Everything about this course was good. Well arranged in advance, good location, good lunch and above all good and clear course material and an expert trainer. I am very enthusiastic and would certainly recommend this to others". - Assessment: 9.4

D. Baker, TNO - Excel VBA

"The teaching material is constructive, teacher knows what he's talking about, even off the books. So it's also possible to ask questions about things you're running into yourself". - Review: 7.6

J.R. de Jong, Unica - Excel VBA

"good impression. You understand the structure and structure of VBA much better. Highly recommended to all editors, you now understand how it really works!" - Rating: 8.6

A. de Blieck, Randstad Nederland B.V. - Excel VBA

"Excellent training when you want to learn the working methods and logic behind VBA/Macros. Ultimately, in addition to recording Macros, it also enables you to write your own formulas and programs. Offer a lot of support to investigate what is possible with VBA. I already knew a bit about recording macros, but this has given me insight into how VBA works and what you need to pay attention to. Top!" - Assessment: 8.2

J. Peters, Estepe - Excel VBA

"In a short period of time, you will learn the principles of VBA/Excel, with the opportunity to use your own practical examples". - Rating: 10.0

A. van der Spreng, OneSolution Informatisering B.V. - Excel VBA

"Lots of fun exercises that you can immediately participate and apply. Good clear trainer who pays attention to everyone." - Assessment: 8.1

Wendy Dekker, Hamilton Bright - Excel Continued

"Fine teacher, very patient and willing. You can also bring your own practical examples to the lesson, to look at them together with the teacher and practice how to fit in. Is even after the training also willing to answer your questions via e-mail. Great service!" - Rating: 9.0

Caroline van Trigt, GDF Suez - Excel Basic

"Macros are very applicable to your own work situation. Very good course that fits in well with your personal wishes". - Review: 8.7

P.C.H Geerts- van Tilburg, Laater - Excel 2003 Macros and collaboration with other programs

"It was an exhilarating, clear training given by a young but experienced teacher who could explain everything clearly and simply to someone starting from zero. In short, good training in a good location with a good teacher." - Assessment: 8.1

W. Prince - Excel Basic

"I can recommend the Excel course at Learnit to anyone. Excellent guidance from the teacher, clear textbook and CD with all kinds of exercises that are fully in line with the textbook (these may be taken after the course as practice and reference work). Through this course I found out that I had been able to work much more efficiently for years. Thanks to Learnit." - Rating: 10.0

D. Schellenberg, Utrecht University of Applied Sciences - Excel Basic

"'I thought I was pretty handy with Excel, but I learned some new things in this webinar.'" - Review: 8.8

E. Hijstek, Zig Websoftware - Free webinar PivotTables in Excel 2010 and 2013

"I took MS Excel 2010 basic: a two-day course that contains all the basic techniques you need to get on well with Excel. Learned a lot in 2 days and good personal guidance. Everything will be explained quietly and time will really be taken for you." - Rating: 10.0

M. van den Outenaar, Landelijk Examenbureau B.V. - Excel Basic

"Clear and simple textbook, level is good, pleasant trainer who explains clearly and anticipates at the right moments. Lestempo is good, very professional trainer. So educational!" - Assessment: 8.4

Ilonka Hadzikadunic, Besam - Excel Basic

"The teacher had a pleasant way of dealing with students and is good at explaining and empathizing. Also thinks along with the practical problems of the students and is helpful in that". - Rating: 8.0

O. Veenstra, Cunningham Lindsay - Excel 2003 Basic

"Coursebook clearly indicates what you must and can do. The teacher is happy to explain. There is a lot of space to start working with your own examples and files". - Review: 8.8

A. Pakkert, The Animal Health Service - Excel Continued

"The content of the Excell 2003 course was perfectly in line with my learning objectives. The individual way of teaching, i.e. getting started works very well. If you have any questions, you get specific help. The after-care is also very well arranged; you can still contact the teacher. - Rating: 9.0

M. Tjon Lim Sang, Ministry of Foreign Affairs - Excel 2003 Turning tables, formulas and functions

"The daily course Excel Turntables formulas and functions is suitable for those who want to learn the anatomy of the turntable in a short period of time and want to acquire the basic knowledge. - Rating: 9.0

C. A. Busser, van der Meulen Sneek BV - Excel Revolving tables, formulas and functions

"'Followed a webinar for the first time. Definitely worth repeating. Clear explanation. Clear presentation.'" - Rating: 9.0

C. Leenders, University Hospital Maastricht - Free webinar PivotTables in Excel 2010 and 2013

"For me, Excel was nothing more than a program of squares... But that you could do so much with it... A new (Excel) world opened up for me. I will certainly apply this in the future. It will save a lot of time." - Review: 7.7

Brenda Miller, Coty Prestige - Excel 2002 Basic

"Practical course that guides you through the possibilities of excel." - Review: 7.7

Annemiek Zuyderduin, Unica Installatietechniek B.V. - Excel 2010

"Very useful to better master your own subjects at your own pace. Guidance perfect." - Assessment: 8.9

G. Rozeboom, Central Bureau of Statistics - Excel Expert

"The course is taught by a teacher with a lot of knowledge and passion for Excell, this is contagious. The Readers that are used are very clear and contain assignments that you can work with yourself. Together, the Readers of the basic and follow-up course are a clear reference work for on the work floor". - Rating: 8.6

J. Weimar, Troostwijk Waardering en Advies B.V. - Excel Continuation

"Efficient for people, who already make a lot of use of databases in Excel."

Janet van Apeldoorn, BIJ12 - Excel Revolving tables, formulas and functions

"Even if you think you already know a lot about Excel, you always learn something. The possibilities are enormous." - Review: 7.9

Arline de Rooy, SMT Netherlands B.V. - Excel Basic

"An organization that gets it right, reacts quickly and thinks along with you." - Rating: 8.0

T. Banga, The Frisian Forests - Excel Revolving tables, formulas and functions

"Good course. What I especially appreciated was the fact that each learns at his or her own pace at which he or she is interested". - Review: 7.7

J. Kelmanutu - Excel Basic

"The content is surprising and you can do a lot in practice with the subject matter." - Rating: 8.1

I. Teunissen - Excel Sequel

"Even for participants who have little or no experience with the subject matter, it's surprising how much one can learn in two days." - Review: 7.8

B. Forest, Valspar B.V. - Excel Basic

"Expert lecturer who can move quickly in practical situations." - Assessment: 8.1

I. Beuving - Excel Basic

"The Exceltraining "the sequel" is a good connection to the base and was still good for me to do. Now I still have to put it into practice. I was glad that a teacher was present to help me with the questions I couldn't answer. You can also bring an example from your work that can be treated in the lesson. In the 2 courses that I have now followed, a number of participants have been helped to deal with and solve a complex issue through the help of the teacher and the necessary formulas that came with it". - Rating: 9.0

L. Nuijten, IZZ Foundation - Excel Continued

"I'm extremely pleased with this way of teaching. You will receive a lot of individual attention with good tips from the teacher. Also if you want to discuss work related topics. In short, I recommend this way of teaching, everyone, if you want to learn to master the material at your own pace". - Rating: 9.0

J. B.W.M. van Asperen - Excel Basic

"Very practically oriented, brought your own documents to practice with, so that what you have learned can be put into practice right away. Nice way of following a course, lots of practice material." - Rating: 8.0

A. Copier, Center Parcs - Excel Revolving tables, formulas and functions

"Especially if you work with lists, this is a very useful follow-up/expert course." - Review: 8.8

S. Doormink, Albeda College - Excel Expert

"Excel is generally < 20% in mogelijkheden gebruikt hetgeen het kan gezien de kosten van het pakket is het aan te bevelen wat de 100% mogelijkheden zijn.” - Be­oor­de­ling:  7.1

Paul Sangen, Unica Installation Group B.V. - Excel 2010

"The excel follow-up course fully met our expectations. The learning objectives have been fully met and new excel applications have been learned by both less experienced and more advanced users". - Assessment: 8.1

L. Jautze, University of Amsterdam - Excel Continued

"Effective training using clear course material." - Rating: 8.0

A.J. Black, EDventure - Excel Basic

"'Followed a webinar for the first time. Definitely worth repeating. Clear explanation. Clear presentation.'" - Rating: 9.0

C. Leenders, University Hospital Maastricht - Free webinar PivotTables in Excel 2010 and 2013

"Very good training! everything is perfectly arranged and it is definitely recommended to follow a course at Learnit." - Rating: 9.0

Luciano Felida, New Neopharm - Excel Basic

"Learnit is a really good training organization, what I like is that you also get the book and then you can always practice." - Rating: 8.7

Abrar Hussain, The Hague Work Company - Excel Continued

"Very instructive training: recommended for anyone who works with Excel occasionally or regularly!" - Rating: 8.0

Lotte Dijk, BIJ12 - Excel Revolving tables, formulas and functions

"Well attuned to the customer's needs" - Review: 8.7

F. Nuij, BV Steenfabriek Spijk - Excel Revolving tables, formulas and functions

"Learned a lot in a fine way in a short time." - Assessment: 9.4

D. Corbel, Nuon - Excel Continued

"This training is highly recommended. Good and clear way of explaining. They will take the time for you and you will get answers to all your questions. Really a super course." - Rating: 10.0

T. Heijdra, Unipat B.V. - Excel 2003 Turning tables, formulas and functions

"A violent introduction to getting more out of yourself and Excel." - Rating: 9.0

H. Palmer, Promise Technology - Free webinar PivotTables in Excel 2010 and 2013

"Highly educational training with a good individual approach that suits the student." - Assessment: 9.4

Inge Leerintveld, Roma Service Cinemas - Excel Revolving tables, formulas and functions

"Good interactive course, where there is room to learn to solve practical situations." - Rating: 8.0

J. van Hal - Excel Expert