Learnit Training
Course Excel Expert
  • Small groups
  • Covid-19 safe
  • Experienced teacher
  • Possible online
  • Practical training

Heb je ruime ervaring met Excel en wil je nog meer uit het programma halen? In deze training leer je alle geavanceerde functies van Excel.

Yes, I want to know more

"Top Training! Thought Excel to know, but yet again learned nice new things that are applicable daily. "-Rating: 8.8

learnit Excel Expert

Course Excel Expert

In the training Excel Expert you get to know the most advanced possibilities that Excel has to offer and you learn to perform the actions as efficiently as possible.

In addition to an in-depth explanation of all the possibilities of pivot tables, during the training Excel Expert also topics such as goal seek, data table, solver and scenarios are discussed extensively. You will also learn what-if analysis analyses to do with Excel.

The training is a combination of the following trainings:

  • Excel pivot tables, formulas and functions
  • Excel macros and collaboration 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
  • Recording and running macros
  • Change Macros and debug
  • Absolute and relative recording
  • Starting possibilities
  • Personal Macro Workbook
  • Templates
  • Integration
  • Convert or Import files
  • Exchanging data with Word
  • Exchanging data with Access
  • Connect to external database
  • Send Workbook
  • Compatibility

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. If you let the trainer know at what level you are working with Excel, he will take care of the subjects and exercises that make you an Excel Expert.

What version? 2007, 2010, 2013 and 2016.

During the registration you can fill in the version 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

At the end of the training, you will be able to structure, analyze, and present complex information in Excel, using the most advanced database features in Excel.

Prior knowledge

Prior knowledge at the level of the Excel sequel is recommended. To determine how much information you have and which training is appropriately eafragrances, we propose a online course guide Available.

Note

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

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 2 days 4 sessions of three hours
Price per day, excl. VAT € 375,- € 290,-
Total, incl. VAT € 907,50 € 701,80

Certificate

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


Online

We also organize this training online. For this we use Webbex or Zoom. Logging in with Skype is also possible. On request this training can also be organized with Microsoft Teams.

The training lasts 4 sessions of 3 hours, spread over 4 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

De cursus Excel Expert is beoordeeld met een gemiddelde van 8.4.

"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

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

- Excel Expert

"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

"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

"' 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

"I have experienced the course of the training as refreshing and dynamic due to the fast pace and assertiveness of the trainer.

- Excel Expert

"Good training to give an impression of the many possibilities excel offers." - Rating: 7.7

Emmely Sieler, APG - Excel Expert

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

S. Doormink, Albeda College - Excel Expert

“Excel training is definitely useful in case you work every day with this program. Workbook is very professional and easy for understanding. Trainer helps in case you need and there is possibility to have this course in English.” - Be­oor­de­ling: 7.7

N. Sennikova, Kuehne & Nagel - Excel Expert

"Good involved teacher who tries to offer knowledge appropriate to the level and demand of the students". - Assessment: 7.1

J. Spruyt, Juvans Social Work and Services - Excel Expert

"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

"An excellent way to expand your excel knowledge. Your learning question and excel problems are central. If you bring your own material, you will solve your own problems during the training." - Rating: 8.0

E. Sneeze, Philadelphia Care Foundation - Excel Expert

"A. Effendi, Plan-it by Praxis B.V. - "This is the right solution for anyone looking for a tailor-made training course. The groups are not large and the trainer is sufficiently qualified. You can indicate your learning goals in advance and we will advise you which course suits you best. The teaching material is to the point and ends with a case that you have to solve to see if what you have learned can be applied. At least I learned what I wanted to know and that's what it's all about, after all." Rating: 8.0."

- Excel Expert

"The course is perfectly tailored to the wishes and learning goals of the participants, through good contact with the teacher beforehand". - Rating: 8.6

F. of Wage, Waste Energy Company - Excel Expert

“Goeie interactieve cursus, waar de ruimte is om praktijk situaties te leren oplossen.” - Be­oor­de­ling: 8.0

J. van Hal - Excel Expert

"M. Koeken, Continuous B.V. - i> Well-designed training with a competent trainer. - Rating: 8.8"

- Excel Expert

"Very useful to better master your own subjects at your own pace. Guidance perfect." - Assessment: 8.9

G. Rozeboom, Central Bureau of Statistics - Excel Expert

"Excellent training given by a professional. As far as I'm concerned, highly recommended!" - Rating: 8.0

J. Watulingas - Excel Expert

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

- Excel Turning tables, formulas and functions

"Good impression. Trainer expert and patient" - Rating: 8.0

Toos Wijk, Unica Installatietechniek B.V. - Excel 2010

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

- Excel Continued

"Great training for people who want to achieve their own learning goals at their own pace." - Assessment: 8.4

G.E. Verweij - Excel Basic

"My impression of this training is excellent! Nothing but praise..." - Rating: 10.0

S. Flutters, SBO The Wind Rose - Excel Continued

"Training on your own level where you get support as soon as you need it. This allows you to learn efficiently at your own pace". - Rating: 9.0

J. Kramer, Hema - Excel Continued

"Good course, given by a professional organization with a high practical applicability." - Assessment: 8.8

R. Velthuis, Hipink & Flowers Tobacco B.V. - Excel 2010

"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

"Never thought I could learn so much about these programs. I'm also very glad I followed them." - Rating: 9.0

P. Sahl, NUON - Excel Basic

"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

"It's fun and very instructive. I've learned a lot from it and will benefit a lot in the future." - Rating: 8.0

Youri de Beurs, Excel VBA - Excel VBA

"Did the excel course to broaden my general knowledge, and I thought this course was very suitable for that." - Review: 7.7

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

"Good training to broaden excel's knowledge and expertise, and opportunities for good reflection of applicability in the workplace." - Rating: 7.8

S. van de Ven, Royal Peijnenburg B.V. - Excel PowerPivot

"Nice training, lots of learning and everything at your own pace." - Rating: 10.0

W. Weaver, Scania Production Meppel B.V. - Excel Continued

"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

"Excellent training for people who use Excel on a daily/weekly basis and want to simplify practical applicability". - Assessment: 8.3

T. Horsting, Randstad NL - Excel Continued

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

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

"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

"Good textbook with exercises you can do at your own pace. The teacher can ask you for help at any time." - Assessment: 9.1

W. Huiberts, Teleplan - Excel Continued

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

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

"F. Van den Berg - "Good training. Good teaching material. Recommendable!" - Rating: 8.0"

- Excel Basic

"Involved, enthusiastic and experienced trainer making the course accessible to everyone." - Rating: 8.6

Niels Krol, Eduvier Education Group - Excel Basic

"It's an excellent course with clear teaching material. I've learned a lot from it." - Rating: 7.9

K. Stolk, Cofely - Excel Continued

"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

"Teacher was very driven and motivated. Great explanation and good interaction with me as a knowledge-receiver. Sufficient depth, good training." - Review: 7.9

H.J.A. de Win, DSM - Excel 2003 Expert

"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

"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

"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

"Learnit, has given me my knowledge with the EXCEL course, again a broader picture. Knowledge was weakened and here again up to date! In addition, everything is well and clearly explained and the material is well taken care of, trainer takes the time for you". - Assessment: 9.1

M. Romania - Excel Basic

"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

"I loved to see the possibilities what you can do with excel. Hope to be able to use everything we have learned." - Assessment: 8.2

B. Follower, CB&I - Excel Continued

"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