Basic Excel Training

Will the Basic Excel Training be suitable for me?

The Basic Excel Training is for those who:

• have no previous experience or only a brief knowledge of Microsoft Excel,
• want to learn basic actions and formulas,
• want to create clear and legible reports, charts and summaries.

After the Basic Excel Training You will know how to:

• correctly input and format different kinds of data,
• enter and edit formulas and  use them to create analytical reports,
• create data comparisons and analyse them with basic tools.

What makes us different from other training companies?

Training needs surveys

Before training, we ask you to specify your expectations and analyse your needs. This way, our trainer will be able to suggest the most suitable kind of training for you and modify the programme according to your needs.

Training materials

As a participant of our training, you will receive a complete set of carefully developed training materials including:

• A reference book discussing the issues covered by the training and providing a "step-by-step" description of the respective exercises,
• Unlimited electronic access to exercises and training materials within the framework of the Cognity Knowledge Zone.

Certificate

Having completed a training course, you will receive a certificate confirming the qualifications you gained. The back side of the certificate lists the programme of your training. Cognity certificates are issued pursuant to an entry in the Register of Training Institutions (no. 2.12/00106/2011).

The comfort of learning

In order to ensure optimum learning conditions, we organise training courses in small groups of no more than 10 participants. We will prepare an individual computer station for you, too.

Post-training assistance

Having completed our training course, you will be offered the assistance of our trainer. If you have any doubts or questions concerning the subject-matter of your training, you can call us, e-mail us or arrange a personal meeting (in our company) with the trainer, who will be at your service.

No matter where you choose to have your training...

We offer, as extra service, assistance in finding the right accommodation or restaurant for you and we can organise other attractions as well.

Training courses include lunch and coffee breaks.

Basic Excel Training programme 

All that is important for the start – an introduction to work with Excel

Get familiar with the terminology and the working environment of MS Excel

• getting about the workbook,
• keyboard shortcuts.

What can you do with data i.e. data operations

• input, modification  and deletion of data,
• selecting data,
• various ways to copy and paste data,
• filling cells with data series.

Data clarity and cell formatting

• alignment, font and its size,  borders and fill,
• number, currency, percentage, text, date and time formatting,
• table formatting,
• format painter.

Automatic value highlights i.e. conditional formatting

• formatting cells containing text,
• formatting cells containing values.

Yellow sticky notes – entering and editing comments

A better calculator – or formulas and functions

• calculations done directly in cells,
• calculations using  cell addresses,
• relative and absolute references,
• copying formulas,
• using sum, average, maximum and minimum functions,
• mathematical, logical, date and time functions and their usage in calculations,
• text functions.

Data visualisation or creating and formatting charts

Putting data in order i.e. data sorting

Displaying desired results – data filtering with the Autofilter tool

Counting the data up according to given criteria  - data analysis with aid of the Sumifs function

Day 1

Day 2