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

"In A short time you learn to master the principles of VBA/Excel, allowing you to use your own practice examples."-Rating: 10.0

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
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 organiseren deze training ook online. Hiervoor maken we gebruik van Webbex of Zoom. Inloggen met Skype is ook mogelijk. Op verzoek kan deze training ook met Microsoft Teams worden georganiseerd.

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

"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

"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

"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

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

Tuncay Sahin - 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

"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

"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

"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

"M. Koeken, Continuous B.V. - i> Well-designed training with a competent trainer. - Rating: 8.8"

- Excel Expert

"Very concrete training which gives a good insight into the possibilities of Excel." - Assessment: 9.6

C.H.G.M. Meuwese - Excel 2010

"Good training, you'll get a lot of practical information you can handle." - Assessment: 7.3

Want Chopping Card, NBD Biblion - Excel Basic

"I've been taking the excel bassis course for the past 2 days and I've become a lot more comfortable with excel." - Assessment: 8.3

Nicole Dekkers, Scania - Excel Basic

"Intensive 2-day training that you learn a lot from and because there is room to discuss your work-related questions with the teacher, it fitted in well with my personal learning goals". - Assessment: 7.1

Elise van der Steen, DHL - Excel 2003 Continued

"Open learning is a good form of training. You can follow the training at your own pace, with or without prior knowledge." - Rating: 8.0

M. Ensel-Boonstra, Ensel Staalkonstrukties - Excel Basic

"Worth following." - Review: 8.9

"Good impression, had nice two days. Much learned!" - Rating: 8.0

A. van Achterberg, Novatech Heerenveen - Excel Basic

“'In het webinar draaitabellen wordt goed en duidelijk uitgelegd wat je met draaitabellen kunt doen. Als je nog nooit een draaitabel gemaakt hebt, dan heb je veel aan deze webinar. Het is ook fijn dat je rechtstreeks vragen kunt stellen, die vervolgens meteen behandeld worden.'” - Be­oor­de­ling: 9.0

N. Albers, Multisol Raambekleding - Gratis webinar Draaitabellen in Excel 2010 en 2013

“De bevlogenheid van de trainster was aanstekelijk! Het was voor haar geen enkele moeite om te schakelen tussen de verschillende niveaus van de cursisten en/of tussen de verschillende toepassingen.” - Be­oor­de­ling: 7.9

J. Vermeer- Boer, Kuehne Logistics - Excel 2003 Basis

"Quality of teaching material, assignments and professionalism of trainer a big enough one!" - Assessment: 8.2

"Good training, you'll get a lot of practical information you can handle." - Assessment: 7.3

Want Chopping Card, NBD Biblion - Excel Basic

A. van Achterberg, Novatech Heerenveen - Excel Basic

“'In het webinar draaitabellen wordt goed en duidelijk uitgelegd wat je met draaitabellen kunt doen. Als je nog nooit een draaitabel gemaakt hebt, dan heb je veel aan deze webinar. Het is ook fijn dat je rechtstreeks vragen kunt stellen, die vervolgens meteen behandeld worden.'” - Be­oor­de­ling: 9.0

A. Nieuwenhuis, ETI BV - Excel Basic

"Excellent course by good guidance and clear assignments with which the newly acquired knowledge could be applied immediately". - Rating: 8.0

A. van der Gragt, Hamilton Bright - Excel 2013

"Excellent teaching material, teacher with a good knowledge of Excel." - Rating: 8.0

M. Hutterd, Geas Energy Guard - Excel 2003 Expert

"K. Algra, Municipality of Nijmegen - "An excellent course with good material and a lot of exercises that fit in with practice." - Rating: 7.0"

- Excel Macros and collaborate with other applications

"This training fits well with the individual objective and is applicable to your work." - Rating: 8.0

"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

C. Engberink, KOAC-NPC - Excel Basic

"Total weather with Excel thanks to Learnit traning." - Rating: 10.0

K. Ettalhaoui, FNV KIEM - Excel Basic

"Training location is perfect. The teaching material is clearly displayed so you can easily walk through the fabric". - Rating: 8.0

Karin van der Laan, TU Delft - Excel Basic

"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

"Very concrete training which gives a good insight into the possibilities of Excel." - Assessment: 9.6

C.H.G.M. Meuwese - Excel 2010

Caroline van Trigt, GDF Suez - Excel Basic

"'Very instructive. Directly applicable in practice. Enthusiastic trainer with a clear and personal explanation.'" - Rating: 9.0

A. van der Grond, Hamliton Bright - Excel 2013

"I have very good impression of the content of the training and specially of the trainer"

- Excel Expert

N. Baart, ENGIE services Nederland NV - Excel Basic

"Good way to master the basics of Excel." - Assessment: 8.4

R. Helt, PC Hooft Group - Excel Basic

"Good textbook with exercises you can do at your own pace. The teacher can ask you for help at any time." - Assessment: 9.1

W. Huiberts, Teleplan - Excel Continued

"Professionally and to all questions a clear answer." - Rating: 8.0

R. Bertram, VION Enschede - Excel 2010

"'Very instructive. Directly applicable in practice. Enthusiastic trainer with a clear and personal explanation.'" - Rating: 9.0

A. van der Grond, Hamliton Bright - Excel 2013

"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

"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

"Plus there's no classroom teaching, so you can do it at your own pace. Two days is just enough." - Rating: 8.0

R. Frings, Keyrail B.V. - Excel Basic

"Training fits in very well with work. By bringing your own material you are goal-oriented and you learn what you want to learn. In addition, there is a lot of space and experience available to further expand the knowledge". - Assessment: 9.4

Mr. van Seters, IMT - Excel Revolving tables, formulas and functions

"I've had an instructive and at the same time relaxing workout. The teacher gives a good explanation if you have a question and makes you feel at home so easily. He goes along in the breaks to chat about other things or to walk along. Learnit gives good training and makes sure you don't come home with a cracked head. Super!" - Rating: 9.0

J. Ndabacekure - 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

"A pleasant way to highlight from the total package of teaching materials only those topics in which you are interested and not to be tired of things for which you are not interested" - Rating: 7.9

A. Stiebolt, Post & Co. - Excel Sequel

"An instructive practical Excel basic training, which gives a lot of insight into the possibilities that Excel 2010 has to offer". - Rating: 8.0

P. van der Meule, NUON - Excel Basic

"Training on your own level where you get support as soon as you need it. This allows you to learn efficiently at your own pace". - Rating: 9.0

J. Kramer, Hema - Excel Continued

"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

"This training is excellent for those who have a good basis for Excel and want to improve further. Teacher was very professional and helpful. Right way to carry out this kind of course". - Rating: 10.0

T. Ghosh, Northern Petroleum Netherlands BV - Excel Continued

"Nice and very practical training." - Review: 8.8

B. Borghuis, Rabobank Twente East - Excel Basic

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

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