Training: Excel – Charts and Graphs

Ref. MOE-21
Not certifying


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


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


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


  • Digital courseware 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
Prix de l'inscription
CHF 375.-
Inclus dans ce cours
  • An online skills assessment test before and after your course so that you can evaluate your progress

jeu06apr09:00jeu12:00Lausanne, Avenue Mon repos 24, 1005 Lausanne Etiquettes de sessionMOE-21

jeu06apr09:00jeu12:00VirtuelVirtual Etiquettes de sessionMOE-21

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

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

Horaires d’ouverture

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


Votre demande

Opening hours

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

Contact us

Your request