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."
“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.”
"K. Algra, Gemeente Nijmegen - "An excellent course with good materials and plenty of exercises that tie in with everyday practice." - Rating: 7.0"
"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."
“The training course is focused, well structured and easy to follow and complete at your own pace within the time provided.”
“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!”
“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.”
“This course is a good introduction to VBA/macros. It is a mix of theory and practice.”
“An excellent introductory course in Excel in which everything is well explained and readily applicable.”
“I certainly found the training course instructive. Getting to work yourself and going through assignments as a group is a good mix for applying the knowledge properly. The trainer is also open to you bringing in your own cases, so that you are helped directly with your work as well. Very pleasant! In short: I thought it was a successful training course in which I was able to develop myself further in an enjoyable and welcoming setting!”
“Never thought I could still learn so much about these programmes. I am also very glad that I took them.”
"Excellent course if you want to understand the working methods and logic behind VBA/macros. It ultimately means that, in addition to recording macros, you are also able to write formulas and programs yourself. Gives you plenty to go on when exploring what is possible with VBA. I already knew something about recording macros, but this gave me insight into how VBA works and what to look out for. Great!"
"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."
"Excellent course if you want to understand the working methods and logic behind VBA/macros. It ultimately means that, in addition to recording macros, you are also able to write formulas and programs yourself. Gives you plenty to go on when exploring what is possible with VBA. I already knew something about recording macros, but this gave me insight into how VBA works and what to look out for. Great!"
"This training course is excellent for those who have a good grounding in Excel and want to improve further. The trainer was very professional and helpful. The right way to run this kind of course."
"A good course, a pleasant trainer, and many topics that are personally useful to me in my work."
“A practical course that you can actually do something with, and a course that does not take too long.”
“Good course, you get a lot of practical information that you can really put to use.”
“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.”
“For a quick introduction to macros, this is a fine training course for learning the basics.”
“A good coursebook with exercises that let you work at your own pace. You can ask the trainer for help at any time.”
“Training at your own pace. Self-study, so you can approach the parts that matter most to you.”
“A good mix of explanation with examples and then getting to work on exercises yourself.”
“An excellent course for people who use Excel daily or weekly and want to simplify its practical application.”
"Excellent trainer, very patient and willing to help. You can also bring your own practical examples to the lesson, to look at them together with the trainer and practise how to apply them. He is even willing to answer your questions by email after the course. Great service!"
“An excellent introductory course in Excel in which everything is well explained and readily applicable.”
“A short, clear course for someone who has worked with pivot tables little or not at all but would like to learn.”
"A course I can genuinely recommend to anyone who works with Excel and needs to do a bit more than the basics. The quality of the course material and the trainer's expertise are excellent. Every topic is covered in sufficient depth. The teaching method of working independently in a pleasant environment with a good atmosphere, together with the trainer's approach, helps you to remember what you have learned."
“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.”
“This course is a good introduction to VBA/macros. It is a mix of theory and practice.”
“Excellent training - nice to be able to set my own pace - good support - clear course material - directly applicable in practice.”
“The training course was manageable within the time set. I learned what I came for.”
“Good basic training. I use the programme regularly myself, but I learned plenty of handy tips&tricks that will certainly make day-to-day use easier.”
“A good course that lets everyone work at their own pace and level of understanding. I took the Excel 2007 Basics and Advanced courses at Learnit and it opened up a whole new world for me. I would recommend Learnit to anyone; good course material, professional trainers and a lovely lunch. You can take the course material home with you, so you can practise with it at home as well.”
“Enjoyable course because you work through the exercises yourself at your own pace. Skipping things you already know is no problem at all.”
“Had two days of training in Excel Basic 2013. The enjoyable assignments in the course material achieved more than years of struggling and trying on my own. Definitely worth it!”
“I found it an enjoyable and instructive course, with plenty of handy tips and facts about Excel, and I also learned a lot more about functions, pivot tables and VLOOKUP.”
“Very clear explanations. Definitely recommended for anyone who works with Excel and has never started with the basics. You learn a great deal about how Excel can be applied as a program and what it can do.”
“The assignments are very clear and easy to follow. There is also plenty of room to put forward your own input from your own work situation, so you can also address the issues you run into on a daily basis.”
“An intensive 2-day course from which you learn a great deal, and because there is room to discuss your work-related questions with the trainer, it fitted my personal learning objectives well.”
"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."
“Pleasant training course, small group, plenty of time for individual attention! Bring your own files so you can apply what you have learned straight away – I found that very worthwhile. You then come up against different questions than with the practice material.”
“Clear, easy-to-follow course with personal guidance.”
“Quality of the course materials, exercises and professionalism of the trainer: a solid pass!!”
“Learnit uses young, dynamic, motivated and well-trained trainers. The learning technique applied, both classroom-based and individual, is efficient.”
“A pleasant way of working through the material. A book with clear instructions and a trainer in the background who answers questions!”
“Simply a valuable course. Professional, up to date, high-calibre trainers. All in all: a course like this is not to be missed.”
“For people who have done little with computers, this is an excellent course.”
“A nice course, very pleasant that you can work through the book yourself and the trainer walks around to help you whenever you need it.”
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