In this course you explore advanced formulas, functions and pivot tables in Excel. You learn how to turn large volumes of data into clear overviews. Optionally with Copilot.
Free cancellation up to four weeks before the start, so feel free to book now.
In brief. Excel Pivot Tables, Formulas and Functions is a classroom-based course lasting 1 day. 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 525 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
You want to get more out of Excel with formulas, functions and PivotTables. On this open learning day you work at your own pace on practical assignments, with an experienced trainer alongside you. Optionally, you also spend time on Excel with Copilot.
In this course you delve into Excel's advanced functions and formulas. You work with date, text and financial functions, learn to build and filter databases, and get to grips with pivot tables and pivot charts. You discover how to turn large volumes of data into clear reports using slicers, timelines and calculated fields. Optionally, the course also covers working with Microsoft 365 Copilot in Excel, so you can see how AI helps you with analyses and formulas. You are welcome to bring your own practical examples, so that the exercises match your own working situation.
For teams and organisations. If your department works a lot with the same reports, we also run this course in-company. In consultation with you, we work with examples from your own practice, so that everyone practises pivot tables and formulas on situations they recognise.
After this course you will work smoothly with advanced formulas and functions in Excel. You build databases, filter large volumes of data and turn them into clear pivot tables and pivot charts. You add slicers and timelines, create calculated fields and quickly adapt your report to new questions. Have you opted for the optional module? Then you will also know how to use Copilot in Excel to extract analyses and insights from your data more quickly.
This course is intended for anyone who works with Excel regularly and wants to get more out of the program. You know the basics of Excel and now want to get to work with advanced formulas, functions and pivot tables in order to analyse and present large volumes of data clearly.
The course is also suitable for roles in which you regularly analyse figures and produce reports, such as in finance, control, sales, purchasing, HR and management support.
You follow this course in an open learning format: for a full day you work independently at your own pace on practice-oriented assignments in Excel. An experienced trainer is present all day to guide you, answer questions and think along about your working situation. That way you decide where to place the focus yourself, whether that is PivotTables, formulas or the optional work with Copilot in Excel.
You already work with Excel and know the basics: filling in cells, creating simple formulas and formatting worksheets. Would you like an even more confident start? Then take our Excel Basics course first. No other specific prior knowledge is required.
You take this course in our open learning format: you work through the material independently at your own pace, with a trainer on hand for explanations and questions. This allows you to focus on the parts that are most relevant to you. Feel free to bring your own practical examples, so the exercises can be tailored to them.
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.
Request a quote More about Excel Pivot Tables, Formulas and Functions in-company
1 training day. 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.
"I found this course very pleasant and instructive. It was tailored precisely to our needs after consultation."
“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.”
“Very concrete tips on how to apply the system, so you learn how to make the system work in your favour.”
“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.”
"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."
“I took the Excel 2007 pivot tables course for advanced users and I thought it was a good course, with a highly capable trainer. Questions are answered well and the trainer's knowledge can only be described as very good. Highly recommended!”
“This course explains the Excel options for pivot tables in a clear way and also gives a good explanation of the various available functions using practical examples.”
“Very educational course with a good individual approach that matches the participant.”
“An enjoyable and clear course that is easy to follow for novice "Excellers".”
“Learnit matched us with the right trainer. Our training need was not a standard course and Nick understood that well. Everyone we spoke to at Learnit was pleasant to deal with. We are very pleased with your professionalism and flexibility.”
"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."
“Practice-oriented course in which you work independently on theory followed by practical assignments; a good mix of theory and practice.”
“A practical course that you can actually do something with, and a course that does not take too long.”
“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.”
"Recommended, excellent course material and a good trainer."
"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!"
“Clear and suitable for everyone. The book is described very clearly with plenty of examples and assignments. Nice that you receive both the book and the CD-ROM with all the exercises, so that you can keep practising after the course and maintain your knowledge.”
"Excellent, professional training course with plenty of 'tips & tricks' for every starting level."
“An organisation that has everything well arranged, responds quickly and thinks along with you.”
“I think it is a good course with plenty of practical explanation. It opens up a world of useful information for someone with limited Excel experience.”
“An enjoyable experience and an instructive programme.”
“I can do far more with Excel than before; I can conjure up database functions, pivot tables and charts in no time.”
“Although I consider myself a quite advanced user, the course-instructor managed to teach me some new advanced options within excel which will make my life easier in the future.”
"An enthusiastic trainer who explains Excel very clearly with good examples. The assignments tie in with this very well. The Utrecht location is a pleasant place to attend the course and is easy to reach by public transport."
“Well tailored to the client's requirements”
“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.”
“The course fits my work very well. By bringing your own material you work purposefully and learn exactly what you want to learn. There is also plenty of scope and experience available to expand your knowledge further.”
“I am very satisfied with the course I attended, and certainly also with the practical applicability of the course material.”
"Good, comprehensive course, clear materials, highly recommended!"
“Professional, no-nonsense, practice-oriented course”
“Simply a valuable course. Professional, up to date, high-calibre trainers. All in all: a course like this is not to be missed.”
“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.”
“Very instructive course: recommended for anyone who works with Excel occasionally or regularly!”
“A clear and complete course, given by a highly competent trainer who conveys the course material in a clear and structured way.”
“Excellent course; the tips and tricks in particular can save you a great deal of work. The limitations of the package are also covered, and that helps too.”
“The training course was manageable within the time set. I learned what I came for.”
"An excellent course at a lovely venue. The trainer's personal approach makes sure it never gets boring. I learnt a great deal."
"The material was explained clearly and effectively. The trainer was more than helpful and knowledgeable."
“'Expert tailored work, highly recommended!!”
“A useful way to spend your time; you can work at your own pace and get exercises for all the important topics.”
“Clear course material with plenty of exercises and personal guidance from a trainer with extensive knowledge of MS Excel. Nice to be able to work with your own data if you want, and at your own pace. Highly recommended.”
“Efficient for people who already use databases in Excel a great deal.”
"Excellent course, the open learning format turns out to suit me very well"
“What I found pleasant is that you are in the same room with several people and one trainer, while everyone still follows their own course. Why? - you can share information with each other; - in this age of multimedia, where everyone is only concerned with themselves, you get into contact with others about, among other things, why they are taking this course; and - because there is only one trainer present, the course can be offered at an attractive price (LEAN thinking).”
“Anyone who works with a computer will really benefit from this.”
“Highly recommended; good level, professional guidance and good materials. I particularly enjoy the keyboard shortcuts and knowing new, quick solutions.”
“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.”
“A good coursebook with exercises that let you work at your own pace. You can ask the trainer for help at any time.”
"M. van Es, Kales - "No classroom instruction, but working at your own pace on the topics that matter to you." - Rating: 7.6"
“Plenty of practice during the course, which is very pleasant. You learn by doing. A knowledgeable trainer who is genuinely keen to help you.”
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.