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 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
What others say about this course
Excel PowerPivot course: average 7.8 from 1 review
"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."
"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."
"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)."
“Enthusiastic trainer who explained everything clearly and understandably.”
"Even if you think you already know a lot about Excel, you always learn something new. The possibilities are enormous."
“I found it a very pleasant way of learning. At your own pace with a course book and a trainer who can answer questions.”
“This is a good course for delving into the basics of the Excel package without it becoming very complicated straight away. Without any prior knowledge, you can create attractive Excel sheets with appealing formatting and charts.”
“Good course for beginners, even if you have no affinity with computers at all. Anyone can do it!”
“Training at your own pace. Self-study, so you can approach the parts that matter most to you.”
"If you want to get acquainted with the use of macros, this is an excellent starting point. You can record and program macros. This course covers recording macros only. You learn programming during the VBA course. After completing this course you have a complete picture of how recording a macro works."
“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.”
“Doing is learning”
“Even for participants with little or no experience of the subject, it is surprising how much you can learn in two days.”
"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."
“Very concrete course which gives a good insight into the possibilities of Excel.”
"It shows how Excel works in a simple way, very accessible for people who are not familiar with Excel."
“Very professional, good explanations, easy to follow from your own workstation via the internet.”
“Enthusiastic trainer who explains things well and is very patient. Clear course material that also works well as a reference if you have forgotten something.”
“A pleasant way of working, own pace, own choice of subject, good, recent laptops and an agreeable location.”
"Informative, pleasant, clear material, step-by-step method."
“Well tailored to the client's requirements”
“Pleasant course in which you can learn a great deal in a short time at your own pace.”
“Good course, I learned a great deal from it and will certainly get a lot of use out of it at work.”
"A good course covering many topics in Excel. It gives you a solid introduction to using various formulas and features of Excel."
“The content is surprising and you can put a lot of the material into practice.”
"Good course. The trainer has extensive knowledge of Excel and explains things calmly and clearly."
“Excellent, you come to realise how necessary it is to take Excel courses.”
“I took MS Excel 2010 Basics: a two-day course covering all the basic techniques you need to work well with Excel. Learned a great deal in 2 days and had good personal guidance. Everything is explained calmly and they really take the time for you.”
“Excellent self-study course, so you really work at it yourself....that is still the best way to learn !!”
“The Learnit course gives you a very good picture of what you can do with Excel. The professional trainer makes you feel self-sufficient from the very first moment. It is highly instructive and readily applicable.”
“An instructive course for understanding the basics of Excel and putting them to use. Also instructive for people who already work with Excel quite a lot, because the course is very comprehensive.”
“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.”
“Highly recommended; good level, professional guidance and good materials. I particularly enjoy the keyboard shortcuts and knowing new, quick solutions.”
“This training is excellent and very comprehensive, you can learn an enormous amount from it”
“Excellent training, fits my role well, certainly if you have no experience with Excel. The guidance is excellent too.”
“Well-organised course given by a professional. As far as I'm concerned, highly recommended!”
“I am very satisfied with the course I attended, and certainly also with the practical applicability of the course material.”
"Bart was very passionate and driven; we could not have wished for a better trainer over those two days. It felt good and approachable, and you could tell he genuinely enjoys Excel. Got some good practical tips. Brilliant!! Bart got me completely enthusiastic even though I had really been dreading it."
“This training will save a lot of time in future because of all the tips and trix we learned.”
“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.”
"'I thought I was already fairly handy with Excel, but I still learned a few new things in this webinar.'"
“A good addition to an Excel user's knowledge, even if you have already been using it on your PC for years. There are many more possibilities, which the trainer points out clearly.”
“Thoroughly recommended for everyone”
"'webinars are very handy for quickly picking up knowledge of specific parts within a particular program such as Excel, Crystal Reports etc etc'"
“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.”
"A good interactive course, with room to learn how to resolve situations from practice."
“This course is a good introduction to VBA/macros. It is a mix of theory and practice.”
“Very clear course, taught in a pleasant atmosphere. Definitely recommended for people who have never worked with Excel, but also well worth it for less experienced users.”
“Effective training based on clear course material.”
“The webinar I attended was a good addition. Refreshing my Excel knowledge without any travel time. A number of familiar items supplemented with new or handy 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 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
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.