Excel Macros and Working with Other Programs course
In this course you will learn to record, edit and use macros to automate actions in Excel. You will create links with Word, Access and PowerPoint, optionally with Copilot.
NRTO quality mark- Automate tasks with macros
- Links with Word, Access and PowerPoint
- Practical examples from your own work
- Personal guidance at your level
- Optionally also working with Copilot in Excel
Your trainer: Raoul or Hugo 297 evaluations in total, average score 8.3. View the trainers
With macros you automate recurring tasks in Excel at the touch of a button. You learn to record, understand and adapt them, and to create links with Word, Access and PowerPoint. Optionally, we also pay attention to Excel with Copilot.
Description
In this course you work on automating repetitive tasks in Excel using macros. You record macros, run them, edit them in the editor and learn to trace errors. The difference between absolute and relative recording is also covered, as are the personal macro workbook and the use of templates.
An important part is the collaboration between Excel and other Office programs. You exchange data with Word, Access and PowerPoint, create connections with an external database and convert or import files. Sending workbooks and compatibility between versions are also covered. Optionally, the course pays attention to working with Microsoft 365 Copilot in Excel.
This course forms the second half of Excel Expert. The first half focuses on formulas, functions and pivot tables. You take the course as an open learning day, working at your own pace under the guidance of an experienced trainer. You can bring practical examples from your own work situation, so that the exercises match your objectives.
Topics
- Recording and running macros
- Editing macros and tracing errors
- Absolute and relative recording
- Ways to start macros
- Personal macro workbook
- Working with templates
- Integration with other Office programs
- Converting and importing files
- Exchanging data with Word
- Exchanging data with Access
- Connecting to an external database
- Sending and sharing a workbook
- Compatibility between versions
- Optional: using Excel with Microsoft 365 Copilot
Result
After this course you take work off your hands by recording, understanding and adjusting macros in the editor. You automate recurring tasks at the touch of a button and you know how to trace and resolve errors in a macro.
You will create links between Excel and other Office programs such as Word, Access and PowerPoint, and exchange data effortlessly with external databases. Optionally, you will also learn how to use Copilot in Excel to work faster with data and macros.
Target audience
This course is intended for Excel users who want to automate common tasks with macros and exchange data between Excel and other Office programs such as Word, Access and PowerPoint. You already have experience with Excel and want to take a step towards expert level. Would you also like to discover how Microsoft 365 Copilot can speed up your work in Excel? That is covered optionally.
Teaching method
You take this course in our open learning format. This means you work on assignments in a small group at your own pace and level. An experienced trainer moves around the room, answers your questions and helps you along where needed.
You decide which topics to focus on. Do you have an example from your own practice? Bring it along and tailor the exercises directly to your work situation. That way you work specifically on what matters to you.
Prior knowledge
You need a basic knowledge of Excel. For example, you can work with formulas, functions and pivot tables, or you have taken the Excel Expert part 1 course. Programming experience is not required: you will learn macros step by step during this course.
Comments
You work through the exercises at your own pace and can always ask the trainer for help. Optionally, the course also covers Excel with Copilot, so you can see how AI can support your workflow. You are welcome – and indeed encouraged – to bring your own practical examples.
Course format
This training is offered on the basis of our Open Learning teaching method. This means that you work independently, with active guidance from our trainer, to master the material. That way you can achieve your learning objectives at your own pace, without being held back by fellow participants working faster or slower. The trainer makes sure that you stay on schedule and meet your learning objectives. This form of learning leaves room for a tailored approach. You have the opportunity to bring in examples from your own practice and IT environment, so that your learning is even more specific. more...
Practical information
- Number of days
- 1 day
- Course times
- from 10 am to 5 pm
- Teaching hours
- 6 hours
- Education level
- Suitable for all levels
- Preparation time
- None
- Included
- Course materials and lunch on site
- Certificate
- At the end of the course you will receive a certificate of attendance
Language
The course is given in Dutch as standard. The trainer speaks English. English-language course materials can be used. If at least 3 participants register, the course can also be given entirely in English.
This course for your team?
Plan your own group on a date that suits you, at your office, at our premises or online. We tailor the content to your day-to-day work, and training a whole group is cheaper than individual bookings.
- Your date and location
- Tailored content
- Multiple groups or an academy are also possible
- More than 25 years' experience
The trainers for this course
Ratings from participants after completing their course, across all courses by this trainer.
What others say about this course
Excel Macros and Working with Other Programs course: average 8.3 from 7 reviews
"If you want to get acquainted with the use of macros, this is an excellent starting point. You can record and program macros. This course covers recording macros only. You learn programming during the VBA course. After completing this course you have a complete picture of how recording a macro works."
“This course is a good introduction to VBA/macros. It is a mix of theory and practice.”
“If you are looking for a programme to improve your chances on the job market, I would certainly recommend one of the courses, if only to refresh your knowledge!”
"Enjoyable course in which you learn the tricks of creating macros through simple but engaging exercises. Even a small part of Visual Basic is included, which gives you some idea of how a macro is built up in programming language."
"K. Algra, Gemeente Nijmegen - "An excellent course with good materials and plenty of exercises that tie in with everyday practice." - Rating: 7.0"
“The training course is focused, well structured and easy to follow and complete at your own pace within the time provided.”
“I can recommend this course to every Office user. The course material and the pace can be adapted to your own situation and there is every opportunity to ask questions, which are always answered well.”
“Enthusiastic trainer who explained everything clearly and understandably.”
“This course is a logical follow-up to the basics course. It is set up in such a way that people with somewhat less experience of Excel can also follow it well. With a bit of practice you can automate all kinds of tasks in Excel.”
“Learnit uses young, dynamic, motivated and well-trained trainers. The learning technique applied, both classroom-based and individual, is efficient.”
“A pleasant way of picking out from the complete set of course materials only those subjects you are interested in, without being worn out by matters you have no interest in.”
“The 'Advanced' Excel course follows on well from the basics and was still manageable for me. Now I just need to put it into practice. It was good to have a trainer there to help me with the questions I couldn't work out. You can also bring an example from your work that can be dealt with in the lesson. In the 2 courses I have now taken, several participants were helped to work through and solve a complex problem with the trainer's help and the formulas required for it.”
“Over the past 2 days I followed the Excel Basics course and it has made me a good deal more skilled with Excel.”
“Enthusiastic trainer who explained everything clearly and understandably.”
“The 'Advanced' Excel course follows on well from the basics and was still manageable for me. Now I just need to put it into practice. It was good to have a trainer there to help me with the questions I couldn't work out. You can also bring an example from your work that can be dealt with in the lesson. In the 2 courses I have now taken, several participants were helped to work through and solve a complex problem with the trainer's help and the formulas required for it.”
“An excellent way to extend your Excel knowledge. Your learning question and your Excel problems take centre stage. If you bring your own material, you solve your own issues during the course.”
“Even for participants with little or no experience of the subject, it is surprising how much you can learn in two days.”
“The open learning format is well worth recommending if you like working independently at your own pace. The trainer answers your questions when needed and is happy to give advice and extra useful information suited to your level. The course material is clear and lets you practise new skills several times so that you really master them.”
"'webinars are very handy for quickly picking up knowledge of specific parts within a particular program such as Excel, Crystal Reports etc etc'"
"The Excel Basics course is an excellent course for refreshing your memory and/or making working with Excel easier and faster. Partly thanks to the relaxed atmosphere created by the trainer and the opportunity to ask plenty of questions, my fellow participants and I found the course a pleasant experience."
"You can do a lot with Excel, but can you? At Learnit you can expand your knowledge using your own examples and questions. No unnecessary course material, just things that matter and can be applied in practice straight away. The 2-day course was well worth the time."
“It was an instructive course and you could learn everything calmly at your own pace.”
“I can do far more with Excel than before; I can conjure up database functions, pivot tables and charts in no time.”
“A pleasant way of working, own pace, own choice of subject, good, recent laptops and an agreeable location.”
“An excellent course for getting to know the possibilities of Excel in more depth once you already know the basics. Because of the individual approach, 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 the course material alone offers.”
"The material was explained clearly and effectively. The trainer was more than helpful and knowledgeable."
"Good, comprehensive course, clear materials, highly recommended!"
“Every single participant was enthusiastic. They all took something away from it. Nice that the course can be given at the office.”
"A.M. Rooyakkers-Smits, Makro Amsterdam - "The course is clear and well structured. Everyone can work at their own pace and level." Rating: 7.3."
“I loved to see the possibilities what you can do with excel. Hope to be able to use everything we have learned.”
“Excellent training, fits my role well, certainly if you have no experience with Excel. The guidance is excellent too.”
“Gaining more understanding and knowledge of Excel at your own pace. The group is fairly small, so there are minimal distractions. The organisation and the trainer are a breath of fresh air, and I am not easily satisfied.”
"If you want to get acquainted with the use of macros, this is an excellent starting point. You can record and program macros. This course covers recording macros only. You learn programming during the VBA course. After completing this course you have a complete picture of how recording a macro works."
“Especially if you work with lists, this is a very useful advanced/expert course”
“The Excel 2003 Advanced course I took at Learnit was very instructive and taught in an enjoyable way. The exercises matched the questions I had well. There was also plenty of time to deal with "problems" I had brought along myself and questions about the possibilities.”
“Do you want to get more out of Excel in your daily work? Then this is a good step in the right direction!”
“If you have basic experiance with Excel and you want to learn quick what oppertunity's Excel has, than you really have to contact Learnit for a quick introduction.”
"The Excel Pivot Tables, Functions and Formulas course gave me a great deal of inspiration for applying things in my work. Highly recommended. At the end of the day I went home enthusiastic, with a head full of new ideas and plenty of energy. That is how it should be!"
“The first impression/introduction was and is good.”
“For anyone reading this who deals with Excel a lot at work, this is definitely worth recommending. Even though you think you know Excel, there are certainly plenty of possibilities within the program that you did not yet know about and that you can practise and apply at work after the course.”
“Well-organised course given by a professional. As far as I'm concerned, highly recommended!”
“A revelation: the structure of the learning, the guidance and, as a result, the outcome. With a well-catered lunch – an example for anyone giving courses.”
“Excel is generally used for < 20% of what it is capable of, and given the cost of the package it is advisable to find out what the full 100% of possibilities are.”
“Interesting course. To really master all the material, it is advisable to set aside enough time for it.”
“For a beginner like me this was a very pleasant and concise training course. Starting from a low level, I gained a lot of confidence and can now genuinely put what I have learned into practice.”
“The Excel Advanced course fully met our expectations. The learning objectives were completely achieved and both the less experienced and the more advanced users learned new Excel applications.”
“It is enjoyable and very instructive, definitely recommended. I learned a great deal from it and it will be of much use to me in the future.”
“An interesting and instructive course with plenty of variety”
"I learned a great deal from the Excel Basics course. You can follow it in a quiet setting, at an easily accessible location and with a professional trainer, at your own pace. Course material consisting of a clear book alongside appealing examples in Excel to practise with. In short: highly recommended!"
"Good, I learnt a lot of things that I can use in my work."
Training formats
Classroom
1 day€ 525,-- Pleasant venue with a good trainer
- Small groups
- Inspiring and motivating
In-company
Bespoke trainingOn request- 100% for your group
- Bespoke training
- At your place or ours
Workshop
Up to 4 hours for groupsOn request- Suitable for events
- Interactive and inspiring
- Large groups too
Private training
At our place or yoursOn request- 100% just for you
- Achieve a lot in little time
- Whenever you want