In this Excel Expert course you will work with pivot tables, advanced functions, macros and what-if analyses. You can also optionally learn to use Excel with Copilot.
Free cancellation up to four weeks before the start, so feel free to book now.
In brief. Excel Expert is a classroom-based course lasting 2 days. You can attend it in Amsterdam, Utrecht, The Hague and Rotterdam, among other locations, or online, in a group of up to 8 participants. The price is EUR-teken 1050 excl. VAT per participant, including course materials, lunch on site and a certificate of attendance. We also run this course for teams or departments in-company.



Your trainer: Bart, Raoul or Mark 791 evaluations in total, averaging 8,6. View the trainers
Do you want to get everything out of Excel? In this open learning day you will work with pivot tables, macros, What-If analyses and advanced functions. Optionally, you can also focus on Excel with Copilot. You work at your own pace, with expert guidance.
In the Excel Expert course you will delve into the most advanced possibilities of Excel and learn how to use these functions efficiently in your daily work. Among other things, you will work with pivot tables, formulas and functions, and you will receive extensive explanation of topics such as Goal Seek, Data Table, Solver and Scenarios. You will also learn to create 'What-If' analyses and get to work with macros and the exchange of data with other programs such as Word and Access.
The course combines the content of the Excel Pivot Tables, Formulas and Functions course and the Excel Macros and Working with Other Programs course. Optionally, the course also covers the use of Microsoft 365 Copilot in Excel, so that you discover how this AI assistant helps you with analyses and reports.
The course is offered in the open learning format. You work in a small group under the guidance of an experienced trainer, who decides together with you which topics you focus on. You can bring your own practical examples and indicate which version of Excel you work with, so that the course material matches it.
For teams and organisations. For a finance or control team we also run this course in-company. By arrangement, we work with examples from your own practice.
After completing this course you will be able to structure complex data in Excel and analyse it using advanced functions, pivot tables and what-if analyses. You work efficiently with macros, link Excel to other programs and present your results clearly. Optionally, you use Copilot to gain insights from your data more quickly.
This course is intended for experienced Excel users who want to get the most out of Excel. You already work regularly with formulas, functions and large amounts of data, and want to extend your skills with advanced techniques such as pivot tables, macros and what-if analyses. If you also want to combine Excel with Copilot as an option, this course is right for you.
The course is suitable for anyone who wants to use Excel for analyses and models, for example in finance and control.
You take this course in the open learning format. This means that on a course day you work through the material independently, at your own pace and at your own level. An experienced trainer is present all day to guide you, answer questions and provide explanations where needed.
At the start of the day you discuss with the trainer what your starting level is and which topics are important to you. This allows you to work specifically on the parts you need in practice. You can also bring your own practical examples, so you can get to work with your own working situation straight away.
You already work with Excel regularly and know the basics: formatting cells, creating simple formulas and charts. Experience with functions such as SUM and AVERAGE is useful. No other specific prior knowledge is required to get started.
You take this course as an open learning day: you work through the material independently and can turn to an experienced trainer at any moment for explanation and feedback. This way you set your own pace and focus on the topics that matter most to you.
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...
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.
Would you like to organise this training for a whole group or several groups? This can be cost-effective. For example, we can tailor the content entirely to your organisation, and training a whole group is also cheaper.
Are you looking at large numbers of participants or a complete academy? That involves a great deal. Consider planning and communication, for example, or identifying and agreeing the objectives and content of the training. Or differences in level, feedback mechanisms and safeguarding. Fortunately, Learnit has extensive experience in this field (more than 25 years) and we are happy to help you through this process.
2 training days. Confirmed dates first, then in order of date.
No suitable start date? Send us a date request, and we'll look at the options together.
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.
Ratings from participants after completing their course, across all courses by this trainer.
“Good programme that shows all facets of Excel for the more experienced user. The course material can be followed at your own pace, so you can work through parts you already know more quickly and give more attention to the rest.”
“The course was well tailored to the participants' wishes and learning objectives, thanks to good contact with the trainer beforehand.”
“A good course to regain and increase knowledge on valuable Excel skills to make worklife easier and faster”
"A good course for getting an impression of the many possibilities Excel offers."
"M. Koeken, Continu B.V. - i> Well-structured training course with a knowledgeable trainer. - Rating: 8.8"
“Very useful to get to grips with your own topics at your own pace. Guidance was perfect.”
“Well-organised course given by a professional. As far as I'm concerned, highly recommended!”
“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.”
"A. Effendi, Plan-it by Praxis B.V. - "For anyone looking for a tailor-made course, this is the right solution. The groups are small and the trainer is sufficiently qualified. You can state your learning objectives in advance and you receive fairly precise advice on which course suits you best. The course material is to the point and concludes with a case that you have to solve to see whether you can actually apply what you have learned. In any case, I learned what I wanted to know, and that is ultimately what it is all about." Rating: 8.0."
“Especially if you work with lists, this is a very useful advanced/expert course”
"A solid course in terms of content, delivered at a good pace, in which plenty of examples from business practice help participants make rapid progress in the world of Excel."
“Learnit uses young, dynamic, motivated and well-trained trainers. The learning technique applied, both classroom-based and individual, is efficient.”
"I have very good impression of the content of the training and specially of the trainer"
"A good interactive course, with room to learn how to resolve situations from practice."
“Excellent course! I thought I knew Excel, but I still learned nice new things that I can apply on a daily basis.”
"A good, committed trainer who tries to offer knowledge that matches the level and the questions of the participants"
"I found the pace of the course and the trainer's assertiveness refreshing and dynamic."
“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.”
"A good course covering many topics in Excel. It gives you a solid introduction to using various formulas and features of Excel."
“This training is excellent and very comprehensive, you can learn an enormous amount from it”
“Clear and straightforward course book, the level is good, a pleasant trainer who explains things clearly and anticipates at the right moments. The pace of the lessons is good, a very professional trainer. Instructive, in other words!”
“A good training course for non-computer specialists too, and you're sure to learn a great deal from it.”
“Excellent training - nice to be able to set my own pace - good support - clear course material - directly applicable in practice.”
“A short course in which you can clearly indicate what your points of attention are, so that these can be covered in more detail. Clear course material, and the exercises are presented simply and clearly.”
"If you want to do anything with data validation, this course comes highly recommended. After this course you will have learned a great deal about validating data."
"A professional course with an expert trainer"
“I am very happy I participated in this training. It was very useful and applicable to my job, I just wish I had this training years ago! I look forward to the WORD and PPoint trainings in the future.”
"Insight into the possibilities of Excel that you know exist but have not yet applied yourself."
“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.”
"This training course comes highly recommended. Clear, well-structured explanations. They take the time for you and you get an answer to all your questions. Really a great course."
“Excel 2007 was a refresher course for me. Just to get to grips again with how everything works. I got a lot out of it and can now make full use of Excel in my current role again.”
“The Open Learning format course allows you to practise and perfect the areas you work with on a daily basis. You can also expand your knowledge by working through the modules in the course book.”
“A useful way to spend your time; you can work at your own pace and get exercises for all the important topics.”
“The course is given by a trainer with a great deal of knowledge and a passion for Excel, which is contagious. The readers used are very clear and contain exercises you can work through yourself. Together, the readers from the basics and follow-up courses form a well-organised reference work for the workplace.”
“Professional, no-nonsense, practice-oriented course”
“An interesting and instructive course with plenty of variety”
“I can really recommend the course. After two course days you have learnt so much that you can work well with Excel. What's more, the course material is useful as a reference work.”
“A very pleasant way of learning, straight from the book with support from the trainer and being able to set your own pace.”
"Even if you think you already know a lot about Excel, you always learn something new. The possibilities are enormous."
“The training is given in an enjoyable way. You get to work on things yourself, and if you have questions, time is taken for you.”
“Excellent course material, a teacher with good knowledge of Excel.”
"A course at your own level where you get support as soon as you need it. This means you can learn efficiently at your own pace!"
"The course was very well organised, the materials were in good condition and the content was very good too."
“An organisation that has everything well arranged, responds quickly and thinks along with you.”
“In a short space of time you get to grips with the basics of VBA/Excel, with the opportunity to use your own practical examples.”
“Very concrete tips on how to apply the system, so you learn how to make the system work in your favour.”
“I took the Excel course to broaden my overall knowledge, and I found this course very suitable for that.”
“Enjoyable, inspiring course, I learnt things and picked up ideas I didn't know were possible with Excel and VBA. Even though I normally use Excel a lot in my daily work as a tool.”
“The training is clear and easy to follow at any level.”
“An enjoyable, interactive course that covers both theory and practice.”
Yes. Up to four weeks before the first day of the course you can cancel free of charge, without giving a reason. You then receive a credit note or, if you have already paid, a refund. If you cancel later, you pay part of the course fee: 25% between four and two weeks before the start, 75% in the two weeks before it and 100% in the final week. Moving to another start date is free of charge up to two weeks before the start, after that 50%. Sending a colleague in your place is always possible. Read the cancellation terms.
This date already has enough participants. Free cancellation up to four weeks before the start, so you can secure a place now.