Learnit Training
Excel Macros course and working with other programs
  • Small groups
  • Covid-19 safe
  • Experienced teacher
  • Possible online
  • Practical training

Never again perform an action in Excel too often? In this one-day training course, you learn how to automate actions using macros and how you can make Excel work together with other programmes.

Yes, I want to know more

"Training is focused, well designed and can be followed and completed at one's own pace within a sufficient time frame." - Rating: 8.7

learnit Excel Macros and working with other programs

Excel Macros course and working with other programs

Do you want to automate common actions in Excel? This is possible with macros. Fortunately, this is not difficult and everyone can learn it. Macros allow you to record a series of actions and repeat them with a press of a button. During this training you learn how to create, understand and edit macros. You will also learn how to create links with other Office programmes such as Word, Access and PowerPoint.

This training is the second half of the training Excel Expert. During the first half, formulas, functions and pivot tables are discussed.

Topics

  • Recording and executing macros
  • Modifying macros and detecting errors
  • Absolute and relative recording
  • Starting possibilities
  • Personal macro workbook
  • Templates
  • Integration
  • Convert or import files
  • Exchange data with Word
  • Exchanging data with Access
  • Connecting to external database
  • Send workbook
  • Compatibility

The trainer

During the training you will be guided by a social and competent trainer. At the beginning of the training, the trainer will discuss your entry level and what you want to get out of the training, so that you can focus on topics and exercises that are important to you.

Which version? 2007, 2010, 2013 and 2016.

When you register, you can fill in which version you are using. Our planners will then ensure that you can follow the training in the correct software version with the material written for this version.

Case studies

It is possible to bring along practical examples from your work situation so that you can work in an even more focused way and it is clear what your goal is from this training. The topics and exercises will be tuned to this.

Afterwards

On completion of the training you will be able to use macros to create links with other programmes, such as Access and PowerPoint. You will know how to apply macros to automate common actions and how to modify macros in the editor.

Prior knowledge

For this training, previous knowledge at the level of Excel Basic level recommended. To determine how much prior knowledge you have and which course is suitable for you, we set a online course guide available.

Note

This training can be followed in different versions. Please indicate whether you use Excel 2007, 2010, 2013 or 2016.

Course format

This training is offered on the basis of our Open Learning Method. This means that under the active guidance of our trainer, you work independently to master the material. This enables you to achieve your learning goals at your own pace without being hindered by the faster or slower pace of your fellow course members. The trainer will make sure you stay on track and achieve your learning goals. This type of learning allows for customisation. You are given the opportunity to bring in examples from your own practice and IT environment, which will help you learn even more specifically .

Language

The training is provided in Dutch as standard. The trainer has a good command of the English language. Use can be made of course material in English. With a minimum of three participants, the training can also be provided entirely in English.

Investment

Prices mentioned are per person, including course material. Lunch is included in the on-site training.

On location Online
Duration 1 day 2 sessions of 3 hours
Price per day, excluding VAT € 375,- € 290,-
Total, incl. VAT € 453,75 € 350,90

Certificate

After completion of the training, a Learnit certificate is issued as proof of participation.


Online

We also organise this training online. For this we use Webbex or Zoom. Login with Skype is also possible. On request, this training can also be organised with Microsoft Teams.

The training takes 2 sessions of 3 hours, spread over 2 weeks.

  • You can participate again free of charge up to one year after the training.
  • For an additional catering fee, you can also participate in a classroom training.

References

The course Excel Macros and working together with other programs has been assessed with an average of 8.4.

"Enthusiastic trainer who explained everything in a clear and understandable way." - Rating: 8.0

J.A. Ramesar, CEVA Logistics - Excel Macros and working with other programs

"If you are looking for training to increase your chances of employment, I will definitely recommend one of the courses, if only to refresh your knowledge!" - Rating: 7.4

J. Blaauw - Excel Macros and working with other programs

"Training is focused, well designed and can be followed and completed at one's own pace within a sufficient time frame." - Rating: 8.7

J. Mols, Meulenhoff Bookshop - Excel Macros and Cooperating with Other Programs

"Nice course, where you can learn the tricks of macro making in simple but fun exercise material. Even a small part of visual basic is included in the course, giving you a bit of an impression of how a macro is constructed in programming language." - Rating: 8.0

R.A. Ritsma, Dr. Oetker - Excel Macros and working with other programs

"I can recommend this training to every office user. The material and the pace of work can be adapted to one's own situation and there is ample opportunity to ask questions, which are then answered." - Rating: 8.1

M. Oostdijk, ROC Mondriaan - Excel Macros and working with other programmes

