Learnit Training
Course Excel macros and collaborate with other programs
  • Small groups
  • Covid-19 safe
  • Experienced teacher
  • Possible online
  • Practical training

Never perform an operation in Excel too often again? In this one-day training you will learn how to automate operations using macros and how to make Excel work together with other programs.

Yes, I want to know more

"Training is focused, well set up and at your own pace within sufficient given time to properly follow and finalize."-Rating: 8.7

learnit Excel macros and collaborate with other programs

Course Excel macros and collaborate with other programs

Do you want to automate common operations in Excel? That's possible with macros. Fortunately, this is not difficult and anyone can learn this. With macros, you can record a series of actions and repeat them at the touch of a button. During this training you will learn to create, understand and edit macros. Attention is also paid to creating links with other Office programs such as Word, Access and PowerPoint.

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

Topics

  • Recording and running macros
  • Change Macros and debug
  • Absolute and relative recording
  • Starting possibilities
  • Personal Macro Workbook
  • Templates
  • Integration
  • Convert or Import files
  • Exchanging data with Word
  • Exchanging data with Access
  • Connect to external database
  • Send Workbook
  • Compatibility

The Trainer

You will be supervised by a social and skilled trainer during the 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.

What version? 2007, 2010, 2013 and 2016.

During the registration you can fill in the version you are using. Our planners will ensure that you can follow the training in the correct software version with the material that is written for this version.

Practice

It is possible to take practical examples of your work situation so that you can get more targeted and clear what your goal is of this training. The subjects and exercises are tuned accordingly.

After

After the training, you will be able to create links to other programs, such as Access and PowerPoint, in macros. You know how to apply macros to automate common actions and how to customize macros in the editor.

Prior knowledge

For this training, knowledge at the level of Excel Basic Level recommended. To determine how much information you have and which course is right for you, we propose a online course guide Available.

Note

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 1 day 2 sessions
Price per day, excl. VAT € 375,- € 290,-
Total, incl. VAT € 453,75 € 350,90

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 2 sessions of 3 hours, spread over 2 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 course Excel Macros and collaboration with other programs has been assessed with an average of 8.4.

"Enthusiastic trainer who has explained everything clearly and comprehensibly." - Rating: 8.0

J.A. Ramesar, CEVA Logistics - Excel Macros and collaborate with other applications

"Fun 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 an impression of how a macro is built up in programming language". - Rating: 8.0

R.A. Ritsma, Dr. Oetker - Excel Macros and collaborate with other applications

"I can recommend this training to any office user. The teaching material and the pace of work can be adapted to your own situation and there is every opportunity to ask questions, wherever there are good answers". - Assessment: 8.1

M. Oostdijk, ROC Mondriaan - Excel Macros and collaborate with other applications

"Training is focused, well set up and can be completed at your own pace within sufficient given time". - Review: 8.7

J. Mols, Meulenhoff Bookery - Excel Macros and collaborate with other applications

"This course is a logical follow-up to the basic course. It is designed in such a way that even people with less experience with Excel can follow it well. With a little practice, you can automate all kinds of tasks in Excel." - Rating: 9.9

Peter Anuels, Praclox BV - Excel Macros and collaborate with other applications

"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

"If you're looking for training to increase your chances on the job market, I'll definitely recommend one of the courses, if only to refresh your knowledge!" - Assessment: 7.4

J. Blue - Excel Macros and collaborate with other applications

"A very professional traing, excellent applicability and easy to follow." - Assessment: 9.1

A. Hannink, Camposol - Excel Basic

"Good clear explanation. Teacher also takes time for questions in between." - Review: 8.8

M.H. Dijkslag, Security Region - Excel Continued

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

E. Hijstek, Zig Web software - Free webinar Turning Tables in Excel 2010 and 2013

"Good alternation of explanations with examples and then work on exercises yourself." - Assessment: 8.3

Manja Tijssens, RINO Amsterdam - 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

"Training is focused, well set up and can be completed at your own pace within sufficient given time". - Review: 8.7

J. Mols, Meulenhoff Bookery - Excel Macros and collaborate with other applications

"The training is well focused on practical use, is presented in a clear way and is designed to be easy to follow for all levels". - Rating: 9.7

Willem Klamer, Dutch Gasunie - Excel 2003 Basic

"The training Excel 2010 follow-up was given by an expert trainer. The book of assignments you had to go through yourself was varied. The two teaching days flew by. Lesboek met opdrachten niet volledig doorlopen so continue to finish at home because the trainer has sent a link". - Review: 7.6

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

"The basic course excel 2007 that I followed at Learnit in Groningen gave me in 2 intensive days many tools that I can use on a daily basis. The result is above expectation. The shortcut on my desktop excel 2007 has changed in 2 days from an abracadabra link, to a calculator where I can create and save not only normal sums, but also minimals, maximals, graphs and averages". - Review: 7.7

Joop van Gogh, Branch Manager of the Appingedam Welding Technology Camp House - Excel Basic

"Training is focused, well set up and can be completed at your own pace within sufficient given time". - Review: 8.7

J. Mols, Meulenhoff Bookery - Excel Macros and collaborate with other applications

“Goede, leerzame, interessante cursus. Heb nieuwe functies ontdekt in excel waar ik het bestaan niet van wist! Dus zeker nieuwe dingen geleerd!” - Be­oor­de­ling: 9.0

