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

"Especially when you work with lists this is a very meaningful follow-up/Expert course"-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
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 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 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.

"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

“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

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

S. Doormink, Albeda College - 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

"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

"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

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

J. van Hal - 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

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

- 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

“Zeer nuttig om in eigen tempo eigen onderwerpen beter onder de knie te krijgen. Begeleiding perfect.” - Be­oor­de­ling: 8.9

G. Rozeboom, Centraal Bureau voor de Statistiek - 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

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

Emmely Sieler, APG - 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

"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

“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

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

J. Watulingas - Excel Expert

"Interesting course. In order to make all the material your own, it is advisable to reserve enough time for this". - Review: 7.7

J. Sijtsma, Municipality of Woerden - Excel Continued

"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

"Clear training that has helped me a lot in my work. Highly recommended."

- Excel Basic

"Good impression, had nice two days. Much learned!" - Rating: 8.0

A. van Achterberg, Novatech Heerenveen - 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

"I've learned a lot from the Excel basic course. You can follow this in a quiet environment, easily accessible location and by a professional trainer at your own pace. Teaching material by means of a clear book with appealing examples in Excel that you could practice with. In short: highly recommended!"

- Excel Basic

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

- Excel 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

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

G.J.E. Stomp, Rabobank - Excel Basic

"I've had an instructive and at the same time relaxing workout. The teacher gives a good explanation if you have a question and makes you feel at home so easily. He goes along in the breaks to chat about other things or to walk along. Learnit gives good training and makes sure you don't come home with a cracked head. Super!" - Rating: 9.0

J. Ndabacekure - Excel Basic

"I've had an instructive and at the same time relaxing workout. The teacher gives a good explanation if you have a question and makes you feel at home so easily. He goes along in the breaks to chat about other things or to walk along. Learnit gives good training and makes sure you don't come home with a cracked head. Super!" - Rating: 9.0

J. Ndabacekure - 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

"A violent introduction to getting more out of yourself and Excel." - Rating: 9.0

H. Palmer, Promise Technology - Gratis webinar Draaitabellen in Excel 2010 en 2013

"It's nice to take part in the course at your own pace, but with plenty of room for questions and comments! - Review: 7.9

H.G.G. Houx, Rabobank Netherlands - Excel Continued

"Learned a lot in a fine way in a short time." - Assessment: 9.4

D. Corbel, Nuon - Excel Continued

“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

"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

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

Manja Tijssens, RINO Amsterdam - Excel Continued

"The assignments are very clear and easy to follow. There is also plenty of room to present your own input from your own work situation to the teacher, so that you can also deal with the issues you encounter on a daily basis". - Review: 7.7

N. Hartman, Priva - Excel Continued

"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

"For people who have done little with computers, this is a great training." - Assessment: 8.1

René Fiere, CTH - Excel 2003 Basic

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

Niels Krol, Eduvier Education Group - Excel Basic

"M. van Es, Kales - "No classroom instruction, but working at your own pace on the topics that are important to you." - Rating: 7.6"

- Excel Continued

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

M. Latest - Excel Revolving tables, formulas and functions

"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

"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

"Short clear training for someone who hasn't or hardly worked with turntables but would like to learn this." - Assessment: 8.2

C. Clark-Stalenhoef, Optiver Holding B.V. - Gratis webinar Draaitabellen in Excel 2010 en 2013

"A clear training that's very easy to follow. Highly recommended for anyone working in sales." - Rating: 8.0

Tim Lam, Coty Prestige - Excel 2002 Basic

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

I. Beuving - Excel Basic

"The training is well set up. You learn what you want to learn. What was especially nice was the fact that we discussed things that we as a team often run into in the field of work and that solutions were put forward for this. In this way you can apply it directly in your work and make your work easier". - Assessment: 8.1

S. of Tournai - Excel 2010

"An independent, personalized course. Because of this, the Excel program has called upon me to think much more creatively about the possibilities of using Excel in my work". - Assessment: 8.4

F. Gommes, Movement of Mercy - Excel Basic