Description

Graphs are figures in pictures. Nothing better to increase the readability of your numerical data, illustrate a trend or make a comparison. However, creating a successful graph cannot be improvised. This training will allow you to easily build relevant graphs with Excel.

Who is this training for ?

For whom ?

Any Excel user wishing to better master the possibilities of graphic representation of manipulated data.

Prerequisites

None

Training objectives

Identify the appropriate graphic for the message to be communicated Design a graphic with method and precision Build personalized and advanced graphics Insert a graphic in a document or presentation

Training program

• Follow the steps for constructing a graph
  • Choose the graphic best suited to the message to be presented.
  • Understand the graphic parameters to manipulate it.
  • Best practices: position, size and format .
  • Identify the key points to strengthen its impact.
  • Practical work Manipulate the properties and formatting dialog boxes of a graph.
• Construct and format a simple chart
  • Define, manage and manipulate source data and series.
  • Choose a curve, histogram or sector.
  • Adjust the order of plotting series and adapt the scale of the axes.
  • Change the background color and pattern of a data series.
  • Data labels.
  • Practical work Create simple charts and customize their formatting.
• Customize the overall appearance of a chart
  • Set the title position and layout.
  • Choose the appearance of the axis gridlines.
  • Change the legend text and location.
  • Change the size, color and orientation of the text in the graph.
  • Practical work Review the general presentation of the graph.
• Design elaborate graphics
  • Combine chart types into one: lines, areas, histograms.
  • Add a trend line to a chart.
  • Put in perspective with two axes (main and secondary).
  • Build a Pareto chart.
  • Practical work Deep in depth on the properties of graphs.
• Specific graphics
  • Point cloud, compare data on two variables.
  • "Surface", three-dimensional representation of a set of data.
  • Bubbles, connect three series of data.
  • Radar type graph, compare several variables in parallel.
  • Practical work Discover the use of specific graphs.
• Tips and tricks for communicating your graphics
  • Paste a chart as an image.
  • Animate charts in PowerPoint.
  • Manipulate PivotCharts.
  • Business Intelligence , design a graph dashboard.
  • Advanced functions: OFFSET, FREQUENCY, FORECAST, GROWTH, SLOPE.
  • Practical work Creative workshops for improving graphs offered.