Learnit Training
Course Excel Pivot Tables E-Learning
  • Small groups
  • Covid-19 safe
  • Experienced teacher
  • Possible online
  • Practical training

"Excellent training-nice to kunen my own pace-good support-clear curriculum-directly applicable in practice."-Rating: 9.3

learnit Excel Basic

Course Excel Pivot Tables E-Learning

Learn to work with pivot tables quickly? Follow this e-learning course, developed by our trainer Roy nada.

  • With video ´ s, explanations and assignments
  • No travel time and waste of time
  • At your own pace
  • Easy to follow from any device with Internet.

Description

The Excel program is the tool for retrieving the information you want from data. With functions and formulas, a spreadsheet becomes a document with useful information. Often It can be simpler by using pivot tables and pivot charts. Without any Knowledge of formulas makes it easy to convert data to information. Simpler than you think!

At the end of the training, you will be able to independently turn tables and graphs That allows you to retrieve the information you want from data.

The following topics are covered:

  • Introduction online training Excel Turntables
  • Preparing the data
  • The PivotTable Wizard
  • Creating a pivot Table
  • Create a PivotTable command-explanation
  • Update data
  • The Value field settings (Value Field Settings)
  • Values Field Settings command
  • Show Values as
  • Display command value as
  • Calculated columns
  • Calculated Column Command
  • Search function in Excel

Note

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

Investment

E-Learning, per person:


Price (excl. VAT)

€ 100,-

VAT 21%

€ 21,-

Total Incl. vat

€ 121,-

References

De cursus Excel Draaitabellen e-learning is beoordeeld met een gemiddelde van 8.4.

"I found the training very clear, a patient teacher, pleasant working atmosphere and working environment." - Review: 8.9

S. Heygelen, ASML Netherlands B.V. - Excel Basic

"LearnIt's the right place to go. Everything is taken care of down to the last detail and all kinds of questions can pass in review and there is always an appropriate answer to them. Super experience!" - Assessment: 9.4

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

"First impression/acquaintance was/is good." - Review: 7.8

H. de Thomis, ABN Amro Bank - Excel Basic

"Equal use in practice, huge time savings and prevents new frustrations."

- Excel Continued

"The course I took allowed me to set my own pace. It also allowed me to pay more attention to certain chapters than to other parts of the teaching material, which were less applicable to me. I have experienced this way of following a course as very enjoyable". - Review: 7.9

P. Sleurink, Prorail - Excel Basic

"The Excel training was good. We also got good materials for further practice ourselves. The teacher transferred his knowledge to us in an interesting way." - Review: 7.6

M. Polderman, Randstad Nederland B.V. Headquarters - Financial Excel (business economics skills)

"I had a lot of fun following the Excel 2010 course and got a nice reference work, so I can rehearse some subjects at home". - Assessment: 9.4

P. van Hall, PostNL - Excel Revolving tables, formulas and functions

"Careful training in which my learning goals have been given concrete attention." - Assessment: 8.1

R. Koetje - Excel Continued

"I have never had an excel training before, but I already have a reasonable command of the basics through the daily work I do. By following this excel training it is easy for me to perform my daily tasks in an easier way because of all the new knowledge that I have gained."

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

J. Spruyt, Juvans Maatschappelijk Werk en Dienstverlening - Excel Expert

"Good training, learned a lot from it and will certainly enjoy the work." - Assessment: 8.3

Y. Van Bijnen-Hermans, Shoeby - Excel 2003 Continued

"Training is of good quality and well grafted onto practical use." - Rating: 8.0

J.A. de Geus, ENGIE services Nederland NV - Excel Continued

"Very instructive training: recommended for anyone who works with Excel occasionally or regularly!" - Rating: 8.0

Lotte Dijk, BIJ12 - Excel Revolving tables, formulas and functions

"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 teaching material". - Assessment: 8.4

M. Dikken, Ministry of Defence - Excel Continued

"Worth following." - Review: 8.9

Hans Chip, Coty Prestige B.V. - Excel 2002 Basic

"A lot of practice during training." That's very nice. You learn it by doing it. Skilled trainer who'd be happy to help you." - Assessment: 9.4

Sandra de Haas, Euler Hermes Credit Insurances - Excel 2002 Basic

"It's nice to be able to work at your own pace and ask specific questions when you get stuck." - Assessment: 7.4

P. Raven, Municipality of Almere - Excel 2003 Continued

"Learnit makes use of young, dynamic, motivated and well-trained teachers. The applied learning technique, both classroom and individual, is efficient". - Rating: 8.0

E. Geelen - Excel Expert

"Training is of good quality and well grafted onto practical use." - Rating: 8.0

E. Veldman, MNO Vervat B.V. - Excel Basic

"This training is excellent for those who have a good basis for Excel and want to improve further. Teacher was very professional and helpful. Right way to carry out this kind of course". - Rating: 10.0

T. Ghosh, Northern Petroleum Netherlands BV - Excel Continued

"Clear easy to follow course with personal guidance." - Review: 7.7

M.H. Kwakernaak, Rexnord Flat Top Europe - Excel Basic

"Good alternation of explanations with examples and then work on exercises yourself." - Assessment: 8.3

Manja Tijssens, RINO Amsterdam - Excel Continued

