Excel Expert course
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.
NRTO quality markFree cancellation up to four weeks before the start, so feel free to book now.
In brief. Excel Expert is a 2-day classroom course. You can take it in Amsterdam, Utrecht, Rotterdam and The Hague, among other locations, or online, in a group of no more than 8 participants. The price is EUR 1050,- excl. VAT per participant, including course materials, lunch on location and a certificate of participation. For a team or department we also run this course in-company.
- You become an expert in advanced Excel use
- Master pivot tables and macros
- Using What-If analyses and Solver
- Optionally working with Copilot in Excel
- Personal guidance at your level
Your trainer: Bart, Raoul or Mark 785 evaluations in total, with an average of 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.
Description
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.
Topics
- Advanced functions: text, date/time and financial
- Naming cells and working in three dimensions
- Building, filtering and analysing databases
- Database functions such as COUNTIF and SUMIF
- Building, adjusting and filtering pivot tables
- Adding slicers and timelines
- Calculated fields and pivot charts
- What-If analyses with Goal Seek, Solver, Data Table and Scenarios
- Recording, editing and debugging macros
- Absolute and relative recording, personal macro workbook and templates
- Exchanging data with Word and Access
- Connecting to external databases and importing files
- Sending workbooks and working with compatibility
- Optional: combining Excel with Microsoft 365 Copilot
Result
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.
Target audience
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.
Teaching method
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.
Prior knowledge
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.
Comments
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.
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
- 2 days
- Course times
- from 10 am to 5 pm
- Teaching hours
- 12 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
- Cancel
- Free up to four weeks before the start (cancellation terms)
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.
In-company
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.
All start dates
2 training days. Confirmed dates first, then in order of date.
- Mon 12 & Tue 13 October 2026Certain to go ahead Zwolle · 10:00–17:00 Enrol
- Mon 26 & Tue 27 October 2026Certain to go ahead Utrecht · 10:00–17:00 Enrol
- Thu 29 & Fri 30 October 2026Certain to go ahead Rotterdam · 10:00–17:00 Enrol
- Mon 23 & Tue 24 November 2026Certain to go ahead Zwolle · 10:00–17:00Free cancellation until 26 October Enrol
- Mon 9 & Tue 10 November 2026 Arnhem · 10:00–17:00Free cancellation until 12 October Enrol
- Mon 23 & Tue 24 November 2026 Online · 10:00–17:00Free cancellation until 26 October Enrol
- Tue 8 & Wed 9 December 2026 Eindhoven · 10:00–17:00Free cancellation until 10 November Enrol
- Mon 25 & Tue 26 January 2027 Amsterdam · 10:00–17:00Free cancellation until 28 December Enrol
- Mon 8 & Tue 9 February 2027 The Hague · 10:00–17:00Free cancellation until 11 January Enrol
- Mon 1 & Tue 2 March 2027 Zwolle · 10:00–17:00Free cancellation until 1 February Enrol
- Mon 1 & Tue 2 March 2027 Groningen · 10:00–17:00Free cancellation until 1 February Enrol
- Mon 5 & Tue 6 April 2027 Eindhoven · 10:00–17:00Free cancellation until 8 March Enrol
- Mon 3 & Tue 4 May 2027 Utrecht · 10:00–17:00Free cancellation until 5 April Enrol
- Thu 12 & Fri 13 August 2027 Rotterdam · 10:00–17:00Free cancellation until 15 July Enrol
No suitable start date? Send us a date request, and we'll look at the options together.
This course by city
- Excel in Amsterdam6 dates
- Excel in Arnhem5 dates
- Excel in The Hague6 dates
- Excel in Eindhoven10 dates
- Excel in Groningen5 dates
- Excel in Rotterdam10 dates
- Excel in Utrecht10 dates
- Excel in Zwolle15 dates
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 Expert course: average 8.1 from 14 reviews
“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.”
“Excellent course! I thought I knew Excel, but I still learned nice new things that I can apply on a daily basis.”
“The course was well tailored to the participants' wishes and learning objectives, thanks to good contact with the trainer beforehand.”
“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.”
"I have very good impression of the content of the training and specially of the trainer"
“Learnit uses young, dynamic, motivated and well-trained trainers. The learning technique applied, both classroom-based and individual, is efficient.”
"I found the pace of the course and the trainer's assertiveness refreshing and dynamic."
“Especially if you work with lists, this is a very useful advanced/expert course”
“A good course to regain and increase knowledge on valuable Excel skills to make worklife easier and faster”
"A good interactive course, with room to learn how to resolve situations from practice."
"M. Koeken, Continu B.V. - i> Well-structured training course with a knowledgeable trainer. - Rating: 8.8"
“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.”
"A good, committed trainer who tries to offer knowledge that matches the level and the questions of the participants"
"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."
“Very useful to get to grips with your own topics at your own pace. Guidance was perfect.”
"A good course for getting an impression of the many possibilities Excel offers."
"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."
“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.”
“Practice-oriented course in which you work independently on theory followed by practical assignments; a good mix of theory and practice.”
“Good course for beginners, even if you have no affinity with computers at all. Anyone can do it!”
“Learnit uses young, dynamic, motivated and well-trained trainers. The learning technique applied, both classroom-based and individual, is efficient.”
“It was an instructive course and you could learn everything calmly at your own pace.”
“It was pleasant to be able to work at your own pace and to ask specific questions whenever you got stuck.”
"Good course, in which you work independently a great deal. Good course material and a pleasant trainer, who helps immediately with questions and explains things very clearly."
"Very practically oriented, brought my own documents to practise with, so that what you learn can be put into practice straight away. A pleasant way of taking a course, plenty of practice material."
“It's good to be able to work through the course at your own pace. If you have questions, you can turn to the trainer.”
“Well-organised teamwork with a professional trainer.”
“I found the training very clear, a patient trainer, a pleasant atmosphere and working environment.”
“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.”
“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.”
“In two days a good Excel Advanced course was delivered here in a practical way, with an excellent trainer and at an excellent location.”
“Excellent course thanks to good guidance and clearly structured assignments that allowed the newly acquired knowledge to be applied straight away.”
“I very much enjoyed taking the Excel 2010 course and received a good reference work, so that I can practise some topics again at home.”
“Professional training, given by a highly knowledgeable trainer who was very well able to pass on his knowledge in a pleasant and clear way. The content of the training was very sound. The course material really did start from the basics. I found it very pleasant that I could set the pace myself. The course material and the set-up were professional and there was plenty of variety in the assignments/exercises.”
“The general impression of the course as a whole is good. You clearly get something out of this course and you can apply it at work straight away. The trainer has plenty of expertise and listens carefully to the participants.”
“Enthusiastic trainer who explained everything clearly and understandably.”
“It was a very successful training course. Learned a lot in an enjoyable and entertaining way.”
"The teaching method is very pleasant. You can discuss the problems you encounter at work at length during the course and arrive at a solution together with the trainer. Learnit informed me quickly and clearly about the course. I am very satisfied. I have also recommended you to my colleagues, several of whom are going to take a course."
“Excellently organised and very professional training, and highly applicable in practice.”
“I have been working with Excel for quite some time. However, I had no idea of everything you can do with it. I would recommend this course to any novice like me! Do it!!”
“I can do far more with Excel than before; I can conjure up database functions, pivot tables and charts in no time.”
"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!"
“I learnt a lot from it and in an enjoyable way. Thanks Dirk.”
"The course was useful, I enjoyed it, the trainer was great and I would certainly recommend it."
“Good course based on the individual wishes of the client”
"A. Hannink, Camposol - "Good basic and follow-up courses with a professional teacher and good course materials." - Rating: 8.3"
"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!"
“Very concrete tips on how to apply the system, so you learn how to make the system work in your favour.”
“A good way to get to grips with the basics of Excel.”
Training formats
Classroom
2 days€ 1050,-- 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
Frequently asked questions
Can I cancel free of charge?
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.
What will you learn in the Excel Expert course?
How long does the Excel Expert course last?
What prior knowledge do you need for the Excel Expert course?
Which version of Excel is used during the Excel Expert course?
Do I receive a certificate after the Excel Expert course?
Can the Excel Expert course also be taken in-company?
When should you choose the Excel Expert course instead of self-study via YouTube or an online course?
What does the Excel Expert course give you that you would not learn in a standard advanced Excel course?
Which type of Excel user is the Excel Expert course actually intended for?
Does the Excel Expert course also teach me how to use Copilot in Excel?
How soon after the Excel Expert course can I apply pivot tables and what-if analyses to my own work files on my own?
How does Copilot in Excel relate to the advanced features I learn in this course, and when do you use which?
Others also viewed
Want more? Your next course
Read our blog
Guaranteed to run: Mon 12 & Tue 13 October 2026 in Zwolle
This date already has enough participants. Free cancellation up to four weeks before the start, so you can secure a place now.