Learnit Training
Excel course Tables, formulas and functions
  • Learn how to visualise data clearly in tables and charts
  • Suitable for Excel versions 2007, 2010, 2013 and 2016
  • Very experienced teacher with a broad knowledge
  • Small group with lots of personal guidance
  • Laptop and lunch are provided

During this one-day training you learn to create pivot tables and you also practice with 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

"Expert custom work, highly recommended!" - Rating: 9.0

learnit Excel Pivot Tables, Formulas and Functions

Excel course Tables, formulas and functions

Do you want to learn about formulas and functions, databases and pivot tables in Excel? During this training you will learn about advanced functions and how to display data with PivotTables in Excel. PivotTables in Excel allow you to represent data in almost any way imaginable. With little effort, you can convert a lot of data into clear tables and charts. You can also follow this training as the first day of our two-day training Excel Expert. On the second day we will discuss the use of macros and cooperation with other programs.

Topics

  • Frequently used functions
  • Date/time functions
  • Text functions
  • Financial functions
  • Functional use
  • Naming cells
  • Three-dimensional work
  • Workgroup functions
  • Introduction to databases
  • Database building
  • Filter
  • Database functions (NUMBER ALS,SUM ALS)
  • What exactly is a pivot table?
  • Pivot table with related tables
  • Create a Pivot Table Report
  • Changing Pivot Table Layout
  • Adding slicers and timeline
  • Rotary table filtering
  • Pivot table filtering with the timeline
  • Pivot table in another worksheet
  • Modify rotary table fields
  • Calculated fields in a pivot table
  • Create rotary chart report

The trainer

During the training you will be guided by a social and competent trainer. At the beginning 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? 2010, 2013, 2016 and 2019

When you register, you can enter which version of Excel you use. 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

It is possible to bring along practical examples from your work situation so that you can work in an even more focused way and it is clear what your goal is from this training. The topics and exercises will be tuned to this.

Afterwards

Afterwards, you know how to use Excel's advanced functions and formulas. You will have learned to display data from databases in a clear manner using pivot tables.

Prior knowledge

Prior knowledge at the Excel Basis level is recommended

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

Note

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 € 375,- € 290,-
Total, incl. VAT € 453,75 € 350,90

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 Turntables, Formulas and Functions was assessed with an average of 8.4.

"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

"Pleasant training, small group, much time for individual attention! Take your own files with you, so that you can apply what you have learned right away. You then come up against other questions than in the exercise material." - Rating: 8.3

E. van Hartevelt - Excel Pivot Tables, Formulas and Functions

"Excellent course, open learning format proved to be very nice for me".

- Excel Pivot Tables, Formulas and Functions

"Expert custom work, highly recommended!" - Rating: 9.0

F. van Dorst, DASD Holding - Excel Pivot Tables, Formulas and Functions

"The training was easy to do within the allotted time. Learned what I came for." - Rating: 8.3

Ton Bollebakker, Veronica Publishing - Excel Tables, Formulas and Functions

"I took the Excel 2007 Advanced PivotTables course and found it to be a good course, with a very capable teacher. Questions are answered well, knowledge of the teacher is very good. Highly recommended!" - Rating: 8.3

L.W. Mooi, Betonindustrie B.V. Concrelit - Excel Pivot Tables, Formulas and Functions

"This training clearly covers Excel's pivot-table capabilities and also explains various available functions well using practical examples." - Rating: 9.3

J. van den Nouwland, CG Drives & Automation - Excel Pivot Tables, Formulas and Functions

"An organisation that does things well, reacts quickly and thinks along with you." - Rating: 8.0

T. Banga, De Friese Wouden - Excel Tables, Formulas and Functions

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

- Excel Pivot Tables, Formulas and Functions

"Professional, no-nonsense, practice-oriented training". - Rating: 8.3

M. Lieuw - Excel Pivot Tables, Formulas and Functions

"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

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

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

"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

"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

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

- Excel Pivot Tables, Formulas and Functions

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

A. Ahmed, Feenstra - Excel Pivot Tables, Formulas and Functions

"A practical course that you can actually do something with and one that is not too long." - Rating: 8.0

C. Van der Werff, Blue Carpet Foundation - Excel Pivot Tables, Formulas and Functions

"Well tailored to the customer's needs" - Rating: 8.7

F. Nuij, BV Steenfabriek Spijk - Excel Tables, Formulas and Functions

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

Thijs Janssens, BIJ12 - Excel Pivot Tables, Formulas and Functions

