In this e-learning course you will explore advanced Excel functions, pivot tables, formulas and collaborating in workbooks. Copilot in Excel is optionally covered as well.

Your trainer: Raoul 283 evaluations in total, averaging 8.3. View the trainers
Want to go beyond the basics of Excel? In this e-learning you dive into pivot tables, advanced formulas, macros and sharing workbooks. You work at your own pace, from anywhere. Optionally, you also cover Excel with Copilot.
In this e-learning you build on your basic knowledge of Excel and work towards expert level. You get to know advanced functionality and go into more depth on formulas, pivot tables, conditional formatting, charts and protecting and sharing workbooks. Topics such as advanced function calculations, scenario management, macros and collaborating on workbooks are also covered.
The course optionally also covers working with Microsoft 365 Copilot in Excel, so that you can experience how AI supports you with analyses and calculations.
You take the course entirely online, at a time and place that suits you. Through instructional videos, assignments and additional files you work through the material at your own pace. Once you have started, you have six months' access to the platform.
For teams and organisations. Several colleagues from a department can each take this e-learning course at their own pace, at a time that suits their work. You do not need to make time available at the same moment.
After this e-learning course you will work confidently with advanced Excel functions. You will build formulas with conditions, nested functions and array calculations. You will create pivot tables, filters and subtotals to analyse large volumes of data. You will protect workbooks, share them with colleagues and work together on the same file. You will also use goal seek, scenario manager and macros to organise your work more efficiently. Optionally, you will learn how to use Microsoft 365 Copilot in Excel to set up analyses and formulas more quickly.
This e-learning is intended for anyone who has mastered the basics of Excel and wants to learn how to make the most of the programme's advanced possibilities. Think of staff who regularly work with figures, lists or reports and want to tackle their work more efficiently with formulas, pivot tables and smart functions. Anyone curious about the optional use of Copilot in Excel will also find this course a good starting point.
The e-learning course is also suitable for roles in which you work with larger amounts of data and produce overviews or reports from it, such as in financial administration, control, planning, purchasing, HR and sales support.
You follow this course entirely as e-learning. You work independently through a series of lesson videos, assignments and additional files. After each topic you check your knowledge with an assignment. Only once you have sufficient command of the material do you move on to the next part. In this way you build up your skills step by step.
You log in via an online platform, so there is nothing to install. You can follow the course wherever and whenever it suits you, as long as you have a laptop and internet access. You can always stop part-way through and continue later, as your progress is saved automatically.
You have 6 months' access to the platform and each module takes around 7 hours. Within that period you can review the material as often as you like. Optionally, the course also covers working with Copilot in Excel.
You have a command of the basic operations in Excel, such as entering data, using simple formulas and formatting cells. No other specific prior knowledge is needed. A laptop with internet access is all you need to get started.
You follow this e-learning entirely at your own pace. Once you have started, you have six months' access to the platform, so you can plan at your leisure when to work through the material. Optionally, you can also cover Excel in combination with Copilot.
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.
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.
"Practical and instructive. A quick way to get a good grasp of Excel."
“A very pleasant way of learning, straight from the book with support from the trainer and being able to set your own pace.”
"I thought it was a good and worthwhile course. I learned a great deal from it. The trainer gave clear explanations and has extensive knowledge of Excel."
“The one-day Excel PivotTables, formulas and functions course is suitable for anyone who wants to get to know the anatomy of the PivotTable in a short time and master the basics.”
“Enjoyable course because you work through the exercises yourself at your own pace. Skipping things you already know is no problem at all.”
“Good course for beginners, even if you have no affinity with computers at all. Anyone can do it!”
“The course material is clear and it is pleasant to be able to work at your own pace.”
"It shows how Excel works in a simple way, very accessible for people who are not familiar with Excel."
“Never thought I could still learn so much about these programmes. I am also very glad that I took them.”
"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 course made a good impression on me. The material provided is excellent. Because I had not indicated in advance what knowledge I already had and what purposes I wanted to use the course for, the material offered was quite a lot for 2 days. So follow Learnit's advice and state this beforehand."
"A good training course for broadening your knowledge and skills in Excel, with plenty of opportunity to reflect on how to apply it in the workplace."
“It was pleasant to be able to work at your own pace and to ask specific questions whenever you got stuck.”
“If you run into problems with Excel in practice, take this course. Alongside the standard course material there is plenty of time to work through your own practical examples.”
"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."
“Completely up to speed with Excel again thanks to Learnit training.”
"K. Algra, Gemeente Nijmegen - "An excellent course with good materials and plenty of exercises that tie in with everyday practice." - Rating: 7.0"
“Very good course! Everything is perfectly organised and I would certainly recommend taking a course at Learnit.”
“No pressure to keep up with fellow participants who might be faster, as you would have in a classroom course. A trainer is on hand if needed and comes straight over when you ask.”
"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!"
"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."
“Hands-on course that helps you in your day-to-day work”
“Never thought I could still learn so much about these programmes. I am also very glad that I took them.”
“Good course, I learned a great deal from it and will certainly get a lot of use out of it at work.”
“If you want to take a tailor-made course where everything is well organised and well looked after, I would recommend Learnit to anyone. I have had a very good experience.”
“Excellent training - nice to be able to set my own pace - good support - clear course material - directly applicable in practice.”
“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.”
"The course was very well organised, the materials were in good condition and the content was very good too."
“Plenty of practice during the course, which is very pleasant. You learn by doing. A knowledgeable trainer who is genuinely keen to help you.”
“Very suitable for anyone who has worked with Excel before, but would still like to go through the fundamentals of the package once in order to build up solid basic knowledge.”
“A pleasant way of working, own pace, own choice of subject, good, recent laptops and an agreeable location.”
"Self-study, but with something extra. A good teacher with a great deal of subject knowledge, who genuinely thinks along with you about applying your objectives in your own working environment."
"Useful and interesting course!"
"I really appreciate being able to work through the material at my own pace."
“Pleasant course in which you can learn a great deal in a short time at your own pace.”
“The course is of good quality and is well geared to practical use.”
“Excellent course! I thought I knew Excel, but I still learned nice new things that I can apply on a daily basis.”
“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.”
“Never thought I could still learn so much about these programmes. I am also very glad that I took them.”
"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."
“Doing is learning”
“This training is excellent and very comprehensive, you can learn an enormous amount from it”
“Very good that courses are offered in this way! Useful explanation of pivot tables in Excel so you can start using them yourself as quickly as possible!”
“The course book and the software are very pleasant to read and work through. The trainer was particularly active in helping to solve problems. I am impressed by her knowledge, at various levels. She switches easily from one problem / level to another. Her explanations are very clear and motivating. She is also extremely welcoming. The location is easy to reach, by bike and by car. The reception is pleasant and professional. The lunch was excellently arranged, the staff very hospitable and attentive. Clean toilets! Highly recommended, I would happily take another course there. An organisation I would certainly recommend.”
“A straightforward Excel basics course that, through personal guidance and a course folder, gets you up to speed with Excel in a short time. This tool will serve to make you increasingly skilled with Excel in the future.”
“Enjoyable course, learnt a lot and everything at my own pace.”
"I really appreciate being able to work through the material at my own pace."
"I found the pace of the course and the trainer's assertiveness refreshing and dynamic."
"Even if you think you already know a lot about Excel, you always learn something new. The possibilities are enormous."
“The course material matched my level well (basics). The fact that everyone could work on their own assignments meant you could set your own pace, which I found pleasant, as I could focus on what mattered to me. The group was not too large, so there was enough time for individual questions to the trainer.”