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

Do you have extensive experience with Excel and would you like to get even more out of the programme? In this training you will learn all the advanced functions of Excel.

Yes, I want to know more

"Top training! Thought I knew excel, but I learned a lot of new things that can be used on a daily basis." - Rating: 8.8

learnit Excel Expert

Excel Expert Course

In the training Excel Expert you are introduced to the most advanced options that Excel has to offer and you learn how to carry out operations as efficiently as possible.

In addition to in-depth explanations of all pivot table features, the training Excel Expert also extensively covers topics such as Target Search, Data Table, Resolver and Scenarios. You also learn to make 'What if' analyses with Excel.

The training is a combination of the following training courses:

  • Excel PivotTables, Formulas and Functions
  • Excel macros and cooperating with other programmes

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
  • Recording and executing macros
  • Modifying macros and detecting errors
  • Absolute and relative recording
  • Starting possibilities
  • Personal macro workbook
  • Templates
  • Integration
  • Convert or import files
  • Exchange data with Word
  • Exchanging data with Access
  • Connecting to external database
  • Send workbook
  • Compatibility

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

Which version? 2007, 2010, 2013 and 2016.

When you register, you can fill in which version you are using. 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

After completing the training, you will be able to structure, analyse and clearly present complex information in Excel, making good use of Excel's most advanced database functions.

Prior knowledge

Prior knowledge at the level of the Excel Sequence is recommended. In order to determine how much prior knowledge you have and which training course is suitable for you, we ask you to complete 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.

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

Certificate

After completion of the training, a Learnit certificate is issued as proof of participation.


References

The course Excel Expert has been assessed with an average of 8.4.

"A. Effendi, Plan-it by Praxis B.V. - "For anyone looking for tailor-made training, this is the right solution. The groups are not large and the trainer is sufficiently qualified. You can indicate your learning goals in advance and they advise you quite accurately which course suits you best. The teaching material is to the point and is concluded with a case that you have to solve to see if you can apply what you have learned. In any case, I learned what I wanted to know and, after all, that is what it is all about." Rating: 8.0."

- Excel Expert

"Top training! Thought I knew excel, but I learned a lot of new things that can be used on a daily basis." - Rating: 8.8

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

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

Emmely Sieler, APG - Excel Expert

"The course was perfectly tailored to the wishes and learning goals of the participants, due to good contact with the instructor beforehand." - Rating: 8.6

F. van Loon, Waste-to-Energy Company - Excel Expert

"M. Koeken, Continu B.V. - i> Well set-up training with a competent trainer. - Rating: 8.8"

- Excel Expert

"Learnit uses young, dynamic, motivated and well-trained teachers. The learning technique used, both in class and individually, 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

"I found the course of the training to be refreshing and dynamic due to the trainer's high tempo and assertiveness."

- Excel Expert

"Good interactive course, where there is room to learn to solve practical situations." - Rating: 8.0

J. van Hal - Excel Expert

"Good training that shows all facets of Excel for the more experienced user. Course material can be followed at one's own pace so that you can work through parts you already know more quickly and give the others more attention." - Rating: 8.1

T.G. Brouwer, Kuiken 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." - Rating: 7.7

N. Sennikova, Kuehne & Nagel - 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 committed teacher who tries to offer knowledge that matches the level and demand of the course participants." - Rating: 7.1

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

"Very useful to master your own subjects at your own pace. Perfect accompaniment." - Rating: 8.9

G. Rozeboom, Central Bureau of Statistics - Excel Expert

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

S. Doormink, Albeda College - Excel Expert

"A great way to expand your knowledge of Excel. Your learning question and Excel problems are central. If you bring your own material, you solve your own issues during the training." - Rating: 8.0

E. Niessen, Stichting Philadelphia Zorg - Excel Expert

"Thorough and smoothly delivered course with many examples from business practice, the students quickly make steps into the world of Excel. - Rating: 8.0

M. Peters, Media Markt Saturn Holding Nederland B.V. - Excel Expert

"Excellent training given by a professional. I highly recommend it! - Rating: 8.0

J. Watulingas - Excel Expert

"I learned a lot and in a fun way. Thanks Dirk." - Rating: 7.7

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

"For a quick introduction to macros, this is an excellent training course to learn the basics of it." - Rating: 8.8

J. Barnhoorn, ITDS Group B.V. - Workshop Excel 2013 Creating Macros

"Interesting training, despite the fact that I already know Excel, I learned how to work faster and more efficiently. Everyone got the attention he or she needed. There is a relaxed atmosphere, in which one works well and learns a lot." - Rating: 8.4

Richard Kemna, Coty Prestige - Excel 2002 Basic

