Excel PowerPivot course
In this course you learn to work with Excel PowerPivot. You connect external data sources, build data models, create pivot tables and analyse with DAX. Optional: Excel with Copilot.
NRTO quality markFree cancellation up to four weeks before the start, so feel free to book now.
In brief. Excel PowerPivot is a classroom course lasting 1 day. You can attend 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 525,- 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.
- External data directly in pivot tables
- Powerful analyses with DAX formulas
- Bringing your own examples is welcome
- Optional explanation of Copilot in Excel
- Guidance from an experienced Excel trainer
With Excel PowerPivot you bring data from external databases straight into your pivot tables. You learn to build data models, create relationships and carry out analyses using DAX. Optionally, you can also look at Excel with Microsoft 365 Copilot.
Description
In this Excel PowerPivot course you spend a day working with the PowerPivot functionality in Excel. You learn how to link data from external sources, such as databases, to Excel and how to present this data clearly in PivotTables and PivotCharts.
You will work on setting up a data model, creating relationships between data and adding calculated columns and hierarchies. You will also be introduced to DAX (Data Analysis Expressions), the special formula language that allows you to carry out powerful analyses on large volumes of data. Optionally, the course also covers the use of Microsoft 365 Copilot in Excel, so that you can see how this AI assistant can support your work with data.
The course is delivered by an experienced trainer who will discuss your starting level and learning objectives with you. This allows you to focus on the topics that are most relevant to your own practice. Do you have an example from your own work? Feel free to bring it along, so you can work on it directly during the course.
Topics
- Importing data from external sources
- Linking data and establishing relationships
- Setting up a data model
- Adding calculated columns and fields
- Building hierarchies
- Creating pivot tables and pivot charts
- Using slicers for interactive filtering
- Setting up measures, KPIs and perspectives
- Working with Data Analysis Expressions (DAX)
- Differences between DAX and Excel formulas
- DAX data types and the relational model
- Optional: combining Excel with Microsoft 365 Copilot
Result
After this open learning day you can independently connect to external sources such as databases and import that data into Excel. You build a data model, establish relationships between tables and add calculated columns and hierarchies. With DAX formulas you analyse large datasets and present the results in clear pivot tables and pivot charts with slicers, KPIs and perspectives. Optionally, you can also use Copilot in Excel to draw insights from your data more quickly.
Target audience
This course is intended for Excel users who regularly work with large volumes of data and want to get more out of it. Think of finance staff, data analysts, controllers, business analysts and reporting specialists who want to combine and analyse data from various sources in pivot tables.
You already have experience with Excel and know how to work with formulas and pivot tables. If you would also like an optional introduction to Microsoft 365 Copilot in Excel, this can be covered during the course as well.
Teaching method
You take this course in our open learning format: a full course day on which you work through the course material at your own pace. An experienced trainer is present throughout the day to answer your questions and help you further where needed.
At the start of the day you discuss your starting level and your learning objectives, so that you can focus on the topics that are most relevant to you. You are welcome to bring examples from your own working environment, so that you work on familiar situations straight away.
Prior knowledge
You have experience with Excel and know how to work with formulas, PivotTables and charts. Have you taken the Excel Advanced course or do you have a comparable level? Then you will be able to follow this course without difficulty.
Comments
You take this training course in our open learning format: one course day on which you work through the material at your own pace, with an experienced trainer alongside you for explanation and questions. Feel free to bring an example from your own practice, so you can work directly on situations from your own job. When booking, please indicate which version of Excel you use, so that you receive the right course material. Do you work with Microsoft 365? Then you can optionally also get acquainted with Copilot in Excel.
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.
All start dates
1 training day. Confirmed dates first, then in order of date.
- 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 12 October 2026 Zwolle · 10:00–17:00 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
What others say about this course
Excel PowerPivot course: average 7.8 from 1 review
"The PowerPivot training course gave our group a great deal of insight. Along the way you pick up plenty of tips and tricks that make your work far more efficient. For people who process or analyse a lot of data, this course is definitely recommended."
"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."
"My opinion of the course is positive. The quality of the course material was good, the level was good, the duration was good, the pace was perfect, the variety between the three participants was just right, the exercises were complete, the set-up of the course was good and the trainer was professional (and cheerful)."
“Do you want to get more out of Excel in your daily work? Then this is a good step in the right direction!”
"A professional course with an expert trainer"
“An excellent course for getting to know the possibilities of Excel in more depth once you already know the basics. Because of the individual approach, you can get the most out of the course for yourself. And if all trainers are as enthusiastic and knowledgeable as the one I had, you can get even more out of the course than the course material alone offers.”
"The Excel Basics course is an excellent course for refreshing your memory and/or making working with Excel easier and faster. Partly thanks to the relaxed atmosphere created by the trainer and the opportunity to ask plenty of questions, my fellow participants and I found the course a pleasant experience."
“With the help of visuals and working with the material ourselves, it was an enjoyable interactive training tailored to the questions we asked. In short, a very applicable course.”
“A plus point is that the teaching is not classroom-based, so you can work at your own pace. Two days is exactly enough.”
“A good training course for non-computer specialists too, and you're sure to learn a great deal from it.”
“Never thought I could still learn so much about these programmes. I am also very glad that I took them.”
"Useful and interesting course!"
"A course at your own level where you get support as soon as you need it. This means you can learn efficiently at your own pace!"
“Good teaching method. Plenty of material. Very satisfied with Learnit.”
“A very professional training course, highly applicable and easy to follow.”
“A good course for laying a structured foundation for working with and programming in VBA.”
“The course I took is very relaxed and can be followed at your own pace. The course material you take home afterwards is easy to use at work or at home for further practice and study.”
“The training course was manageable within the time set. I learned what I came for.”
“For a beginner like me this was a very pleasant and concise training course. Starting from a low level, I gained a lot of confidence and can now genuinely put what I have learned into practice.”
“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.”
“Excellent training - nice to be able to set my own pace - good support - clear course material - directly applicable in practice.”
"My opinion of the course is positive. The quality of the course material was good, the level was good, the duration was good, the pace was perfect, the variety between the three participants was just right, the exercises were complete, the set-up of the course was good and the trainer was professional (and cheerful)."
"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."
"Good teaching method, calm trainer, excellent facilities and catering."
"A good course, a pleasant trainer, and many topics that are personally useful to me in my work."
“A pleasant way of working, own pace, own choice of subject, good, recent laptops and an agreeable location.”
“Discovering new applications from start to finish. Excel opens up a whole new world for you.”
“I can recommend the Excel course at Learnit to anyone. Excellent guidance from the trainer, a clear textbook and a CD with all kinds of exercises that tie in perfectly with the textbook (you can take these home after the course as practice and reference material). This course made me realise that I could have been working much more efficiently for years. Thanks to Learnit.”
“A complete course with clear exercises, given by a very experienced and pleasant trainer. Highly recommended.”
"The training is certainly worth recommending. I had no experience with Excel, but the explanations were so clear that I can definitely get to work with it. The trainer was also very clear in his explanations, definitely recommended."
“Simply a valuable course. Professional, up to date, high-calibre trainers. All in all: a course like this is not to be missed.”
“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.”
"This training course comes highly recommended. Clear, well-structured explanations. They take the time for you and you get an answer to all your questions. Really a great course."
“The course material was very clear, and it was explained step by step how to carry out a particular action. The exercises were related to everyday situations. With an open learning format you can of course set your own pace, which suits me fine.”
“I had a course that was both instructive and relaxed at the same time. The trainer explains things well when you have a question and makes sure you feel at ease. He joins in during the breaks to chat about other things or to go for a walk. Learnit provides good training and makes sure you do not go home with a splitting headache. Excellent!”
“Excel is a fine program, but it is even better to discover what else you can do once you have completed the course.”
“I found it a very pleasant way of learning. At your own pace with a course book and a trainer who can answer questions.”
“Had two days of training in Excel Basic 2013. The enjoyable assignments in the course material achieved more than years of struggling and trying on my own. Definitely worth it!”
“Very concrete course which gives a good insight into the possibilities of Excel.”
“Good, clear explanations. The trainer also takes the time to answer questions along the way.”
“Good course, I learned a great deal from it and will certainly get a lot of use out of it at work.”
“Gaining more understanding and knowledge of Excel at your own pace. The group is fairly small, so there are minimal distractions. The organisation and the trainer are a breath of fresh air, and I am not easily satisfied.”
“The training course was manageable within the time set. I learned what I came for.”
“I can do far more with Excel than before; I can conjure up database functions, pivot tables and charts in no time.”
"A good interactive course, with room to learn how to resolve situations from practice."
“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 training course for non-computer specialists too, and you're sure to learn a great deal from it.”
“'Excellent training for mastering Excel from the basics, step by step.'”
“Do you want to get more out of Excel in your daily work? Then this is a good step in the right direction!”
“Excellent, you come to realise how necessary it is to take Excel courses.”
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 PowerPivot course take?
What do you learn in the Excel PowerPivot course?
Do I need prior knowledge of Excel for the PowerPivot course?
Do I receive a certificate after the Excel PowerPivot course?
Can the Excel PowerPivot course also be followed in-company?
Does the Excel PowerPivot course also cover Copilot for Excel?
When should you choose PowerPivot instead of an ordinary pivot table in Excel?
What is the difference between Excel PowerPivot and Power BI for data analysis?
How does PowerPivot stop Excel from grinding to a halt with large datasets?
Which data role is PowerPivot actually intended for, and when does it fall short?
How does PowerPivot relate to DAX, and do I really need to master DAX to get anything out of it?
What does Copilot in Excel add to what I do in PowerPivot, and do you cover that as well?
Others also viewed
Want more? Your next course
Read our blog
Guaranteed to run: Mon 26 October 2026 in Utrecht
This date already has enough participants. Free cancellation up to four weeks before the start, so you can secure a place now.