"This course is a logical sequel to the basic course. It has been set up so that people with less experience of Excel can also follow it. With some practice you can automate all kinds of tasks in Excel." - Rating: 9.9

Peter Anuels, Praclox BV - Excel Macros and working with other programs

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

- Excel Macros and working with other programs

"Excel is a great programme, but it is even more fun to find out what else you can do when you have completed the course. - Rating: 7.0

J. van Dijk, Ministry of Defence - Excel Basic

"I found it a good and meaningful training. I learned a lot from it. The trainer gave clear explanations and has a lot of knowledge of Excel."

- Excel Basic

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

Lotte Dijk, BIJ12 - Excel Pivot Tables, Formulas and Functions

"I can really recommend the training. After two days of training, you have learned so much that you can work well with Excel. Moreover, the course material is good to use as a reference work." - Rating: 10.0

Janine de Jong - Excel Basic

"Totally up to date with Excel again thanks to Learnit training." - Rating: 10.0

K. Ettalhaoui, FNV KIEM - Excel Basic

"Clear, personal training focused on one's own practical situation, which makes it easy to apply in practice. All this in a pleasant atmosphere, highly recommended! - Rating: 8.3

M. Luursema, Astrimex - Excel Continued

"Good training. Trainer has a lot of knowledge of Excel and gives calm and clear explanations."

- Excel Basic

"The training Excel 2010 continued was given by an expert trainer. The book with assignments that you had to go through yourself was varied. The two teaching days flew by. I didn't go through the whole book with assignments, so I had to finish it at home because the trainer sent me a link." - Rating: 7.6

B.A.J. Bastiaansen, ENGIE services Nederland B.V. - Excel Continued

"I came as a (48yrs) mechanic from the field and had been working a bit with Excel for several years but I had only learned some tricks from colleagues. This course has given me a huge foundation." - Rating: 8.0

E.J. Jonker, NV Nederlandse Gasunie - Excel Basic

"Excellent training! At your own pace and with answers to your questions, mastering the training Excel. Very enlightening. I thought I knew a lot about Excel...". - Rating: 9.0

H. Warnier, Servatius Housing & Property Development - Excel 2003 Continued

"Although I consider myself a quite advanced user, the course-instructor managed to teach me some new advanced options within excel which will make my life easier in the future." - Rating: 7.9

F. Kluin, Wintershall - Excel Pivot Tables, Formulas and Functions

"Excellent educational course." - Rating: 7.8

F. Hendrickx, ENGIE services Nederland NV - Excel Continued

"Enthusiastic teacher who can explain well and is very patient. Clear teaching material that is also good to use as a reference book if you get lost." - Rating: 8.0

Ursela Verstegen, Randstad Nederland B.V. - Excel 2003 Basic

"A good training that lets everyone work at their own speed and insight. I did the Excel 2007 Basic and Advanced training at Learnit and a world opened up for me. I would recommend Learnit to everyone; good learning material, professional trainers and a delicious lunch. You can take the course material home with you, so you can practise with it at home as well." - Rating: 10.0

T. Danieli, Het Behouden Huys - Excel Continued

"A fine and clear training that is easy to follow for novice "Excellers"." - Rating: 9.0

L. Hoogendoorn, Media Markt Saturn Holding Nederland B.V. - Excel Tables, Formulas and Functions

"Highly recommended for anyone who wants to learn the basics of Excel. Excellent course material that can be used as a reference at home and at work. The clear and well-constructed course material makes this an excellent self-study." - Evaluation: 9.4

A. Vermeulen, DMN Machinefabriek Noordwijkerhout BV - Excel Basic

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

W. Prins - Excel Basics

"The training allows each person to reach their learning goals at their own pace." - Rating: 8.0

J.van Wolfswinkel, Cofely - Excel Continued

"A pleasant way to work your way through the material. A book with clear instruction and a teacher in the background who answers questions! - Rating: 9.0

J. Coesmans - Excel Continued

"The PowerPivot training has given our group many insights. Gradually, you pick up many tips and tricks that make your work much more efficient. For people who process or analyse a lot of data, this training is highly recommended."

- Excel PowerPivot

"A good course, a pleasant teacher, a lot of topics that I personally benefit from in my work." - Rating: 7.9

P. De Vries - Nederlandse Gasunie N.V. - Excel Continued

"Hands on training that helps you in your day-to-day work" - Rating: 7.3

Dave van Lierop, Hamilton Bright - Excel Continued

"If I had known about these features of Excel earlier, it would have saved me a lot of time and effort!" - Rating: 8.7

L. Wijnvoord, Movir - Excel Basic

