Learnit Training
Excel PowerPivot course
  • Small groups
  • Covid-19 safe
  • Experienced teacher
  • Possible online
  • Practical training

In this training you learn to make a connection between an external database and Excel. This allows you to analyse the information from the database in Excel and present it in, for example, pivot tables.

Yes, I want to know more

"Excellent training - nice to be able to set my own pace - good support - clear teaching material - directly applicable in practice." - Rating: 9.3

learnit Excel Basic

Excel PowerPivot course

Do you want to learn how to work with Excel PowerPivot? Excel PowerPivot is designed to display data from sources other than the Excel worksheet in pivot tables. In this one-day training you will learn how to display data from external databases in pivot tables using Excel. During the training you will learn how to make the connection, and of course how to arrange the data optimally for a clear presentation in pivot tables.

Besides setting up a data model and creating a PowerPivot, attention is also paid to DAX (Data Analysis Expressions). These are special Excel functions that make it possible to perform analyses on large groups of data.

Topics

  • Importing data
  • Linking data
  • Creating relationships between data
  • Add calculated columns
  • Creating hierarchies
  • Creating Pivot Tables and Graphs
  • Add slicers
  • Making measurements, KPIs and perspectives
  • Data Analysis Expressions (DAX)
  • Overview of DAX formulas
  • Differences DAX and Excel formulas
  • DAX data type
  • Formulas and the relational model
  • Calculated fields

The trainer

You will be guided in this training by a very experienced trainer. At the start of the training, the trainer will discuss your entry level and what you want to get out of the training, so that you can focus on topics and exercises that are important to you.

Which version? 2016, 2013, 2010

When you register, you can fill in which version you are using. Our planners will then ensure that you can follow the training in the correct software version with the material written for this version.

Case studies

If you have encountered problems yourself or would like to carry out certain actions more efficiently, it can be enlightening to bring an example from your working environment to the training. You can then work in an even more practice-oriented way.

Afterwards

After the training, you will be able to create a link to an external source such as a database and you will be able to analyse the data with Excel's DAZ functions. You will be able to display the data in a well-organised pivot table using PowerPivot.

Prior knowledge

Prior knowledge of the creation of pivot tables and charts in Excel is recommended.

Note

This course can be followed for all versions of Excel. This training can be followed in different versions. Please indicate whether you use Excel 2007, 2010, 2013 or 2016.

Course format

This training is offered on the basis of our Open Learning Method. This means that under the active guidance of our trainer, you work independently to master the material. This enables you to achieve your learning goals at your own pace without being hindered by the faster or slower pace of your fellow course members. The trainer will make sure you stay on track and achieve your learning goals. This type of learning allows for customisation. You are given the opportunity to bring in examples from your own practice and IT environment, which will help you learn even more specifically .

Language

The training is provided in Dutch as standard. The trainer has a good command of the English language. Use can be made of course material in English. With a minimum of three participants, the training can also be provided entirely in English.

Investment

Prices mentioned are per person, including course material. Lunch is included in the on-site training.

On location Online
Duration 1 day 2 sessions of 3 hours
Price per day, excluding VAT € 400,- € 315,-
Total, incl. VAT € 484,- € 381,15

Certificate

After completion of the training, a Learnit certificate is issued as proof of participation.


Online

We also organise this training online. For this we use Webbex or Zoom. Login with Skype is also possible. On request, this training can also be organised with Microsoft Teams.

The training takes 2 sessions of 3 hours, spread over 2 weeks.

  • You can participate again free of charge up to one year after the training.
  • For an additional catering fee, you can also participate in a classroom training.

References

The course Excel PowerPivot has been assessed with an average of 8.4.

"The PowerPivot training has given our group many insights. Gradually, you pick up many tips and tricks that make your work much more efficient. For people who process or analyse a lot of data, this training is highly recommended."

- Excel PowerPivot

"Good training for broadening knowledge and skills of Excel, and opportunities for good reflection of applicability in the workplace." - Rating: 7.8

S. van de Ven, Koninklijke Peijnenburg B.V. - Excel PowerPivot

"I experienced this training as very pleasant and instructive. It was precisely tailored to the needs in consultation."

- Excel Pivot Tables, Formulas and Functions

"I really like the fact that you can go through the material at your own pace." - Rating: 8.0

M. Schaars, Delta Schools - Excel Basic

"The training allows each person to reach their learning goals at their own pace." - Rating: 8.0

J.van Wolfswinkel, Cofely - Excel Continued

"Good training, you get a lot of practical information that you can work with." - Rating: 7.3