"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

"No pressure that you have to go 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 they come immediately if you ask for it." - Rating: 8.0

Marjan Lof, Yarden Uitvaartverzekeringen N.V. - Excel Pivot Tables, Formulas and Functions

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

T. Bartha - 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

"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

"I think it is a good training with sufficient practical explanation. A world of knowledge opens up for someone with moderate Excel experience." - Rating: 8.0

L. Offergelt-Holthuizen, Social Insurance Bank - Excel Pivot Tables, Formulas and Functions

"Excellent proffesional Training with many "tips & tricks" for every starting level."

- Excel Pivot Tables, Formulas and Functions

"A fine and clear training that is easy to follow for novice "Excellers"." - Rating: 9.0

L. Hoogendoorn, Media Markt Saturn Holding Nederland B.V. - Excel Tables, Formulas and Functions

"I really enjoyed the Excel 2010 course and was given a nice reference book so that I can practise some of the topics again at home. - Rating: 9.4

P. van Hall, PostNL - Excel Pivot Tables, Formulas and Functions

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

Janet van Apeldoorn, BIJ12 - Excel Pivot Tables, Formulas and Functions

"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

"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

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

Marco Vijftigschild - Excel Pivot Tables, Formulas and Functions

"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

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

Lotte Dijk, BIJ12 - Excel Pivot Tables, Formulas and Functions

"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

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

T.G. Brouwer, Kuiken N.V. - Excel Tables, Formulas and Functions

"Learnit matched us with the right trainer. Our training need was not a standard training and this was well understood by Nick. Everyone we spoke to at Learnit was pleasant. We are very happy with your professionalism and flexibility." - Rating: 9.4

L. van Eekelen, VU University Amsterdam - Excel Pivot Tables, Formulas and Functions

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

- Excel Pivot Tables, Formulas and Functions

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

A. Leeuwendal - Excel Pivot Tables, Formulas and Functions

"A lot of practice during the training is very pleasant. You learn by doing. Competent trainer who is eager to help you." - Rating: 9.4

Sandra de Haas, Euler Hermes Kredietverzekeringen - Excel 2002 Basic

"Top, you start to see that it is very necessary to take excel courses." - Rating: 7.0

Mr. R. Kunis, De Kas - Excel Basic

"Learnit, has given my knowledge with the course EXCEL, a broader picture again. My knowledge had slackened and now it is back up to date! In addition, everything is well and clearly explained and the material is excellent, trainer takes the time for you." - Rating: 9.1

M. Roem - Excel Basic

"Doing is learning - Rating: 8.0

Roelof Pieters, Scania Production Meppel BV - Excel Basic

"No pressure that you have to go 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 they come immediately if you ask for it." - Rating: 8.0

Marjan Lof, Yarden Uitvaartverzekeringen N.V. - Excel Pivot Tables, Formulas and Functions

"It is an excellent course with clear teaching materials. I have learned a lot from it." - Rating: 7.9

K. Stolk, Cofely - Excel Continued

"The Excel training 'the sequel' is a good follow-up to the basics and was easy for me to do. Now I have to put it into practice. It's great that a teacher was present to help me with the questions I couldn't solve. You can also bring along an example from your work that can be discussed in class. In the 2 courses that I have now followed, a number of participants have been helped to deal with and solve a complex problem through the help of the teacher and the necessary formulas that came along with it." - Rating: 9.0

L. Nuijten, IZZ Foundation - Excel Continued

"Teaching material was very clear, it was well explained step by step how to do a certain action. Assignments were socially related. With an open learning format you can of course set your own pace, which is fine for me." - Rating: 8.0

C. van der Kaaij, Pharmacy The Hague Hospitals - Excel Basic

"Very good training! Everything is perfectly arranged and it is definitely a recommendation to take a course at Learnit." - Rating: 9.0

Luciano Felida, New Neopharm - Excel Basic

"I have experienced the training as very instructive. Doing it yourself and dealing with assignments in class is a good mix to be able to apply the knowledge properly. In addition, the trainer is also open to bringing in your own cases, so that in this way you are also helped directly at work level. Very pleasant! In short, I found it a successful training in which I was able to develop myself further in a pleasant and pleasant setting! - Rating: 7.0

D. Nieuwenhuis - Excel Continued

"All the students were all enhousiastic. They all learned something from it. Nice that the course can be given at the office." - Rating: 7.7

Yvette Sierhuis, RLG Europe - Excel 2003 Basic