"Learnit matched us with the right trainer. Our training need was not a standard training and this was well understood by Nick. Everyone we spoke to at Learnit was pleasant. We are very happy with your professionalism and flexibility." - Rating: 9.4

L. van Eekelen, VU University Amsterdam - Excel Pivot Tables, Formulas and Functions

"I took the Excel 2007 Advanced PivotTables course and found it to be a good course, with a very capable teacher. Questions are answered well, knowledge of the teacher is very good. Highly recommended!" - Rating: 8.3

L.W. Mooi, Betonindustrie B.V. Concrelit - Excel Pivot Tables, Formulas and Functions

"M. van Es, Kales - "No classroom instruction, but working at your own pace on the topics of interest to you." - Rating: 7.6"

- Excel Continued

"I found it a nice instructive training, with many useful tips and facts about excel, and also learned much more about functions, pivot tables and vertical search." - Rating: 7.3

J. SLagter, Makro Amsterdam - Excel 2003 Basic

"Self-study with a touch of extra. Good teacher present with a lot of substantive knowledge, who also really thinks along to apply your objectives in your own practical environment."

- Excel Pivot Tables, Formulas and Functions

"The Excel training 'the sequel' is a good follow-up to the basics and was easy for me to do. Now I have to put it into practice. It's great that a teacher was present to help me with the questions I couldn't solve. You can also bring along an example from your work that can be discussed in class. In the 2 courses that I have now followed, a number of participants have been helped to deal with and solve a complex problem through the help of the teacher and the necessary formulas that came along with it." - Rating: 9.0

L. Nuijten, IZZ Foundation - Excel Continued

"Excellent training to master Excel from the ground up and step by step. - Rating: 7.4

P. de Jong, Group of Butchers - Excel Basics

"I have experienced the training as very instructive. Doing it yourself and dealing with assignments in class is a good mix to be able to apply the knowledge properly. In addition, the trainer is also open to bringing in your own cases, so that in this way you are also helped directly at work level. Very pleasant! In short, I found it a successful training in which I was able to develop myself further in a pleasant and pleasant setting! - Rating: 7.0

D. Nieuwenhuis - Excel Continued

"Even if you only have basic knowledge and experience, you can learn a lot from this training. Learning tricks that can make your work easier and give you a better overview." - Rating: 7.1

Aafke Odink, Dutch Obesity Clinic - Excel Continued

"Can be used immediately in practice, saves a lot of time and avoids new frustrations.

- Excel Continued

"Excellent proffesional Training with many "tips & tricks" for every starting level."

- Excel Pivot Tables, Formulas and Functions

"Excellent training, fits well with my job, especially if you have no experience with Excel. The guidance is also excellent." - Rating: 8.1

R. Slieker, Unica Group - Excel Basic

"A great course to get to know the possibilities of Excel in more detail if you already know the basics. Because of the individual aspect, you can get the most out of the course for yourself. And if all trainers are as enthusiastic and knowledgeable as the one I had, you can get even more out of the course than what the course material offers." - Rating: 8.9

M. Arends, Combiwel Welzijnszorg - Excel Continued

"Good training. Subject matter fits in well with the Excel follow-up course. The instruction book is clear. Calm atmosphere in which working on your own is easy to achieve." - Rating: 8.0

L. Fokker, GGD Kennemerland - Excel 2003 Continued

"It is a very pleasant course that you can follow at your own pace. If you have any questions, there is a teacher who helps you immediately. Really recommended." - Rating: 10.0

J. Peters-van Gent, Kuehne Nagel Logistics B.V. - Excel Basic

"I experienced the training as very instructive in a quiet pleasant environment and led by an expert teacher. Thank you." - Rating: 8.0

R. Terlouw, Zegro Centre Rotterdam - Excel 2003 Continued

"Good basic training, I use the programme myself on a regular basis, but I learned a lot of useful tips and tricks that will certainly make it easier in everyday use." - Rating: 9.0

M. van de Berg, Besam - Excel Basic

"Learned a lot in a short time in a very clear and accessible way. Very efficient method for me!" - Rating: 9.0

E. Jongbloed, Randstad - Free webinar PivotTables in Excel 2010 and 2013

"I can recommend this training to every office user. The material and the pace of work can be adapted to one's own situation and there is ample opportunity to ask questions, which are then answered." - Rating: 8.1

M. Oostdijk, ROC Mondriaan - Excel Macros and working with other programmes

"The overall impression of the course is good. The course is clearly useful and you can use it immediately at work. The teacher has enough knowledge and listens well to the course participants." - Rating: 8.3

R. Spelt - Excel Basic