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

After following this e-learning course on PivotTables, you can easily create and modify pivotTables yourself.

Yes, I want to know more

"This training is really recommended, small group of people, serious teacher and learned a lot." - Rating: 8.7

learnit Excel Basic

Excel PivotTables e-learning course

Quickly learn how to work with pivot tables? Follow this e-learning course, developed by our trainer Roy Nieuwenhuijzen.

  • With videos, explanations and assignments
  • No travel time and wasted time
  • At your own pace
  • Easy to follow from any internet-enabled device.

Description

The Excel programme is the perfect tool for extracting the desired information from data. Using functions and formulas, a spreadsheet becomes a document with useful information. Often simpler by using pivot tables and rotating charts. Without any knowledge of formulas, it is still easy to convert data into information. Simpler than you think!

After completing the training you will be able to create pivot tables and graphs independently, so so you can extract the desired information from data.

The following topics are covered:

  • Introduction online training Excel PivotTables
  • Preparing the data
  • The Pivot Table Wizard
  • Creating a pivot table
  • Task Create a pivot table - Explanation
  • Updating data
  • The Value Field Settings
  • Value field settings command
  • Display values as
  • Display Value as command
  • Calculated columns
  • Command Calculated column
  • Search function in Excel

Note

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

Investment

E-learning, per person:


Price (excl. VAT)

€ 100,-

VAT 21%

€ 21,-

Total incl. VAT

€ 121,-

References

The course Excel PivotTables e-learning has been assessed with an average of 8.4.

"Very concrete tips on the applicability of the system, teaching you how to use the system to your advantage." - Rating: 8.0

D. Oostendorp, Randstad Netherlands - Excel Pivot Tables, Formulas and Functions

"This training is really recommended, small group of people, serious teacher and learned a lot." - Rating: 8.7

S. Dubbeld, Ikazia Hospital - Excel Basic

"In a practical way, a good course of Excel continuation training was given here in 2 days with an excellent teacher, in an excellent location." - Rating: 8.7

Peter Schwillend - Excel Continued

"Excellent training when you want to get to know the working method and logic behind VBA/Macros. Ensures that, in addition to recording Macros, you are also able to write your own formulas and programmes. It gives you a lot of help in exploring the possibilities of VBA yourself. I already knew something about recording macros, but this has given me insight into how VBA works and what you need to pay attention to. Top!" - Rating: 8.2

J. Peters, Estepe - Excel VBA

"A good course to regain and increase knowledge on valuable Excel skills to make worklife easier and faster. - Rating: 8.0

Bart Verdoorn, Marchon - Excel Expert

"I can really recommend the training. After two days of training, you have learned so much that you can work well with Excel. Moreover, the course material is good to use as a reference work." - Rating: 10.0

Janine de Jong - Excel Basic

"The Excel 2007 advanced course which I attended at Learnit was delivered in a clear manner by a very knowledgeable and well motivated instructor." - Rating: 9.0

Willy Nanlohij, City Bank East Netherlands - Excel Continued

"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

"Excellent guidance with room for own learning goals as well." - Rating: 8.9

S. van der Heijden, Ministry of Defence - Excel Basic

"From beginning to end, discover new applications. A world opens up for you within excel." - Rating: 8.6

C. Westhof, Alrijne Zorggroep - Excel 2010

"Did the excel course to broaden my overall knowledge, and I found this course very suitable for that." - Rating: 7.7

Pierre Vugts, Mettler Toledo Product Inspection B.V. - Excel Continued

"I have been working with Excel for a long time. However, I knew nothing about what you can do with it. I can recommend this course to every layman like me! Do it!" - Rating: 8.8

S. Hulshof, CEVA Logistics - Excel Basic

"Good complete course, clear material, highly recommended!" - Rating: 8.6

J. Mols, Meulenhoff Bookshop - Excel Pivot Tables, Formulas and Functions

"The instruction/explanation is very clear, you can get straight to work yourself with the convenience of support where required." - Rating: 9.0

Kitty Jansen, Meyra Holding BV - Excel 2003 Continued

"I thought it was all very well organised. Good location and a good trainer. The lessons are easy to follow and if you have any questions, they are great to talk to. Even after the course." - Rating: 9.7

H. van de Berg, Scania Production Meppel B.V. - Excel Basic

"Many fun exercises that you can take part in and apply immediately. Good clear trainer who pays attention to everyone." - Rating: 8.1

Wendy Dekker, Hamilton Bright - Excel Continued

"I found it a good training offered by Learnit. You are working independently on your own study material. The teacher provided us with useful tips and was also very helpful with questions." - Rating: 7.1

P.Meijer, Groningen District Court - Excel Basic

"In a short time you will learn to master the principles of VBA/Excel, with the opportunity to use your own practical examples." - Rating: 10.0

A. van der Spreng, OneSolution Informatisering B.V. - Excel VBA

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

- Excel Pivot Tables, Formulas and Functions

"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