Wil Hakkaart, NBD Biblion - Excel Basics

"Well cared for, clear and targeted. Great to work through the course material at your own pace." - Rating: 8.4

R. Hoogkamer, Denit Hosting Solutions - Excel Continued

"Excellent training - nice to be able to set my own pace - good support - clear teaching material - directly applicable in practice." - Rating: 9.3

G.J.E. Stomp, Rabobank - Excel Basic

"Very clear explanation. Definitely a must for anyone who works with Excel and has never started at the basis. You learn a lot about the applicability of Excel as a program and its possibilities." - Rating: 7.3

J.R. Smith, ALFEN BV - Excel Basic

"What I have experienced as pleasant is that you are with several people in the same room with one teacher and that everyone still follows his own course. Why? - you can share information with each other; - in this age of multimedia where everyone is only concerned with themselves, you get to talk to others about, among other things, why they are taking this course and - because there is only one teacher, the course can be offered in a financially attractive way (LEAN thought)." - Rating: 8.0

C. van der Heijden, SNL Systems B.V. - Excel Pivot Tables, Formulas and Functions

"Well organised teamwork with professional teacher." - Rating: 9.1

N. Bardijs, Domstad University of Applied Sciences - Excel 2002 Basic

"A. Effendi, Plan-it by Praxis B.V. - "For anyone looking for tailor-made training, this is the right solution. The groups are not large and the trainer is sufficiently qualified. You can indicate your learning goals in advance and they advise you quite accurately which course suits you best. The teaching material is to the point and is concluded with a case that you have to solve to see if you can apply what you have learned. In any case, I learned what I wanted to know and, after all, that is what it is all about." Rating: 8.0."

- Excel Expert

"An interesting and instructive training course with a lot of variety". - Rating: 7.8

Tessa Spruijt, Simpel B.V. - Excel Continued

"Training is given in a fun way. You get to work on your own and if you have questions they take the time for you." - Rating: 7.3

Ragonda Helderman, Yarden Funeral Directors. - Excel Pivot Tables, Formulas and Functions

"I found it a very nice way of learning. At your own pace with a course book with a teacher who can answer questions." - Rating: 8.9

L. van den Berg-van Heusden, Meyra Holding BV - Excel 2003 Continued

"I liked everything! Perfect!"

- Excel Continued

"The one-day Excel Pivot Table Formulas and Functions course is suitable for those who want to learn the anatomy of the pivot table in a short time and master the basics." - Rating: 9.0

C. A. Busser, van der Meulen Sneek BV - Excel Tables, Formulas and Functions

"Good textbook with exercises that allow you to work at your own pace. The teacher can ask you for help at any time." - Rating: 9.1

W. Huiberts, Teleplan - Excel Continued

"Hands on training that helps you in your day-to-day work" - Rating: 7.3

Dave van Lierop, Hamilton Bright - Excel Continued

"An excellent training where you can ask any questions and get very good help." - Rating: 8.6

L. Koppelaar-den Boef, IHC Offshore & Marine - Excel 2003 Macros and working with other programs

"A pleasant way to pick out from the total package of teaching materials only those topics in which you are interested and not to be tired with things in which you have no interest." - Rating: 7.9

A. Stiebolt, Post & Co - Excel Continued

"For people who have done little with computers, this is an excellent training." - Rating: 8.1

René Fiere, CTH - Excel 2003 Basic

"Excellent course due to good supervision and clear assignments with which the newly acquired knowledge could be immediately applied." - Rating: 8.0

A. van der Gragt, Hamilton Bright - Excel 2013

"Training fits in very well with the work. By taking your own material with you, you are focused and you learn what you want to learn. In addition, there is a lot of room and experience available to further expand the knowledge." - Rating: 9.4

M. van Seters, IMT - Excel Pivot Tables, Formulas and Functions

"I can now do much more with Excel than I could before; database functions, pivot tables and graphs are all easy to conjure up. - Rating: 8.0

P. Kooijmans, Randstad Nederland B.V. - Excel Tables, Formulas and Functions

"Enthusiastic trainer who explained everything in a clear and understandable way." - Rating: 8.0

J.A. Ramesar, CEVA Logistics - Excel Macros and working with other programs

"Excel is a great programme, but it is even more fun to find out what else you can do when you have completed the course. - Rating: 7.0

J. van Dijk, Ministry of Defence - Excel Basic

"Excellent training, very professional and very applicable in practice." - Rating: 9.1

F.H. Bartsch - Excel Basics

