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

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

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

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

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

Manja Tijssens, RINO Amsterdam - Excel Continued

"I liked everything! Perfect"

- Excel Continued

"Good training, where you work a lot on your own. Good teaching material and a nice trainer, who immediately helps with questions and explains them very clearly."

- Excel Basic / Continued

"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

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

- Excel PowerPivot

"It was an instructive course and you could learn everything at your own pace." - Review: 7.9

J. Beards, Spithorst - Excel Basic

"Even if you think you already know a lot about Excel, you always learn something. The possibilities are enormous." - Review: 7.9

Arline de Rooy, SMT Netherlands B.V. - Excel Basic

"The training I've followed is very relaxed and at my own pace. The course material you receive after the course can be used at work or at home for further elaboration and training". - Rating: 8.0

R. Roovers, Municipality of Heeze-Leende - Excel 2003 Basic

"Somebody who works with a computer really benefits from this." - Review: 7.8

N. Baart, ENGIE services Nederland NV - Excel Basic

"Excel 2007 was a refresher course for me. Just figuring out how everything works again. Got a lot of use out of it and can make optimal use of Excel again in my current job." - Assessment: 7.3

M.J. van Klom-Donge, Ministry of Defence - Excel Basic

"Intensive 2-day training that you learn a lot from and because there is room to discuss your work-related questions with the teacher, it fitted in well with my personal learning goals". - Assessment: 7.1

Elise van der Steen, DHL - Excel 2003 Continued

"Discover new applications from beginning to end. A world opens up to you within excel." - Rating: 8.6

C. Westhof, Alrijne Zorggroep - Excel 2010

"'Very instructive. Directly applicable in practice. Enthusiastic trainer with a clear and personal explanation.'" - Rating: 9.0

A. van der Grond, Hamliton Bright - Excel 2013

"Learnit is a really good training organization, what I like is that you also get the book and then you can always practice." - Rating: 8.7

Abrar Hussain, The Hague Work Company - Excel Continued

"Expert lecturer who can move quickly in practical situations." - Assessment: 8.1

I. Beuving - Excel Basic

"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

"Quality of teaching material, assignments and professionalism of trainer a big enough one!" - Assessment: 8.2

A. Nieuwenhuis, ETI BV - Excel Basic

"A pleasant way to highlight from the total package of teaching materials only those topics in which you are interested and not to be tired of things for which you are not interested" - Rating: 7.9

A. Stiebolt, Post & Co. - Excel Sequel

"You can save yourself a lot of work, especially with the tips and tricks. The limitations of the package are also discussed and that helps too". - Review: 7.8

Thijs Janssens, BIJ12 - Excel Revolving tables, formulas and functions

"The location where the training will be given is very accessible. Times when the training took place were very pleasant (10:00 - 17:00, so not too early and not too long). Training itself was very good. You had the space to learn at your own pace and possibly spend more time on parts you want to know more about". - Review: 7.7

Mark Krijnen, Cofely Talent BV - Excel 2003 Continued

"As a steel construction calculator I had worked a lot with excel like layout, colors and lines, but lacked the basics of formula making and functions, for my work (cutlery, drawings and quotation) I am constantly calculating hours and prices and surcharges. Also the additional work (adding) is now automatic and therefore faster and error-free. So this course was very instructive for me." - Assessment: 8.3

Walter Dekkers, ASK Romein B.V. - Excel Basic

"The open learning form is really recommended if you like to work independently at your own pace. The instructor will answer your questions when necessary and will be happy to give you advice and extra useful information appropriate to your level. The teaching material is clear and allows you to practice new skills several times so that you can master them properly". - Assessment: 7.7

E.M.M. van Leeuwen, Leiden University - Excel 2003 Continued

"Practical and instructive. A quick way to get the hang of Excel." - Assessment: 8.3

R.S. de Vries, Cmotions Holding B.V. - Excel Basic

"Webinars are very useful to quickly gain knowledge of specific components within a specific program such as Excel, Crystal Reports etc.'" - Rating: 8.6

R. Klinge, SAHZ - Gratis webinar Draaitabellen in Excel 2010 en 2013

"I learned a lot and in a fun way. Thank you, Dirk." - Review: 7.7

L. di Sipio, ENGIE services Nederland NV - Excel Basic

"The Excel course for beginners is a practical, useful and enjoyable course to follow. Afterwards you may take the study material home with you, so that you can use it as a reference work. The training group is not too big, and the trainer has very good knowledge. If I'm going to take computer training in the future, I'll definitely look at Learnit's offer." - Assessment: 9.1