"For anyone who reads this and has a lot to do with Excel at work, this is definitely recommended. Although you think you have knowledge of Excel, there are certainly still many possibilities within the program that you did not yet know and after the training you can practice / apply at work". - Assessment: 7.4

L. van den Berg, APM Terminals Rotterdam B.V. - Excel 2003 Continued

T.G. Brouwer, Chick N.V. - Excel Expert

"The content is surprising and you can do a lot in practice with the subject matter." - Rating: 8.1

I. Teunissen - Excel Sequel

"Nice training in which everything is clearly explained, but in which you also have to think for yourself. Everyone can work at their own pace." - Rating: 8.5

K. Villalba Weber - Excel 2003 Basic

"This training course clearly explains the Excel capabilities of rotary tables and also explains various available functions using practical examples. - Assessment: 9.3

J. van den Nouwland, CG Drives & Automation - Excel Revolving tables, formulas and functions

"Recommended. Good level, professional guidance and good material. I especially enjoy the shortcuts and knowledge of new quick solutions". - Rating: 9.0

E.J.F. van Meerwijk - Excel 2010

"Very practical Excel training where you can join at all levels. Trainer will teach you how to use Excel. Especially the practical tricks during the training ensure that you can apply everything practically afterwards."

"Insight into the possibilities of Excel, of which you know that they exist, but have not yet applied them yourself."

"Good course. What I especially appreciated was the fact that each learns at his or her own pace at which he or she is interested". - Review: 7.7

J. Kelmanutu - Excel Basic

"It was an exhilarating, clear training given by a young but experienced teacher who could explain everything clearly and simply to someone starting from zero. In short, good training in a good location with a good teacher." - Assessment: 8.1

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

W. Prince - Excel Basic

"A. Hannink, Camposol - "Good basic and or follow-up courses with a professional teacher and good teaching materials." - Rating: 8.3"

"Very concrete training which gives a good insight into the possibilities of Excel." - Assessment: 9.6

C.H.G.M. Meuwese - Excel 2010

"I certainly found the training to be instructive. Getting to work myself and dealing with classroom assignments is a good mix to be able to apply the knowledge well. In addition, the trainer is also open to bringing in their own cases, so that you can be helped directly on the work floor. Very pleasant! In short, I thought it was a successful training in which I was able to further develop myself in a pleasant and atmospheric setting! - Rating: 7.0

D. Nieuwenhuis - Excel Continued

"I am very happy I participated in this training. It was very useful and applicable to my job, I just wish I had this training years ago! I look forward to the WORD and PPoint trainings in the future." - Review: 8.8

D. Thomas, CB&I - Excel Continued

"Pleasant way of working, own pace, own subject choice, good, recent laptops and an enjoyable location." - Rating: 7.1

J. Peerdeman - Excel Sequel

"Good training, a lot learned, very useful in practice!" - Rating: 7.9

José Hoogeboom, RINO Amsterdam - Excel Basic

"The Excel 2010 VBA Course gives a good start on Macros and its programming!" - Review: 7.8

Tuncay Sahin - Excel VBA

"' Substantive and smoothly given course in which, with many examples from business practice, the students quickly step into the world of Excel.'" - Rating: 8.0

M. Peters, Media Markt Saturn Holding Nederland B.V. - Excel Expert

"An excellent course to learn more about the possibilities of excel 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 the trainers are so enthusiastic and have as much knowledge as the one I have had, then you can get even more out of the course than just what the course material offers". - Review: 8.9

M. Eagles, Combi Welfare - Excel Continued

"Instructive, enjoyable, clear learning, step-by-step method." - Rating: 10.0

I. Gehring, Municipality of Woerden - Excel Basic

“Goede, leerzame, interessante cursus. Heb nieuwe functies ontdekt in excel waar ik het bestaan niet van wist! Dus zeker nieuwe dingen geleerd!” - Be­oor­de­ling: 9.0

S. van Dartel, Vesting Finance - Excel 2003 Expert

"Interesting training, although I already have knowledge of Excel, I have learned how to work faster and more efficiently. Everyone gets the attention they need. There is a relaxed atmosphere, where you work well and learn a lot". - Assessment: 8.4

Richard Kemna, Coty Prestige - Excel 2002 Basic

"Training location is perfect. The teaching material is clearly displayed so you can easily walk through the fabric". - Rating: 8.0

Karin van der Laan, TU Delft - Excel Basic

"Fine course, open learning appears to me to be very nice."

- Excel Turning tables, formulas and functions

"The advanced Excel 2007 course which I followed at Learnit, was taught in a clear manner by a very businesslike and highly motivated instructor. - Rating: 9.0

Willy Nanlohij, Stadsbank East Netherlands - Excel Continued

"Very good training! everything is perfectly arranged and it is definitely recommended to follow a course at Learnit." - Rating: 9.0

Luciano Felida, New Neopharm - Excel Basic

Blog

Excel-Access 0:1 Pivot tables: Excel's best Feature 20 Tips for Excel 2013-PART III 20 Tips for Excel 2013-PART II 20 Tips for Excel 2013-part I

About Learnit

45132 cursisten in de afgelopen 10 jaar

Training locations throughout the country

On average an 8.6 at Springest

Cedeo Certified: 94.4% satisfied

Turnaround time