Training

Excel Elementary Plus

Training

Excel Elementary Plus

The key concepts, tools and functions of Excel. A solid foundation for further learning.

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

Introducing the most important concepts, tools and functions of Excel, it lays a solid foundation for further learning. It focuses on the anatomy of a cell, efficient worksheet navigation, correct data entering, and techniques for searching, copying, sorting and filtering. Although the course is aimed at beginners, Excel users who have been using Excel for several years usually find useful techniques in the course, and their knowledge becomes more systematic and organized.

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)

Training language

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

Training objectives

Describing the fundamentals, meaning the four types of data and how Excel’s search, copy and edit tools behave on them
Acquiring the skills to perform common tasks: entering data correctly, navigating a worksheet, a clear “table,” sorting and filtering, calculations, an aesthetically pleasing chart.
To identify good practices for organizing and arranging data.

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

We propose to plan the Elementary Plus course for 16 lesson hrs., divided, for example, into two training days.

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