"The teaching method is very pleasant. You can discuss the problems you encounter at work during the course and come to a solution with the teacher. Learnit informed me quickly and well about the course. I am very satisfied. I have also recommended you to my colleagues, some of whom are also going to follow a course." - Rating: 9.0

G.Wolf, Thalens Nederland B.V. - Excel Continued

"LearnIt is the right place to receive training. Everything is arranged down to the last detail and all kinds of questions can be discussed and there is always a suitable answer. Super experience!" - Rating: 9.4

W. van den Heuvel, Van Luyt appraisers - Word and Excel 2013

"Very practically oriented, brought own documents to practice with, so that what was learned could also be put into practice immediately. Pleasant way of following a course, lots of practice material." - Rating: 8.0

A. Copier, Center Parcs - Excel Pivot Tables, Formulas and Functions

"The plus point is that there is no classroom teaching, so you can go at your own pace. Two days is exactly enough." - Rating: 8.0

R. Frings, Keyrail B.V. - Excel Basic

"Learned a lot in a short time in a very clear and accessible way. Very efficient method for me!" - Rating: 9.0

E. Jongbloed, Randstad - Free webinar PivotTables in Excel 2010 and 2013

"The teaching material and the teachers of the different courses I attended were very good. I have taken 3 courses in the last 2 months and I am very satisfied with the result!" - Rating: 7.9

S. Verhaert, NKM Noell Special Cranes GmbH - Excel Advanced Incompany

"It is nice to be able to go through the course at your own pace. If you have any questions, you can ask the teacher." - Rating: 9.0

M. Brander-de Winkel, OHRA - Excel 2003 Basic

"A complete training with clear exercises given by a very experienced and pleasant teacher. Highly recommended." - Rating: 8.1

J.Dijkstra, Stam B.V. - Excel 2007

"The book is very clearly described with many examples and assignments. It is nice that you get both the book and the CD-ROM with all the exercises so that you can practise after the course and keep the knowledge up to date." - Rating: 7.9

S.Smolders, Kolibri Horeca Payrolling - Excel Pivot Tables, Formulas and Functions

"'Using images and working with the material ourselves, it was a fun interactive training focused on the questions we had. In short, a very applicable course." - Rating: 8.4

G. Gubbels, Koninklijke Smals N.V. - Excel Basic

"This organisation helps you gain knowledge in a playful way. So no hours of theoretical material thrown at you, but just doing it how you will use it in practice". - Rating: 8.1

R. M. F. van Aalten, Rabobank - Excel Basic

"This course is a perfect solution if you want to immerse yourself in a programme for work or for private purposes. It may cost an investment, but the results are much better than doing it in between. You are out of your work environment, but fully engaged in the course. For me it was absolutely right!" - Rating: 8.1

H.Hiemstra, Kroon Vleeswaren - Excel Basic

"A revelation, the learning concept, the guidance and of course the result. With a well-planned lunch, an example for course participants." - Rating: 7.9

A.E. Meijdam, DB Schenker Rail NL - Excel 2003 Basic

"Interesting course. In order to make all the material your own, it is advisable to reserve enough time for this." - Rating: 7.7

J. Sijtsma, Municipality of Woerden - Excel Continued

"This is a good training course for diving into the basics of the Excel package, without it immediately becoming very complicated. You can come up with nice Excel sheets with an appealing layout and graphs without any prior knowledge." - Rating: 9.0

Peter Anuels, Praclox BV - Excel Basic

"This training is approachable and effective." - Rating: 8.4

N. Taylor, Utrecht University - Excel Basics

"Nice training because you make your own assignments at your own pace. It is no problem to skip things you can already do." - Rating: 8.1

Richard Hübbers - Excel Continued

"A great introduction to getting more out of yourself and Excel." - Rating: 9.0

H. Palmer, Promise Technology - Free webinar PivotTables in Excel 2010 and 2013

"Used Learnit for the first time and was pleasantly surprised with the concept. Small group and a lot of individual attention. There were plenty of training methods through the extensive learning materials." - Rating: 8.4

M. Dikken, Ministry of Defence - Excel Continued

"A great way to expand your knowledge of Excel. Your learning question and Excel problems are central. If you bring your own material, you solve your own issues during the training." - Rating: 8.0

E. Niessen, Stichting Philadelphia Zorg - Excel Expert

"A.E. van Wezel - "A very practice-oriented training course designed to make use of the standard functions in particular" - Rating: 8.6"

- Excel 2010

"I found the course of the training to be refreshing and dynamic due to the trainer's high tempo and assertiveness."

- Excel Expert