S. van Dartel, Vesting Finance - Excel 2003 Expert

"Did the excel course to broaden my general knowledge, and I thought this course was very suitable for that." - Review: 7.7

Pierre Vugts, Mettler Toledo Product Inspection B.V. - Excel Continued

"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

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

I. Beuving - Excel Basic

"Fine course, very nice that you get to work with the book yourself and the teacher walks around helping you when you need it." - Rating: 8.0

M.J.C. den Otter, Phas Beheer - Excel Basic

“Excel training is definitely useful in case you work every day with this program. Workbook is very professional and easy for understanding. Trainer helps in case you need and there is possibility to have this course in English.” - Be­oor­de­ling: 7.7

N. Sennikova, Kuehne & Nagel - Excel Expert

"You'll learn the basic skills of Excel in two days." - Assessment: 7.3

R. in Green, Cofely. - Excel Basic

"The training is well set up. You learn what you want to learn. What was especially nice was the fact that we discussed things that we as a team often run into in the field of work and that solutions were put forward for this. In this way you can apply it directly in your work and make your work easier". - Assessment: 8.1

S. of Tournai - Excel 2010

"I did the Excel 2007 Advanced Turntables course and I thought it was a good training, with a very capable teacher. Questions are answered well, knowledge of the teacher is very good. Highly recommended!" - Assessment: 8.3

M.H. Dijkslag, Security Region - Excel Continued

L.W. Mooi, Betonindustrie B.V. Concrelit - Excel Revolving tables, formulas and functions

"It's nice to take part in the course at your own pace, but with plenty of room for questions and comments! - Review: 7.9

H.G.G. Houx, Rabobank Netherlands - Excel Continued

"A simple basic Excel course that you can master in a short time with Excel by means of personal guidance and a course folder. This tool will have to serve to make you more and more proficient with Excel in the future". - Assessment: 7.4

H. Berkelder, CTH - Excel 2003 Basic

"Good training, learned a lot from it and will certainly enjoy the work." - Assessment: 8.3

Y. Van Bijnen-Hermans, Shoeby - Excel 2003 Continued

"Learnit makes use of young, dynamic, motivated and well-trained teachers. The applied learning technique, both classroom and individual, is efficient". - Rating: 8.0

E. Geelen - Excel Expert

"For people who have done little with computers, this is a great training." - Assessment: 8.1

René Fiere, CTH - Excel 2003 Basic

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

C. Engberink, KOAC-NPC - Excel Basic

"What appealed to us about the learning method of learnit; Each of the groups can go through the subject matter in their own way, in case of questions and/or remarks the teacher indicates the correct working method. In this way everyone has gone through the course material at their own level and/or pace". - Rating: 8.0

M. Chaudron, Leo the Great - Excel 2010

"Never thought I could learn so much about these programs. I'm also very glad I followed them." - Rating: 9.0

P. Sahl, NUON - Excel Basic

“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

"The basic course Excel 2010 will give you an excellent idea of what the new Excel has to offer. You will be amazed by the new possibilities with graphs. In 180 pages you will not become a guru, but you will become a lot more handy". - Rating: 9.0

P. Kersten, ABN AMRO - Excel Basic

"Webinars are very useful to quickly gain knowledge of specific components within a specific program such as Excel, Crystal Reports etc.'" - Rating: 8.6

R. Klinge, SAHZ - Free webinar Turning Tables in Excel 2010 and 2013

"'Expert customization, highly recommended!" - Rating: 9.0

F. van Dorst, DASD Holding - Excel Revolving tables, formulas and functions

"A complete training with clear exercises given by a very experienced and enjoyable teacher. Highly recommended." - Assessment: 8.1

J.Dijkstra, Stam B.V. - Excel 2007

"If in doubt, be informed by Learnit. These 2 days have found interesting all the more that this course was taught in an expert way." - Rating: 8.8

H.J.M. van Noorbeek, Cofely Netherlands N.V. - Excel Sequel

"Practical training with good personal guidance in an optimal environment." - Rating: 9.0

Mr. van Moorst - Excel 2003 Continued

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

- Excel Continued

"A nice way to work your way through the material. A book with clear instructions and a teacher in the background answering questions!" - Rating: 9.0

J. Coesmans - Excel Continued

"A short course in which you can clearly indicate what the points of interest are for you, so that you can elaborate a little more on them. Clear teaching material and the exercises are presented simply and clearly". - Review: 7.6

T. Stickelbroeck, DB Schenker Rail Nederland N.V. - Excel 2003 Turning 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

"A must for anyone who wants to master the basics of Excel. Excellent teaching material which can be used at home and at work as a reference work. Because of the clear and well constructed lesson material, this is an excellent self-study". - Assessment: 9.4

A. Vermeulen, DMN Machinefabriek Noordwijkerhout BV - Excel Basic

"The teacher takes the time and explains well." - Rating: 8.0

"If you're looking for training to increase your chances on the job market, I'll definitely recommend one of the courses, if only to refresh your knowledge!" - Assessment: 7.4

J. Blue - Excel Macros and collaborate with other applications

I. Bojovich, Robert Walters - Excel Basic

E-Learning

Blog

Excel Expert E-Learning