Excel Pivot Tables, Formulas and Functions course
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.
NRTO quality markFree cancellation up to four weeks before the start, so feel free to book now.
In brief. Excel Pivot Tables, Formulas and Functions is a 1-day classroom course. You can take it in Amsterdam, Utrecht, Rotterdam and The Hague, among other places, or online, in a group of no more than 8 participants. The price is € 525,- 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 work smoothly with pivot tables and functions
- Your own practical examples are welcome
- Including working with Copilot in Excel
- Guidance at your own starting level
- Choice of the Excel version you use
Your trainer: Pascal, Bart, Raoul or Mark 1.538 evaluations in total, averaging 8,5. 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.
Description
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.
Topics
- Commonly used functions
- Date and time functions
- Text functions
- Financial functions
- Smart use of functions
- Naming cells
- Working three-dimensionally
- Workgroup functions
- Introduction to databases
- Building a database
- Filtering
- Database functions (COUNTIF, SUMIF)
- What exactly is a PivotTable?
- PivotTable with related tables
- Creating a pivot table report
- Changing the PivotTable layout
- Adding slicers and a timeline
- Filtering a pivot table
- Filtering a pivot table with the timeline
- PivotTable in another worksheet
- Changing pivot table fields
- Calculated fields in a pivot table
- Creating a pivot chart report
- Optional: using Excel with Microsoft 365 Copilot
Result
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.
Target audience
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.
Teaching method
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.
Prior knowledge
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.
Comments
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.
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
- 1 day
- Course times
- from 10 am to 5 pm
- Teaching hours
- 6 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.
Request a quote More about Excel Pivot Tables, Formulas and Functions in-company
All start dates
1 training day. Confirmed dates first, then in order of date.
- Mon 12 October 2026Certain to go ahead Zwolle · 10:00–17:00 Enrol
- Mon 26 October 2026Certain to go ahead Utrecht · 10:00–17:00 Enrol
- Thu 29 October 2026Certain to go ahead Rotterdam · 10:00–17:00 Enrol
- Mon 23 November 2026Certain to go ahead Zwolle · 10:00–17:00Free cancellation until 26 October Enrol
- Mon 9 November 2026 Arnhem · 10:00–17:00Free cancellation until 12 October Enrol
- Mon 23 November 2026 Online · 10:00–17:00Free cancellation until 26 October Enrol
- Tue 8 December 2026 Eindhoven · 10:00–17:00Free cancellation until 10 November Enrol
- Mon 25 January 2027 Amsterdam · 10:00–17:00Free cancellation until 28 December Enrol
- Mon 8 February 2027 The Hague · 10:00–17:00Free cancellation until 11 January Enrol
- Mon 1 March 2027 Zwolle · 10:00–17:00Free cancellation until 1 February Enrol
- Mon 1 March 2027 Groningen · 10:00–17:00Free cancellation until 1 February Enrol
- Mon 5 April 2027 Eindhoven · 10:00–17:00Free cancellation until 8 March Enrol
- Mon 3 May 2027 Utrecht · 10:00–17:00Free cancellation until 5 April Enrol
- Thu 12 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 Pivot Tables, Formulas and Functions course: average 8.5 from 34 reviews
“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.”
"An excellent course at a lovely venue. The trainer's personal approach makes sure it never gets boring. I learnt a great deal."
“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.”
"Excellent course, the open learning format turns out to suit me very well"
“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.”
“An enjoyable and clear course that is easy to follow for novice "Excellers".”
“Efficient for people who already use databases in Excel a great deal.”
"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."
“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.”
“An enjoyable experience and an instructive programme.”
“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!”
“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.”
“Practice-oriented course in which you work independently on theory followed by practical assignments; a good mix of theory and practice.”
"Recommended, excellent course material and a good trainer."
“'Expert tailored work, highly recommended!!”
“Very instructive course: recommended for anyone who works with Excel occasionally or regularly!”
“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.”
"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."
“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.”
“A practical course that you can actually do something with, and a course that does not take too long.”
“The training course was manageable within the time set. I learned what I came for.”
“A clear and complete course, given by a highly competent trainer who conveys the course material in a clear and structured way.”
“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.”
“A useful way to spend your time; you can work at your own pace and get exercises for all the important topics.”
“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.”
“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.”
“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.”
“Very concrete tips on how to apply the system, so you learn how to make the system work in your favour.”
“An organisation that has everything well arranged, responds quickly and thinks along with you.”
“Well tailored to the client's requirements”
“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.”
"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."
“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.”
“I am very satisfied with the course I attended, and certainly also with the practical applicability of the course material.”
“Very educational course with a good individual approach that matches the participant.”
"Good, comprehensive course, clear materials, highly recommended!"
"Excellent, professional training course with plenty of 'tips & tricks' for every starting level."
“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 material was explained clearly and effectively. The trainer was more than helpful and knowledgeable."
“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).”
"I found this course very pleasant and instructive. It was tailored precisely to our needs after consultation."
"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!"
“I can do far more with Excel than before; I can conjure up database functions, pivot tables and charts in no time.”
“'Taking courses with Learnit comes highly recommended!'”
“Practice-oriented course in which you work independently on theory followed by practical assignments; a good mix of theory and practice.”
“Learnit is a really good training organisation. What I like is that you also get the book, so you can always practise.”
“I really enjoyed the course. Working through the material at my own pace, and whenever I didn't quite understand something, a teacher who could explain it to me immediately and clearly. Every moment of the two days was put to good use. Excellent!”
“I was very pleased with my Excel course, and I was fortunate enough to have a friendly and helpful trainer (Albert Keupink) whom I would happily recommend to others!”
“A good, instructive, interesting course. I discovered new functions in Excel that I didn't even know existed! So I definitely learned new things!”
Training formats
Classroom
1 day€ 525,-- 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.
How long does the Excel PivotTables, formulas and functions course take?
What will you learn in the Excel Pivot Tables, Formulas and Functions course?
Do I need prior knowledge for the Excel Pivot Tables, Formulas and Functions course?
Does the Excel Pivot Tables, Formulas and Functions course also cover Copilot for Excel?
Which versions of Excel is the PivotTables, formulas and functions course suitable for?
Can the Excel PivotTables, formulas and functions course also be taken in-company?
When should you choose this course and when a YouTube tutorial or self-study?
What is the difference between this course and the Excel Expert course?
After the course, how will I know whether I can really build pivot tables independently at work?
Can I bring my own Excel files from work to work on during the course?
How does working with pivot tables relate to writing complex formulas? Do I need both?
How does Copilot for Excel relate to learning formulas and pivot tables yourself? Doesn't AI make this course redundant?
Others also viewed
Want more? Your next course
Read our blog
Confirmed to go ahead: Mon 12 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.