Ten serwis używa plików cookies. Brak zmiany ustawień przeglądarki oznacza zgodę na ich używanie.
Więcej informacji o plikach cookies znajdziesz tutaj
Kliknij ZGADZAM SIĘ, aby ta informacja nie wyœwietlała się ponownie
Cognity.pl
You are here: home pageExcel TrainingExcel Charts Training– Presentation and Visualisation of Data

Excel Charts Training– Presentation and Visualisation of Data


Will the Excel Charts Training– Presentation and Visualisation of Data be suitable for me?


The Excel Charts Training– Presentation and Visualisation of Data is for those who:

  • mastered basics of MS Excel,
  • want to learn how to make proficient use of tools creating and editing charts,
  • analyse various datasets during their daily work.

 

 

After the Excel Charts Training– Presentation and Visualisation of Data You will know how to:

  • properly prepare data to be later used in a chart editor,
  • modify the created chart and to adjust it to user’s needs,
  • copy charts to other MS Office applications.

 

 

 

 

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.

Excel Charts Training– Presentation and Visualisation of Data programme

Rules of proper data visualisation

  • interpretation and drawing conclusions on the basis of the graphic
    representation of data,
  • proper type of a chart,
  • graphic method of highlighting certain data on a graph.

Creating charts

  • matching data with a proper chart type,
  • standard chart types,
  • column charts, bar charts, line charts and other,
  • keyboard shortcuts.

Chart midifications

  • selecting chart elements,
  • modifying chart area and plot area,
  • changing chart properties with a Ribbon menu.

Working with data series

  • adding and removing,
  • proper usage of the axis scale, non-linear scale,
  • labels,
  • error bars and tradlines,
  • 3D Charts,
  • advanced charts and displaying the secondary axis.

Creating custom charts

  •  introduction to custom charts,
  • creating an own custom chart.

Chart tricks

  • drawing charts,
  • thermometer chart,
  • guage chart,
  • creating a comparative histogram,
  • gannt chart,
  • the self-updating chart,
  • charts with mathematical functions (one or two variables).

Pasting chart sinto other applications (PowerPoint, Word, Outlook)

  • pasting an Excel object,
  • pasting as a Picture.

Day 1

ScheduleTime
Registration 9:00 - 9:15
Classes 9:15 - 11:00
Break 11:00 - 11:15
Classes 11:15 - 12:30
Lunch 12:30 - 13:15
Classes 13:15 - 14:30
Break 14:30 - 14:45
Classes 14:45 - 16:00

Upcoming dates

DurationNet:8 lesson units / 1 day
Price per person:1200 zł
Contact phone:12 421 87 54
Application Form
for Training (PDF)
Training
Program (PDF)

Selected clients: