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 pageBeyond the program: MS Office + Soft skillsVisualisation and presentation of data in MS Excel and MS PowerPoint Training

Visualisation and presentation of data in MS Excel and MS PowerPoint Training


Will the Visualisation and presentation of data in MS Excel and MS PowerPoint Training be suitable for me?


The Visualisation and presentation of data in MS Excel and MS PowerPoint Training is for those who:

  • are familiar with MS Excel Basics,
  • want to gain skills essential for effective use of the tool creating and editing graphs,
  • in their daily work create reports using various kinds of data and then present them,
  • want to create presentations containing charts which content will be clear and properly interpretable by their recipients,
  • want to know how to act during a presentation to make the point and to rise credibility.

 

After the Visualisation and presentation of data in MS Excel and MS PowerPoint Training You will know how to:

  • properly prepare your source data which then will be used in the chart creator,
  • create and format a legible and visually attractive chart,
  • properly select the chart type most appropriate for presented data,
  • modify an already crated graph and adjust it to best suit your needs,
  • display your data in a way easy to interpret,
  • copy data charts to other office applications,
  • present in a convincing and effective way.

 

 

 

 

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.

Visualisation and presentation of data in MS Excel and MS PowerPoint Training programme

Conditional formatting – way to quickly interpret the data

  • highlighting cells containing certain texts or values,
  • data bars, colour ranges, icon sets,
  • creating formulas defining cell formatting.

Principles of  proper data visualisation

  • interpreting and drawing conclusions from a graphical data representation,
  • a proper graphical theme of a chart,
  • methods of proper graphical representation of information on a chart.

Creating charts

  • standard chart types – bar, column and line charts,
  • proper use of chart scale, non-linear scales,
  • labels,
  • double-axis chart,
  • copying a chart into other Office applications (PowerPoint, Word, Outlook),
  • pivot charts,
  • creating charts in cells  with usage of REPT and IF functions,
  • instead of a graph – disparity visualisation.

Using charts and graphs to visualise data

  • selecting a chart optimal for given source data,
  • ways to make charts legible and easy to interpret by their recipients,
  • when and how to use SmartArt graphics.

The art of visual manipulation  – ways to visualise not-so-comfortable information

  • the perspective on a chart,
  • setting proper scale,
  • skilful grouping,
  • hiding the trend.

Creating good looking PowerPoint presentations

  • principles of creating presentation and slides,
  • perception by the audience,
  • knowledge transfer with photos, images and charts,
  • colour palette of a presentation,
  • presentation effects.

The presenter and his presentation

  • interacting with the presentation when presenting,
  • handling your audience,
  • adjusting to your recipients,
  • managing energy and interest level among the audience,
  • managing questions and answers during a presentation.

Day 1

Schedule       Time
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

 

Day 2

Schedule         
Time
Classes 9:00 - 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:16 lesson units / 2 days
Price per person:1580 zł
Contact phone:12 421 87 54
Application Form
for Training (PDF)
Training
Program (PDF)

Selected clients: