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.
Free cancellation up to four weeks before the start, so feel free to book now.
In brief. Excel PowerPivot 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 at the venue and a certificate of attendance. We also run this course for teams and departments in-company.
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.
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.
For teams and organisations. If you want a department to report in the same way using data models and DAX, we also run this course in-company. In consultation with you, we work with examples from your own practice.
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.
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.
The course is also suitable for staff who produce management information or sales or purchasing reports and combine data from different systems to do so. It is also suitable if you currently get stuck on large Excel files with lots of VLOOKUPs between tables.
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.
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.
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.
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.
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.
"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)."
"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."
"A good course covering many topics in Excel. It gives you a solid introduction to using various formulas and features of Excel."
“This organisation helps you gain knowledge in a playful way. So no hours of theory thrown at you, but simply doing it the way you will use it in practice.”
“This training will save a lot of time in future because of all the tips and trix we learned.”
“A revelation: the structure of the learning, the guidance and, as a result, the outcome. With a well-catered lunch – an example for anyone giving courses.”
“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.”
“Good course based on the individual wishes of the client”
“The Open Learning format course allows you to practise and perfect the areas you work with on a daily basis. You can also expand your knowledge by working through the modules in the course book.”
“A pleasant way of working through the material. A book with clear instructions and a trainer in the background who answers questions!”
“I found it a very pleasant way of learning. At your own pace with a course book and a trainer who can answer questions.”
"I had never had any Excel training before, but I already had a reasonable command of the basics through the daily work I do. By taking this Excel course it is easier for me to carry out my daily work in a simpler way thanks to all the new knowledge I have gained."
“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.”
“Plenty of practice during the course, which is very pleasant. You learn by doing. A knowledgeable trainer who is genuinely keen to help you.”
“Excellent training, fits my role well, certainly if you have no experience with Excel. The guidance is excellent too.”
“I learnt a lot from it and in an enjoyable way. Thanks Dirk.”
“For me this is a very pleasant way of learning, as you can work at your own pace. There was also extra course material available on top of the course being taken. Very pleasantly organised.”
“It was an instructive course and you could learn everything calmly at your own pace.”
“An enjoyable course in which everything is explained clearly, but which also makes you think for yourself. Everyone can work at their own pace.”
"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."
“Learned a great deal in a short time, in a very clear and accessible way. A very efficient method for me!”
"The material was explained clearly and effectively. The trainer was more than helpful and knowledgeable."
“Instructive”
“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 nice course, very pleasant that you can work through the book yourself and the trainer walks around to help you whenever you need it.”
“It is a very pleasant course that you can follow at your own pace. If you have questions, there is a trainer who helps you on your way straight away. Really recommended.”
“Professional, no-nonsense, practice-oriented course”
"'webinars are very handy for quickly picking up knowledge of specific parts within a particular program such as Excel, Crystal Reports etc etc'"
“The Excel training course was good. We also received good materials to practise with on our own afterwards. The trainer passed on his knowledge to us in an interesting way.”
“I have been working with Excel for quite some time. However, I had no idea of everything you can do with it. I would recommend this course to any novice like me! Do it!!”
“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.”
“A good mix of explanation with examples and then getting to work on exercises yourself.”
“Interesting course. To really master all the material, it is advisable to set aside enough time for it.”
“Learned a great deal in a short time, in a very clear and accessible way. A very efficient method for me!”
“I am extremely satisfied with this way of teaching. You get a lot of individual attention with good tips from the trainer. Also if you want to discuss work-related topics. In short, I would recommend this way of teaching to anyone who wants to master the material at their own pace.”
"Excellent course! Mastering the Excel course at your own pace and with answers to the questions you ask. Very illuminating. I thought I knew a lot about Excel..."
“A carefully designed course in which my learning objectives received concrete attention.”
“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.”
“Well-organised course given by a professional. As far as I'm concerned, highly recommended!”
“The course materials and the trainers of the various courses I have taken were very good. I have taken 3 courses in the last 2 months and I am very pleased with the result!”
“Excellent course! I thought I knew Excel, but I still learned nice new things that I can apply on a daily basis.”
“Learnit has broadened my knowledge again with the Excel course. My knowledge had slipped and now it is up to date again! On top of that, everything is explained clearly and well, the materials are excellent, and the trainer takes the time for you.”
“The open learning format is well worth recommending if you like working independently at your own pace. The trainer answers your questions when needed and is happy to give advice and extra useful information suited to your level. The course material is clear and lets you practise new skills several times so that you really master them.”
"I found the course very instructive, in a calm and pleasant environment and led by an expert trainer. Thank you."
“A worthwhile course that you can work through at your own pace.”
“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!”
“An engaged, enthusiastic and experienced trainer, which makes the course accessible to everyone.”
“Enjoyable, inspiring course, I learnt things and picked up ideas I didn't know were possible with Excel and VBA. Even though I normally use Excel a lot in my daily work as a tool.”
“A practical course that takes you through the possibilities of Excel at a glance.”
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.