P. Sikkens, C+ Certification - Excel Basic

"Well-groomed training with a good trainer in a great location and well-groomed lunch." - Review: 7.8

A. Stevens, Drillmasters - Excel VBA

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

J. Mols, Meulenhoff Bookery - Excel Revolving tables, formulas and functions

"The training is well put together with a lot of practice. Enthusiastic teacher with a lot of professional knowledge. The treated material can be repeated at home or at work thanks to the workbook and disk, ideal". - Assessment: 8.6

P.A. Pollen, CBS - Excel 2002 Basic

"The advantage I found was that you work individually, allowing each person to work at his or her own pace." - Rating: 8.0

Marleen Braam, Oxyma B.V. - Excel 2003 Basic

"Learnit's training is a training that gives you a very good idea of what you can do with Excel. The professional trainer makes you feel independent from the start. It is very instructive and easy to use". - Rating: 8.0

B. Baveld, SIG Combibloc - Excel 2003 Basic

"I took the Office Basic Excel 2003 Course for 2 days. First of all the accessibility was very good (less than 10 minutes walk from Amsterdam Rai station. The course went well. There was a nice atmosphere and the explanations of the teachers were super! The nice thing is that if you have skills that are not discussed in the course, you can report them to the teacher, who will then look for the assignments for you, so you can learn them as well. All in all I had a great experience and learned a lot! - Assessment: 8.1

A. Gelijsteen, Klemko Techniek B.V. - Excel 2003 Basic

"The open learning form is really recommended if you like to work independently at your own pace. The instructor will answer your questions when necessary and will be happy to give you advice and extra useful information appropriate to your level. The teaching material is clear and allows you to practice new skills several times so that you can master them properly". - Assessment: 7.7

E.M.M. van Leeuwen, Leiden University - Excel 2003 Continued

"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

"Fine course, very nice that you get to work with the book yourself and the teacher walks around helping you when you need it." - Rating: 8.0

M.J.C. den Otter, Phas Beheer - Excel Basic

"A very meaningful workout. And at learnit certainly well taken care of! Teacher was very skilful and helped a lot." - Rating: 9.7

M. den Ouden-Heemskerk, Rijnmond Care Group - Excel 2002 Basic

"Highly recommended for everyone" - Review: 8.7

J.H. Koppers, Falck Nutec B.V. - Excel Basic

"I took the Office Basic Excel 2003 Course for 2 days. First of all the accessibility was very good (less than 10 minutes walk from Amsterdam Rai station. The course went well. There was a nice atmosphere and the explanations of the teachers were super! The nice thing is that if you have skills that are not discussed in the course, you can report them to the teacher, who will then look for the assignments for you, so you can learn them as well. All in all I had a great experience and learned a lot! - Assessment: 8.1

A. Gelijsteen, Klemko Techniek B.V. - Excel 2003 Basic

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

I. Teunissen - Excel Sequel

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

R. Koetje - Excel Continued

"Top training! Thought I knew excel, but still learned some nice new things that can be applied on a daily basis". - Review: 8.8

S. Versloot, Media Markt Saturn Holding Nederland B.V. - Excel Expert

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

A. van der Gragt, Hamilton Bright - Excel 2013

“Goede bruikbare cursus die je op je eigen tempo kan doen. Er is voldoende ruimte om vragen te stellen en toch in je eigen tempo te werken.” - Be­oor­de­ling: 8.0

J. van Schaick, NUON - Excel Vervolg

"Good training that shows all facets of Excel for the more experienced user. Teaching can be followed at your own pace so that you can work on already known parts faster and give the others more attention." - Rating: 8.1

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

"Again a good training with a lot of content that can be put into practice, also had extra exercises from the excellent trainer Sjoerd Jellema". - Rating: 9.0

Eddie Ederveen, Vion Scherpenzeel B.V. - Excel Continued

"I came as (48 yrs) mechanic from the field and had been working with Excel for a number of years but I had only learned some tricks from colleagues. This course has given me a tremendous foundation." - Rating: 8.0

E.J. Jonker, NV Nederlandse Gasunie - Excel Basic

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

J. Mols, Meulenhoff Bookery - Excel Revolving tables, formulas and functions

"A valuable training that you can master at your own pace." - Assessment: 8.1

E. P. Timmer- Ambting, Netlaa B.V. - Excel Basic

"The instruction / explanation is very clear, you can immediately get started yourself with the ease of support where desired." - Rating: 9.0

Kitty Jansen, Meyra Holding BV - Excel 2003 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