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 of three hours
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.


References

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

"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

"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

"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

"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

"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

"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

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

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

"Learnit hooked us up with the right trainer. Our training need was not standard training and this was well understood by Nick. Everyone we spoke to from Learnit was pleasant. We're very happy with your professionalism and flexibility". - Assessment: 9.4

L. van Eekelen, VU Amsterdam - Excel Revolving tables, formulas and functions

"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

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

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

"I can do a lot more with Excel now than I did before; I can conjure up database functions, pivot tables and graphs." - Rating: 8.0

P. Kooijmans, Randstad Nederland B.V. - Excel Turning tables, formulas and functions

"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

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

Tuncay Sahin - Excel VBA

"Excellent and very professional training and very applicable in practice." - Assessment: 9.1

F.H. Bartsch - Excel Basic

"Recommended. Good level, professional guidance and good material. I especially enjoy the shortcuts and knowledge of new quick solutions". - Rating: 9.0

E.J.F. van Meerwijk - Excel 2010

"It's a very pleasant course that you can take at your own pace. If you have any questions, there is a teacher who will help you immediately. Highly recommended." - Rating: 10.0

J. Peters-van Gent, Kuehne Nagel Logistics B.V. - 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

"If you want to follow a tailor-made training where everything is well arranged and cared for, I would recommend everyone learnit. Have very good experience. "

Ralph van Erkel, Wierden and Borgen - Excel Basic

"Clear and uncluttered Excel training! You go home with much more knowledge and application possibilities" - Assessment: 7.2

Ruud Klessens, Coty Prestige - Excel 2002 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

"This training is really recommended, small group of people, serious teacher and a lot of learning." - Review: 8.7

S. Double, Ikazia Hospital - Excel Basic

"The training has given me a good tool to do my job better and make it easier for me." - Assessment: 8.4

P. Coert, Cofely - Excel Basic

"This organization will help you gain knowledge in a playful manner. So no hours of theoretical stuff that you get around your ears, but just do how you're going to use it in practice". - Assessment: 8.1

R. M. F. van Aalten, Rabobank - Excel Basic

"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 training was good on time. Learned what I came here for." - Assessment: 8.3

Ton Bollebakker, Veronica Publishing - Excel Revolving tables, formulas and functions

"Pleasant way of working, own pace, own subject choice, good, recent laptops and an enjoyable location." - Rating: 7.1

J. Peerdeman - Excel Sequel

"There will be training in a fun way. You can get to work yourself and if you have any questions, time will be taken for you." - Assessment: 7.3

Ragonda Helderman, Yarden Funeral Organization N.V. - Excel Turning tables, formulas and functions

"Just valuable training. Professional, up-to-date, high-level teachers. All in all: You can't miss a training like this" - Review: 9.9

T. Bartha - Excel Revolving tables, formulas and functions

"The advanced Excel 2007 course which I followed at Learnit, was taught in a clear manner by a very businesslike and highly motivated instructor. - Rating: 9.0

Willy Nanlohij, Stadsbank East Netherlands - Excel Continued

"An interesting and instructive training with lots of variety" - Review: 7.8

Tessa Spruijt, Simple B.V. - Excel Continued

"Fulfilled my expectations perfectly, a world opened up for me. A very quiet teacher, who took all the time for you and explained everything clearly so that you also understand what you are doing. - Rating: 8.0

Mr. van de Greijn, Besam Nederland B.V. - Excel Basic

"Fulfilled my expectations perfectly, a world opened up for me. A very quiet teacher, who took all the time for you and explained everything clearly so that you also understand what you are doing. - Rating: 8.0

Mr. van de Greijn, Besam Nederland B.V. - Excel Basic

"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

"I thought it was a good training offered by Learnit. You're doing your own lessons on your own. The teacher provided us with useful tips and was also very helpful with questions". - Assessment: 7.1

P.Meijer, Groningen District Court - Excel Basic

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

A.J. Black, EDventure - Excel Basic

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

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

"Well cared for and clearly explained!" - Assessment: 9.1

A. Mr. Prorokova, Nieuwe Borg B.V. - Excel Basic

"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

"Very professional trainer, good teaching material, good clear assignments and cases which challenge you and motivate you to come to the solutions. Room for questions from your own organisation! Super fun instructive training, therefore difficulty to stop at the end of the training days! Thank you!"

- Excel Basic / Expert

"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

"Great training! At your own pace and with answers to your questions you can master the Excel training. Very enlightening. I thought I knew a lot about Excel..." - Rating: 9.0

H. Warnier, Servatius Housing & Real Estate - Excel 2003 Continued

"As a steel construction calculator I had worked a lot with excel like layout, colors and lines, but lacked the basics of formula making and functions, for my work (cutlery, drawings and quotation) I am constantly calculating hours and prices and surcharges. Also the additional work (adding) is now automatic and therefore faster and error-free. So this course was very instructive for me." - Assessment: 8.3

Walter Dekkers, ASK Romein B.V. - Excel Basic

"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

"Excellent professional training with lots of "tips & tricks" for every starting level."

- Excel Turning tables, formulas and functions

"A lot of practice during training." That's very nice. You learn it by doing it. Skilled trainer who'd be happy to help you." - Assessment: 9.4

Sandra de Haas, Euler Hermes Credit Insurances - Excel 2002 Basic

"Also for non-computer specialists a fine training that you can certainly learn a lot from." - Assessment: 8.4

W. Brandt, Besam Nederland B.V. - Excel Basic

"A very meaningful workout. And at learnit certainly well taken care of! Teacher was very skilful and helped a lot." - Rating: 9.7

M. den Ouden-Heemskerk, Rijnmond Care Group - Excel 2002 Basic

"You can save yourself a lot of work, especially with the tips and tricks. The limitations of the package are also discussed and that helps too". - Review: 7.8

Thijs Janssens, BIJ12 - Excel Revolving tables, formulas and functions

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

M. Hutterd, Geas Energy Guard - Excel 2003 Expert

"The training is well put together with a lot of practice. Enthusiastic teacher with a lot of professional knowledge. The treated material can be repeated at home or at work thanks to the workbook and disk, ideal". - Assessment: 8.6

P.A. Pollen, CBS - Excel 2002 Basic