Learnit Training
Course Excel Pivot Tables, formulas and functions
  • Learn how to clearly visualize data in tables and graphs
  • Suitable for the Excel versions 2007, 2010, 2013 and 2016
  • Very experienced teacher with a broad knowledge
  • Small group with a lot of personal guidance
  • Laptop and lunch we provide

During this one-day training you will learn to create turntables and you will also practice a number of important and frequently used functions. This day is the first day of the two-day training Excel Expert.

Yes, I want to know more

"The day course Excel PivotTable formulas and functions are suitable for those who want to get to know the anatomy of the pivot table in a short space of time and want to learn the basic knowledge."-Rating: 9.0

learnit Excel Pivot Tables, formulas, and functions

Course Excel Pivot Tables, formulas and functions

Would you like to delve into formulas and functions, databases and pivot tables in Excel? During this training you will immerse yourself in advanced functions and in displaying data with pivot tables in Excel. Using pivot tables in Excel, you can display data in almost every conceivable way. With little effort you can convert a lot of data into clear tables and graphs. You can also take this course as the first day of our two-day training Excel Expert. On the second day we will discuss the use of macros and working together with other programs.

Topics

  • Common features
  • Date/Time Functions
  • Text functions
  • Financial functions
  • Use function
  • Naming cells
  • Three-dimensional work
  • Werkgroepfuncties
  • Introduction to Databases
  • Database Building
  • Filter
  • Database functions (COUNT AS, SUM AS)
  • What is a pivot table exactly?
  • Pivot table with related tables
  • Create a PivotTable report
  • Change PivotTable layout
  • Add slicers and Timeline
  • Filter pivot Table
  • Filter pivot table using the timeline
  • Pivot table in other worksheet
  • Change PivotTable fields
  • Calculated fields in a PivotTable
  • Create PivotChart report

The Trainer

You will be supervised by a social and skilled trainer during the training. The trainer discusses at the beginning of the training what your entry level is and what you want to get out of the training, so that you can focus on subjects and exercises that are important to you.

Which version? 2010, 2013, 2016 and 2019

When you register, you can enter the version of Excel you are using. Our planners will ensure that you can follow the training in the correct software version with the material that is written for this version.

Practice

It is possible to take practical examples of your work situation so that you can get more targeted and clear what your goal is of this training. The subjects and exercises are tuned accordingly.

After

Afterwards, you'll know how to use Excel's advanced features and formulas. You have learned how to display data from the databases by using pivot tables.

Prior knowledge

Knowledge at the level of Excel Basis is recommended

To determine how much prior knowledge you have and which course is suitable for you, we make an online course guide available!

Note

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

Lesvorm

This training is offered on the basis of our Open learning form-teaching method. This means that under the active supervision of our trainer, you are working independently to make your own substance. You can achieve your learning goals at your own pace without being bothered by a faster or slower pace of your fellow students. The trainer will ensure that you stay on track and achieve your learning goals. This form of learning offers space for customised work. You will have the opportunity to create examples from your own practice and IT environment that will make you more specific. more...

Language

The training is provided by default in Dutch. The trainer controls the English language. English course material can be used. When registering at least 3 participants, the training can also be provided entirely in English.

Investment

Mentioned prices are per person, including course material. Lunch is included in the training on location.

On location Online
Duration 1 day 2 sessions
Price per day, excl. VAT € 375,- € 290,-
Total, incl. VAT € 453,75 € 350,90

Certificate

After completing the training, a LEARNIT certificate will be issued as proof of participation.


Online

We organiseren deze training ook online. Hiervoor maken we gebruik van Webbex of Zoom. Inloggen met Skype is ook mogelijk. Op verzoek kan deze training ook met Microsoft Teams worden georganiseerd.

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

  • Until one year after the training you can participate for free.
  • Against payment of the catering costs you can also participate in a classroom training.

References

The Excel Turntables, formulas and functions course has been assessed with an average of 8.4.

"Very concrete tips on how to use the system to your advantage." - Rating: 8.0

D. Ostendorp, Randstad Netherlands - Excel Revolving tables, formulas and functions

"Clear and for everyone. book is very clearly described with a lot of examples and assignments. nice that you get both book and cdrom with all the exercises so you can practice after the course and keep track of the knowledge". - Review: 7.9

