Training

Excel Intermediate

Training

Excel Intermediate

Comprehensive Excel training, emphasizing techniques that increase efficiency and are useful in daily work.

MS Excel

A comprehensive tool for data storage, calculation, analysis and visualization.

The training agenda in the pritable PDF format can be downloaded here.

Training profile

A thematically broad, comprehensive Excel training course, raising knowledge of the program and proficiency in its use.

We have conducted it many times since 2018, all the time enriching it and adding answers to interesting questions from trainees. We collect interesting questions (and the most common mistakes), and promote techniques that get a lively reaction from students, and not entirely professional exclaims “cool”, ” it will come in handy” 🙂.

Is this the proper level of training for me?

Yes, because each training we conduct is personalized, i.e. tailored to your needs and your level of knowledge.

So we suggest that you tailor the training program to your expectations, for example, by:

a short online videoconference meeting, during which we will establish organizational and substantive details;
sending your expectations prior to the training course in the form of an email, preferably with the examples of the tasks ahead of you.

When arranging the course, we emphasize that the participants should be at a similar, similar level of knowledge. This way, later, during the class, the trainer will adjust the course to the averaged level of the group by optimal selection of exercises and their level of difficulty. In addition, during the training session, we encourage you to express your expectations: promptly signal the difficulties encountered, ask questions, direct the training yourself towards the issues you need.

Prerequisite Skills

Proficient computer and keyboard skills
trainees in the training group must have a similar, comparable level of knowledge (very important)
if the course is being planned for two training days, it is necessary to have a knowledge of at least 75% of the “Excel Elementary” course material

Training language

We conduct the training in English or in Polish, all training materials are available in EN or PL version.

Training objectives

To complement and to systematize knowledge
To become proficient in the cross-use of tools, arriving at a result through different paths
Learn the efficient navigation, selection and copying of large data sets using keyboard shortcuts
To expand knowledge of formulas with conditional calculations and tools for working with dates and texts
To introduce new, convenient tools of Excel 365

When the training is effective?

Training is successful:

When participants have a similar level of knowledge (very important). Whether basic, or intermediate, or advanced, the trainer will adjust quickly anyway, but the important thing is that they are alike. In extreme cases (beginners in one group with veterans) it is not possible to determine an averaged level, and the students themselves quickly realize that a mixed group does not work in practice,
the group should be no more than 6-9 people,
it is good if during the training the participants are relieved of other duties so that they can focus solely on learning.

Regarding videoconference online training:

the day before the training, we suggest testing the computer, software and downloading exercise files so that everything is ready to go the next morning,
very important: two displays; with the trainer’s remote presentation on one screen, and on the other the trainee’s individual exercises. More information about two displays.

After the training:

after completing the course, daily professional contact with Excel is necessary: work, practical tasks, individual repetition of the material.

Training duration

The scope of topics we offer at the intermediate level is best arranged in time in 24 lesson hrs. divided into 3 training days. The abbreviated form of 16 lesson hrs. (2 days) will work only if you are at least 75% familiar with the material of the Elementary course.

We welcome you to adjust the hours and duration to suit your needs. The most frequently ordered training schedules are: three-day (24 lesson hrs.) and two-day (16 lesson hrs.), but other time arrangements (e.g. recurring four-hour, afternoon, weekend training) that do not make all employees unavailable at the same time are also possible.

Aiming to improve own employees’ knowledge of Excel, it is a good idea to plan the training as a cyclical event, e.g. 2 days of Elementary course, one year break, 3 days of Intermediate course, one year break, 3 days of Advanced course.

Training day schedule