"The Excel course for beginners is a practical, useful and enjoyable course to follow. Afterwards you can take the study material home, so that you can use it as a reference. The training group is not too big and the trainer is very knowledgeable. If I want to follow a computer training in the future, I will certainly look at Learnit's offer." - Rating: 9.1

P. Sikkens, C+ Certification - Excel Basic

"Pleasant training where you can learn a lot in a short time at your own pace." - Rating: 8.1

L. Kolsteeg, Ymere - Excel 2003 Continued

"If I had known about these features of Excel earlier, it would have saved me a lot of time and effort!" - Rating: 8.7

L. Wijnvoord, Movir - Excel Basic

"The course is very clear, you work at your own pace and receive guidance immediately if you have any questions. I think it is very accessible for everyone, also for people with a fear of exams, because there is no indication of how much material you have to cover. Of course, the idea is that you study as much as possible but there is no pressure while you absorb all the material." - Rating: 9.1

V. Edens, Gasunie - Excel Basic

"Sjoerd Jellema made the training personal, by explaining the material with exercises, which I then applied myself. Sjoerd is a pleasant course leader, who has a good grasp of the subject matter, but who also engages the group in the material to be dealt with. I experienced the course as very practical, with cases that I brought along myself. This meant that the theory was put into practice." - Rating: 9.2

L. Poortman, Laurentius - Excel Continued

"The Excel 2007 continuation course is excellently set up; interesting topics and applications that can be used immediately after practice at work." - Rating: 8.1

M. Benschop - Excel Continued

"Good impression. You understand the structure and construction of VBA much better. Highly recommended for all editors, you now understand how it really works!" - Rating: 8.6

A. de Blieck, Randstad Nederland B.V. - Excel VBA

"Open learning is a good form of training. You can follow the training at your own pace, with or without prior knowledge." - Rating: 8.0

M. Ensel-Boonstra, Ensel Staalkonstrukties - Excel Basic

"Practical course that takes you through the capabilities of excel in a nutshell." - Rating: 7.7

Annemiek Zuyderduin, Unica Installatietechniek B.V. - Excel 2010

"Very concrete training which gives a good insight into the possibilities of Excel." - Rating: 9.6

C.H.G.M. Meuwese - Excel 2010

"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

"If you are looking for training to increase your chances of employment, I will definitely recommend one of the courses, if only to refresh your knowledge!" - Rating: 7.4

J. Blaauw - Excel Macros and working with other programs

"A very useful training. Instructor was very knowledgeable and helped a lot." - Rating: 9.7

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

"I learned the many possibilities and applications during the 2-day training, so that working with Excel has become much more attractive." - Rating: 7.9

T. Ketting, The Royal Bank of Scotland N.V. - Excel 2003 Continued

"Clear and easy to follow course with personal guidance." - Rating: 7.7

M.H. Kwakernaak, Rexnord Flat Top Europe - Excel Basic

"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

"The training Excel 2010 Basic is a great way to make the programme your own. By working independently at your own pace, attention can be paid to all topics that are important to you. The experienced trainer provides many examples and tips. By working with your own material, you know for sure at the end of the training that you can put it into practice. In short: definitely recommended! - Rating: 9.1

C. Bijsterveld - Excel Basic

"Short, clear training for someone who has not worked with pivot tables or has worked with them very little, but would like to learn them." - Rating: 8.2

C. Clark-Stalenhoef, Optiver Holding B.V. - Free webinar Turntables in Excel 2010 and 2013

"K. Algra, Municipality of Nijmegen - "An excellent course with good material and many exercises that fit in with practice." - Rating: 7.0"

- Excel Macros and working with other programs

"'Taking training courses through Learnit is highly recommended!'" - Rating: 9.0

M. Englesman. Municipality of Bloemendaal - Excel Basic

"It was a very successful training. Learned a lot in a fun / entertaining way." - Rating: 9.0

H. Langkamp-Sikkelbein - Excel 2007

"Highly recommended for everyone". - Rating: 8.7

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

"The training is well structured with many practical exercises. Enthusiastic teacher with a lot of knowledge. You can repeat the material dealt with at home or at work thanks to the workbook and disk provided, ideal." - Rating: 8.6

P.A. Pollen, CBS - Excel 2002 Basic

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

G.E. Verweij - Excel Basic

"The independent way of working really appeals to me in this training concept. You can also bring along problems from your daily practice that are then addressed." - Rating: 8.7

Henk Versteeg, Ministry of Infrastructure and the Environment - Excel Continued

"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

"I found it a very nice way of learning. At your own pace with a course book with a teacher who can answer questions." - Rating: 8.9

L. van den Berg-van Heusden, Meyra Holding BV - Excel 2003 Continued

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

Janet van Apeldoorn, BIJ12 - 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