S.Smolders, Kolibri Horeca Payrolling - Excel Revolving tables, formulas and functions

"No pressure that you have to be at the same pace as fellow students who might be faster, think of classroom training. If necessary, the help of a trainer is present and he will come as soon as you ask for it". - Rating: 8.0

Marjan Lof, Yarden Funeral Insurances N.V. - Excel Turning tables, formulas and functions

"Efficient for people, who already make a lot of use of databases in Excel."

Janet van Apeldoorn, BIJ12 - Excel Revolving tables, formulas and functions

"The daily course Excel Turntables formulas and functions is suitable for those who want to learn the anatomy of the turntable in a short period of time and want to acquire the basic knowledge. - Rating: 9.0

C. A. Busser, van der Meulen Sneek BV - Excel Revolving tables, formulas and functions

"Professional, no-nonsense, hands-on training." - Assessment: 8.3

M. Latest - Excel Revolving tables, formulas and functions

"Very practically oriented, brought your own documents to practice with, so that what you have learned can be put into practice right away. Nice way of following a course, lots of practice material." - Rating: 8.0

A. Copier, Center Parcs - Excel Revolving tables, formulas and functions

"Have experienced this training as very pleasant and instructive. In consultation, this was precisely tailored to the needs."

- Excel Turning tables, formulas and functions

"Highly educational training with a good individual approach that suits the student." - Assessment: 9.4

Inge Leerintveld, Roma Service Cinemas - Excel Revolving tables, formulas and functions

"Useful time, you can work at your own pace and get exercises for all the important topics." - Rating: 8.0

A. Lion Valley - Excel Revolving tables, formulas and functions

"Excellent professional training with lots of "tips & tricks" for every starting level."

- Excel Turning tables, formulas and functions

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

- Excel Turning tables, formulas and functions

"There will be training in a fun way. You can get to work yourself and if you have any questions, time will be taken for you." - Assessment: 7.3

Ragonda Helderman, Yarden Funeral Organization N.V. - Excel Turning tables, formulas and functions

"Learnit hooked us up with the right trainer. Our training need was not standard training and this was well understood by Nick. Everyone we spoke to from Learnit was pleasant. We're very happy with your professionalism and flexibility". - Assessment: 9.4

L. van Eekelen, VU Amsterdam - Excel Revolving tables, formulas and functions

"Clear teaching material with sufficient exercises and personal guidance from a teacher who has a lot of knowledge of MS Excel. It is nice to be able to work with your own data and at your own pace. Highly recommended." - Assessment: 8.3

T.G. Brewer, Chicken N.V. - Excel Turning tables, formulas and functions

"Well attuned to the customer's needs" - Review: 8.7

F. Nuij, BV Steenfabriek Spijk - Excel Revolving tables, formulas and functions

"An excellent training in a beautiful location. The personal approach of the trainer ensures that it is not boring. I've learned a lot from it."

- Excel Turning tables, formulas and functions

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

Mr. van Seters, IMT - Excel Revolving tables, formulas and functions

"I did the Excel 2007 Advanced Turntables course and I thought it was a good training, with a very capable teacher. Questions are answered well, knowledge of the teacher is very good. Highly recommended!" - Assessment: 8.3

L.W. Mooi, Betonindustrie B.V. Concrelit - Excel Revolving tables, formulas and functions

"A fine and clear training that's easy for novice "Excellers"." - Rating: 9.0

L. Hoogendoorn, Media Markt Saturn Holding Nederland B.V. - Excel Turning tables, formulas and functions

"A practical course you can actually do something with and a course that doesn't take too long." - Rating: 8.0

C. Van der Werff, Blue Carpet Foundation - Excel Revolving tables, formulas and functions

"A fun experience and an educational program." - Rating: 8.0

A. Ahmed, Feenstra - Excel Revolving tables, formulas and functions

"Practice-oriented training in which you work independently with theory followed by practical assignments, good mix of theory and practice". - Rating: 8.6

Marco Fifty Shield - Excel Revolving tables, formulas and functions

"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

