Training: Excel – Charts and Graphs

Ref. MOE-21
Duration:
0.5
 day
Exam:
Not certifying
Level:
Advanced

Description

This Excel course will enable you to master the creation of graphs and diagrams, as well as their formatting.

Participant profiles

  • This module is intended for anyone who has to create and use graphs in the course of their jobs, as well as to make a graphic analysis of data

Objectives

  • Present their data in a visual way using the most appropriate graphics
  • Use graphical objects
  • Create graphs for data analysis

Prerequisites

Prior to attending this training, participants should have a working knowledge of Microsoft Excel or have completed the following training modules: Excel – Fundamentals, Excel – Becoming more efficient and Excel – Preparing for data analysis

Course content

Module 1: Charts

  • Creating a chart
  • Moving and resizing a chart
  • Apply a predefined chart layout or style
  • Add or remove chart elements
  • Manually change the layout and formatting of chart elements
  • Select the most representative chart type
  • Create a two axis chart
  • Insert a trend line
  • Save a graph as a template

Module 2: Graphic Objects

  • Insert shapes and connectors
  • Formatting graphic objects
  • Define the default style for your objects
  • Use the Selection Pane

Module 3: Graphical analysis of data

  • Create an age pyramid
  • Create an climatogram
  • Create a bubble chart

Documentation

  • Digital course material included

Lab / Exercises

  • Practice exercises will be given at the end of each module

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

  • As we care about the quality of our training, ITTA offers you an online skills assessment test before and after your course so that you can evaluate your progress
  • Explore all our Microsoft Office courses by clicking here
Prix de l'inscription
CHF 375.-
Inclus dans ce cours
  • Evaluation of your level before and after the training
  • Training provided by a certified trainer
  • Documentation in digital format
  • Achievement Badge

ven07Juin09:00ven12:00VirtuelVirtual Etiquettes de sessionMOE-21

ven07Juin09:00ven12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-21

ven12juil09:00ven12:00VirtuelVirtual Etiquettes de sessionMOE-21

ven12juil09:00ven12:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-21

ven16Aoû09:00ven12:00VirtuelVirtual Etiquettes de sessionMOE-21

ven16Aoû09:00ven12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-21

ven20Sep09:00ven12:00VirtuelVirtual Etiquettes de sessionMOE-21

ven20Sep09:00ven12:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-21

ven25Oct09:00ven12:00VirtuelVirtual Etiquettes de sessionMOE-21

ven25Oct09:00ven12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-21

ven29Nov09:00ven12:00VirtuelVirtual Etiquettes de sessionMOE-21

ven29Nov09:00ven12:00Genève, Route des Jeunes 33B, 1227 Carouge Etiquettes de sessionMOE-21

Horaires d’ouverture

Du lundi au vendredi, de 8:30 à 18:00.

Contactez-nous

Votre demande

Opening hours

Monday to Friday, from 8:30 am to 06:00 pm.

Contact us

Your request

X
X
X
X