"The course is taught by a teacher with a great deal of knowledge and passion for Excell, which is contagious. The Readers that are used are very clear and contain assignments that you can work with yourself. The Readers of the basic and advanced course together form a convenient reference work for the workplace." - Rating: 8.6

J. Weimar, Troostwijk Valuation and Advice B.V. - Excel Continued

"Effective training using clear course material." - Rating: 8.0

A.J. Zwarts, EDventure - Excel Basic

"I am very satisfied with the cusrsus followed and certainly with the practical applicability of the teaching material." - Rating: 9.4

W. Raghoenath, Ministry of Finance - Excel Pivot Tables, Formulas and Functions

"Especially if you work with lists, this is a very useful follow-up/expert course" - Rating: 8.8

S. Doormink, Albeda College - Excel Expert

"A self-contained, personalised course. It has made me think much more creatively about the possibilities of using Excel in my work." - Rating: 8.4

F. Gommes, Movement of Mercy - Excel Basics

"Very educational training with good individual approach that suits the learner." - Rating: 9.4

Inge Leerintveld, Roma Service Cinemas - Excel Pivot Tables, Formulas and Functions

"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 fun interactive training course, where both theory and practice are covered." - Rating: 8.0

E. van Holland - Excel 2010

"Teaching material is clear and gives you the opportunity to go through the topics and practice at your own pace. There is no pressure from other participants and no one holds you back. This combined with the good instructor makes for an effective training." - Rating: 8.1

Jos van den Broek, Gasunie - Excel 2003 Continued

"Good training, in which you work a lot independently. Good teaching material and nice trainer, who immediately helps with questions and explains them very clearly."

- Excel Basic / Continued

"Instructive, pleasant, clear teaching, step-by-step method." - Rating: 10.0

I. Gehring, Municipality of Woerden - Excel Basic

"Sjoerd Jellema made the training personal, by explaining the material with exercises, which I then applied myself. Sjoerd is a pleasant course leader, who has a good grasp of the subject matter, but who also engages the group in the material to be dealt with. I experienced the course as very practical, with cases that I brought along myself. This meant that the theory was put into practice." - Rating: 9.2

L. Poortman, Laurentius - Excel Continued

"'Taking training courses through Learnit is highly recommended!'" - Rating: 9.0

M. Englesman. Municipality of Bloemendaal - Excel Basic

"Well done training with a good trainer in a great location and good lunch." - Rating: 7.8

A. Stevens, Drillmasters - Excel VBA

"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

"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

"Good impression. You understand the structure and construction of VBA much better. Highly recommended for all editors, you now understand how it really works!" - Rating: 8.6

A. de Blieck, Randstad Nederland B.V. - Excel VBA

"I have very good impression of the content of the training and specially of the trainer".

- Excel Expert

"This training fits well with the individual objective and is applicable to your work." - Rating: 8.0

C. Engberink, KOAC-NPC - Excel Basic

"An instructive training to understand the basics of Excel, and to start using it. Also instructive for people who already work a fair amount with Excel, as the training is very comprehensive." - Rating: 7.9

T. Stappershof, Kuehne en Nagel Logistics BV - Excel 2003 Basic

"Careful training in which my learning goals received concrete attention." - Rating: 8.1

R. Koetje - Excel Continued

"A great course to get to know the possibilities of Excel in more detail if you already know the basics. Because of the individual aspect, 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 what the course material offers." - Rating: 8.9

M. Arends, Combiwel Welzijnszorg - Excel Continued

"Clear, personal training focused on one's own practical situation, which makes it easy to apply in practice. All this in a pleasant atmosphere, highly recommended! - Rating: 8.3

M. Luursema, Astrimex - Excel Continued

"Hans gives you the feeling that you can learn Excel, even if you are more visually oriented or more alpha than beta, which is very nice. - Rating: 9.0

M. Poelmann, TU Delft - Excel Basics

"Very fine and efficient way of mastering the subject matter under expert guidance in a super location." - Rating: 8.0

D. Cage - Excel Basic

"I liked the course very much. I was able to take in the material at my own pace and if I didn't understand it, the teacher explained it to me directly and adequately. Every moment of the two days was used effectively. Top!" - Rating: 8.0

Heleen Halbe, Vestia - Excel Basic

"Enthusiastic teacher who can explain well and is very patient. Clear teaching material that is also good to use as a reference book if you get lost." - Rating: 8.0

Ursela Verstegen, Randstad Nederland B.V. - Excel 2003 Basic

"A pleasant way to work your way through the material. A book with clear instruction and a teacher in the background who answers questions! - Rating: 9.0

J. Coesmans - Excel Continued

"Although I consider myself a quite advanced user, the course-instructor managed to teach me some new advanced options within excel which will make my life easier in the future." - Rating: 7.9

F. Kluin, Wintershall - Excel Pivot Tables, Formulas and Functions

"I learned a lot from the Excel basic course. You can follow this in a quiet environment, an easily accessible location and by a professional trainer at your own pace. Lesson material by means of a clear book with, in addition, appealing examples in Excel with which you could practise. In short: highly recommended!

- Excel Basic