"Nice training, small group, lots of time for individual attention! Bring your own files so that you can apply what you've learned right away, I thought that made a lot of sense. You will then encounter different questions than in practice material." - Assessment: 8.3

E. van Hartevelt - Excel Revolving tables, formulas and functions

"An organization that gets it right, reacts quickly and thinks along with you." - Rating: 8.0

T. Banga, The Frisian Forests - Excel Revolving tables, formulas and functions

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

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

"The training was good on time. Learned what I came here for." - Assessment: 8.3

Ton Bollebakker, Veronica Publishing - Excel Revolving tables, formulas and functions

"'Expert customization, highly recommended!" - Rating: 9.0

F. van Dorst, DASD Holding - Excel Revolving tables, formulas and functions

"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

"I'm very satisfied with the cusrsus followed and certainly the practical applicability of the teaching material." - Assessment: 9.4

W. Raghoenath, Ministry of Finance - Excel Revolving tables, formulas and functions

"I think it's good training with plenty of practical explanations. It opens up a world of things worth knowing to someone with moderate Excel experience." - Rating: 8.0

L. Offergelt-Holthouses, Social Insurance Bank - Excel Revolving tables, formulas and functions

"Self-study with a touch of extra. Good teacher present with a lot of substantive knowledge, who really thinks along with you to apply your objectives in your own practical environment."

- Excel Turning tables, formulas and functions

"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

"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

"What I have experienced as pleasant is that you are with several people in the same room with one instructor and yet everyone follows their own course. Why is that? - you can share information with each other; - In this time of multimedia where everyone is only busy with themselves, you get in touch with others about why they follow this course and other things. - because there is only one teacher present, the course can be offered in a financially attractive way (LEAN thought)." - Rating: 8.0

C. van der Heijden, SNL Systems B.V. - Excel Revolving tables, formulas and functions

"Just valuable training. Professional, up-to-date, high-level teachers. All in all: You can't miss a training like this" - Review: 9.9

T. Bartha - Excel Revolving tables, formulas and functions

"I can do a lot more with Excel now than I did before; I can conjure up database functions, pivot tables and graphs." - Rating: 8.0

P. Kooijmans, Randstad Nederland B.V. - Excel Turning tables, formulas and functions

"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." - Review: 7.9

F. Kluin, Wintershall - Excel Revolving tables, formulas and functions

"If you're looking for training to increase your chances on the job market, I'll definitely recommend one of the courses, if only to refresh your knowledge!" - Assessment: 7.4

J. Blue - Excel Macros and collaborate with other applications

"A fine teaching method that allows everyone to work at their own pace. Very instructive and highly recommended for anyone who is still in doubt." - Rating: 8.0

S. Elmensdorp, TNT Post - Excel 2003 Basic

"Clear, personal training focused on one's own practical situation, therefore easy to apply in practice. Training is in small groups, therefore sufficient attention for each student. All this in a friendly atmosphere, highly recommended! - Assessment: 8.3

M. Luursema, Astrimex - Excel 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

"Nice and very practical training." - Review: 8.8

B. Borghuis, Rabobank Twente East - Excel Basic

“Goede betrokken docent die probeert kennis aan te bieden die aansluit bij het niveau en de vraag van de cursisten” - Be­oor­de­ling: 7.1

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

"At work I did a lot with Excel but never took a course for it. I found the experience of starting from the beginning with all functional meanings very instructive, I also found the learning system very pleasant". - Assessment: 9.5

J. Nieraeth, Rabobank - Excel Basic

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

I. Beuving - Excel Basic

"A simple basic Excel course that you can master in a short time with Excel by means of personal guidance and a course folder. This tool will have to serve to make you more and more proficient with Excel in the future". - Assessment: 7.4

H. Berkelder, CTH - Excel 2003 Basic

"The course has made a good impression on me. The material that is made available is fine. Because I didn't specify in advance what knowledge I already had and for what purposes I wanted to use the course, the offered substance was quite a lot in 2 days. So follow Learnit's advice and report it in advance." - Rating: 8.7

Silvia Megens, Meiland Azewijn B.V. - Excel Basic

"Good training based on the individual wishes of the customer" - Rating: 7.4

Bud Pronk, Fire Brigade Amsterdam - Amstelland: - Excel Sequel