Excel Advanced course
In this course you will learn to work with advanced Excel functions such as pivot tables, lookup functions, subtotals and macros. Optionally, you can also cover Excel with Copilot.
NRTO quality markFree cancellation up to four weeks before the start, so feel free to book now.
In brief. Excel Advanced 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 € 1050,- excl. VAT per participant, including course materials, lunch on location and a certificate of attendance. For a team or department we also deliver this course in-company.
- Straight to advanced Excel user
- Practical examples from your own work
- Working with Copilot in Excel
- Working smartly with pivot tables and macros
- Guidance from a skilled trainer
Your trainer: Pascal, Bart, Raoul or Hans 1.773 evaluations in total, averaging 8,5. View the trainers
With the Excel Advanced course you take your spreadsheet skills to an advanced level. You work with pivot tables, advanced functions, macros and lookup functions. Optionally, we also cover Excel with Copilot, so that you can use AI for smarter analyses.
Description
In this course you build on your basic knowledge of Excel and get to work with the programme's advanced functions. You learn how to make complex information clear and how to present it using pivot tables, charts and slicers. You also work with advanced formulas such as COUNTIF, SUMIF and VLOOKUP, and discover how to use logical and financial functions.
You also learn to work with subtotals, names for cells and ranges, and automatic table formatting. You automate repetitive tasks with macros, so that you work faster and more efficiently. The course optionally covers Excel in combination with Microsoft 365 Copilot, the AI assistant that lets you analyse and edit data even faster.
At the start of the day your trainer discusses your starting level and learning objectives, so that the topics match your own practice. You can bring your own work examples, and when booking you indicate which version of Excel you use, so that you work with suitable course materials.
For teams and organisations. We also deliver a follow-up Excel course for an entire department in-company. If you wish, we can work with examples from your own day-to-day practice.
Topics
- Getting to know the interface: what is where?
- Formatting tables automatically
- Working with cell styles and themes
- Advanced functions: COUNTIF, SUMIF and AVERAGEIF
- Financial functions: PV, FV and PMT
- Logical functions: AND and OR
- Nested functions: IF and AVERAGE
- VLOOKUP and HLOOKUP
- Assigning names to cells and ranges
- Working with subtotals at several levels
- Creating and adjusting pivot tables
- Filtering with slicers
- Automating repetitive actions with macros
- Optional: using Excel with Copilot
Result
After this course you will work confidently with Excel's advanced functions. You will create clear pivot tables, use slicers to filter quickly, and apply logical and nested functions to carry out complex calculations. You will work with subtotals, VLOOKUP and HLOOKUP, and automate repetitive tasks with macros. Have you opted for the optional Copilot in Excel module? Then you will also know how to use the AI assistant to gain insight from your data more quickly. You can rightly call yourself an advanced Excel user.
Target audience
This course is intended for anyone who has mastered the basics of Excel and now wants to get to grips with the advanced functions. Think of employees who regularly work with large volumes of data, produce reports or carry out analyses. If you want to work faster and more efficiently with pivot tables, formulas and macros, this course is also right for you.
The course is also suitable for teams that know the basics and want to take the next step together, such as a control department or a planning team.
Teaching method
You take this course in our open learning format: a full course day on which you work independently in a small group using a digital learning environment and clear course materials. An experienced trainer is present all day to guide you, answer questions and think along with your own practical examples.
You work through the topics at your own pace and decide for yourself where to spend extra time. That way you work purposefully on the functions you use most in your job, from pivot tables and advanced formulas to macros and, optionally, Copilot in Excel.
Prior knowledge
You are already comfortable with the basics of Excel. You know how to build formulas, format cells and carry out simple calculations. If you have taken the Excel Basics course or have comparable work experience, you are in the right place here.
Comments
None in particular.
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 Advanced course: average 8.5 from 77 reviews
“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.”
“In two days a good Excel Advanced course was delivered here in a practical way, with an excellent trainer and at an excellent location.”
“My impression of this course is excellent! Nothing but praise....”
“A good, instructive course.”
“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.”
"Insight into the possibilities of Excel that you know exist but have not yet applied yourself."
“The independent way of working really appeals to me in this course concept. You can also bring along problems from your daily practice, which then get attention.”
“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.”
"I thought everything was good! Perfect"
"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."
“Good, clear explanations. The trainer also takes the time to answer questions along the way.”
“Very useful training course! You take home a good reference manual in which you can look things up. The trainer has a great deal of knowledge and explains things well. Recommended!”
“It is an excellent course with clear course materials. I learned a great deal from it.”
“The course book clearly sets out what you have to do and can do. The trainer is very willing to explain things further. There is plenty of scope to work with your own examples and files.”
"It shows how Excel works in a simple way, very accessible for people who are not familiar with Excel."
“Learnit is a really good training organisation. What I like is that you also get the book, so you can always practise.”
"A course with strong content, in which good course materials are used to teach new things effectively and efficiently."
"I had never had any Excel training before, but I already had a reasonable command of the basics through the daily work I do. By taking this Excel course it is easier for me to carry out my daily work in a simpler way thanks to all the new knowledge I have gained."
“For me this is a very pleasant way of learning, as you can work at your own pace. There was also extra course material available on top of the course being taken. Very pleasantly organised.”
“A good, practical course that you can do at your own pace. There is plenty of room to ask questions while still working at your own pace.”
“Everything was interesting and useful.”
“Clear, personal training focused on your own practical situation, which makes it easy to apply in practice. The course is taught in small groups, so there is enough attention for every participant. All of this in a relaxed atmosphere – highly recommended!”
“An interesting and instructive course with plenty of variety”
“Very good training course, clear explanations. The atmosphere is good because the groups are not too large. The trainer is highly knowledgeable and takes all the time needed when there are questions. Very handy and usable in practice. Learned a lot that I can put to good use.”
“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.”
“An excellent course for people who use Excel daily or weekly and want to simplify its practical application.”
“Do you want to get more out of Excel in your daily work? Then this is a good step in the right direction!”
“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.”
“A good coursebook with exercises that let you work at your own pace. You can ask the trainer for help at any time.”
“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.”
“A pleasant way of working through the material. A book with clear instructions and a trainer in the background who answers questions!”
“I took the Excel course to broaden my overall knowledge, and I found this course very suitable for that.”
“Training at your own pace. Self-study, so you can approach the parts that matter most to you.”
"A. Hannink, Camposol - "Good basic and follow-up courses with a professional teacher and good course materials." - Rating: 8.3"
“Sjoerd Jellema made the course personal by explaining the material with exercises, which I then applied myself. Sjoerd is a pleasant course leader who has a good command of the subject matter but also carries the group along with the material being covered. I found the course very practical, and cases I brought along myself were also dealt with. This brought the theory to life in practice.”
"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."
“Even if you only have basic knowledge and experience, you can learn a great deal from this course. Learning tricks that can make your work easier and give you a better overview.”
“Enjoyable course, learnt a lot and everything at my own pace.”
“I loved to see the possibilities what you can do with excel. Hope to be able to use everything we have learned.”
“Good course based on the individual wishes of the client”
"A good course covering many topics in Excel. It gives you a solid introduction to using various formulas and features of Excel."
“The Excel 2007 for advanced users course that I took at Learnit was taught in a clear manner by a very knowledgeable and well-motivated trainer.”
“Interesting course. To really master all the material, it is advisable to set aside enough time for it.”
“The Excel 2007 Intermediate course is very well set up; interesting topics and applications that can be used at work straight away after practising.”
“Hands-on course that helps you in your day-to-day work”
“Used Learnit for the first time and was pleasantly surprised by the concept. Small group and plenty of individual attention. There were enough training methods available through the extensive course materials.”
"A good course, a pleasant trainer, and many topics that are personally useful to me in my work."
"A good, practice-oriented course that allows you to get started quickly yourself and to improve your daily working methods and make them more efficient."
“A good mix of explanation with examples and then getting to work on exercises yourself.”
“Very well prepared training with very easy to follow exercises that will make excel look less of complicated system.”
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 during the Excel Intermediate course?
How long does the Excel Advanced course take?
Do I need prior knowledge for the Excel Advanced course?
Does the Excel Advanced course also cover Copilot for Excel?
Which versions of Excel is the Excel Intermediate course suitable for?
Can the Excel Advanced course also be followed in-company?
When do you choose a classroom Excel Advanced course instead of a YouTube tutorial or self-study?
What sets the Excel Intermediate course apart from an Excel Advanced course or a specialist pivot table course?
How quickly can I apply what I have learned in the Excel Advanced course to my daily work?
Is the Excel Advanced course suitable if I mainly work with large datasets and reports?
What is the difference between the Excel Advanced course at Learnit and an online course or a Microsoft certification?
In which situations is it worth learning Copilot in Excel alongside the standard intermediate functions?
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.