Switch to the Dutch version/Switch to the English version
  1. Home
  2. Excel PowerPivot
  3. In-company

Excel PowerPivot in-company

A one-day course just for your group. You choose the date and the place, and the trainer tailors the content to your practice beforehand.

7.8 from 1 review 4,6 on Google NRTO quality mark

Previously attended by employees of Koninklijke Peijnenburg B.V.

  • Tailored: matched to the level and goals of your team
  • Trainers from the field, who do the work themselves
  • At your premises, at ours or online, on a date that suits you
  • In Dutch or English, in the language of your choice

What the course covers

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.

Read the full programme of Excel PowerPivot

How an in-company course works

  1. RequestYou tell us which course it concerns, how many people and roughly when. You receive a quotation with a fixed price for the group.
  2. AlignmentWe discuss what the group can already do and what should be different afterwards. The trainer adapts the examples and exercises accordingly.
  3. The courseOn the day and at the place you chose, with course materials for every participant.
  4. AfterwardsEvery participant receives a certificate of attendance.

Practical information

Duration
Ééndaagse
Group
Only your own people
Location
At your office, at one of our locations or online
Date
You choose
Language
Dutch or English
Included
Course materials and a certificate of attendance
Price
Fixed price per group, in a tailored quote (scheduled course: € 525,- excl. VAT per participant)

What participants say about Excel PowerPivot

7.8
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."

S. van de Ven
Koninklijke Peijnenburg B.V.7.8

"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."

Participant

"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)."

Participant

Frequently asked questions about Excel PowerPivot in-company

Where does the in-company Excel PowerPivot course take place?

Wherever suits you: at your office, at one of our training locations or online. You also choose the date.

Can the content be tailored to our organisation?

Yes. Before the course we discuss with you what the group can already do, where things go wrong in practice and what should be different afterwards. The trainer uses examples and exercises from your own work.

How large can the group be?

That depends on the course. For a skills course we prefer to work with a small group, so that everyone can really practise. If more people are involved, we schedule several groups or set up a fixed programme.

What does Excel PowerPivot in-company cost?

You receive a fixed price for the whole group, in a tailored quote. For a group this works out cheaper than booking everyone individually. By way of comparison: a place on the scheduled course costs € 525,- excl. VAT per participant.

Can the course be delivered in English?

Yes. For in-company courses we deliver the training in the language of your choice, Dutch or English. Mention it in your request.

Do participants receive a certificate?

Yes, every participant receives a certificate of attendance afterwards.

How do I request a quote?

Via the quote form: state the course, the number of participants and roughly where and when you would like it. An adviser will then contact you.

How long does the Excel PowerPivot course take?
The Excel PowerPivot course lasts one day and is taught in the open learning format. You work independently at the computer with a personal lesson plan, while an experienced trainer guides you at your own pace and level. You learn to set up data models, create relationships, build pivot tables and work with DAX functions. Optionally, attention is also given to Excel with Copilot.
What do you learn in the Excel PowerPivot course?
In the Excel PowerPivot course you learn how to link and analyse data from external sources using pivot tables. You work on a data model, establish relationships between tables, add calculated columns and hierarchies, and build pivot tables with slicers and KPIs. You also get to grips with DAX formulas for in-depth analyses of large datasets.
Do I need prior knowledge of Excel for the PowerPivot course?
Yes, you need advanced knowledge of Excel to take part in the PowerPivot course. You already work with pivot tables and formulas on a regular basis, and you understand how to structure data in a worksheet. Experience with external databases is an advantage, but not a requirement. At the start of the day, the trainer will discuss your starting level with you so that you can get to work in a focused way.
Do I receive a certificate after the Excel PowerPivot course?
Yes, on completion of the Excel PowerPivot course you receive a certificate of participation. This certificate shows that you have attended a full course day on PowerPivot, data models, pivot tables and DAX formulas. You can add it to your CV or LinkedIn profile to demonstrate your advanced Excel skills to your employer or clients.
Can the Excel PowerPivot course also be followed in-company?
Yes, the Excel PowerPivot course can also be taken in-company. You then receive a course on location, tailored to your organisation and to the team's practical examples. This is useful if you want to train several colleagues at once or if you want to work with your own datasets and databases. Contact us for the options and a tailored quotation.
Does the Excel PowerPivot course also cover Copilot for Excel?
Yes, Copilot for Excel is covered optionally during the Excel PowerPivot course. You learn how to use the AI assistant to draw up formulas more quickly, analyse data and recognise patterns in large datasets. Mention at the start of the Open Learning day that you would like to spend time on this, and the trainer will tailor the exercises accordingly.
When should you choose PowerPivot instead of an ordinary pivot table in Excel?
An ordinary PivotTable works perfectly well as long as your data is on a single Excel worksheet and your rows are limited to a few tens of thousands. You choose PowerPivot when you process larger datasets, want to combine data from multiple sources or want to create relationships between tables without using VLOOKUP. You then work with a data model in which tables are linked via key fields, comparable to a relational database. For calculations you use DAX formulas, which are more powerful than regular Excel formulas because they calculate across the entire model. In concrete terms: choose PowerPivot as soon as you pull data from an external database, want to define KPIs or want to reuse measures in multiple PivotTables. For a one-off analysis on a single table, a standard PivotTable remains faster and simpler.
What is the difference between Excel PowerPivot and Power BI for data analysis?
PowerPivot and Power BI use the same underlying technology: the tabular data model and the DAX formula language. The difference lies in the environment and the purpose. PowerPivot runs within Excel and is intended for analysts who already work in Excel, know pivot tables and want to combine large datasets from external sources. Power BI is a separate tool, aimed at interactive dashboards and sharing reports within organisations. You choose PowerPivot if your reporting stays in Excel workbooks, your colleagues work with Excel and you mainly want to use pivot tables and pivot charts. Power BI is a better fit for visually rich dashboards and wider distribution. The DAX knowledge you gain in the Excel PowerPivot course can be applied directly in Power BI.

Excel PowerPivot for your team?

Request a quotation without obligation and an adviser will get back to you soon. Coming with one or two colleagues? Excel PowerPivot is scheduled 16 times over the coming year, in Amsterdam, Utrecht, Rotterdam, Den Haag, Zwolle, Arnhem, Eindhoven, Groningen.

Request a quote View the scheduled dates
Private groupfixed price, tailored quotation
Request a quote