Description
Excel is the ideal tool for creating graphs. In this module, you'll learn how to make a simple graph. We see many different types of graphs and in which cases you choose a certain type of graph.
After creation, we will look at the various options for modifying the graph. Elements covered here include adjusting the range on which the graph is based, placing gridlines, working with a legend, the many formatting options,...
Audience
This course is intended for people who already have a good knowledge of Excel, but who want to delve into the use of simple graphs.
Methods
Classic training with attention to individual guidance and the ability to ask questions. On the basis of exercises, the student can immediately put the possibilities of the program into practice.
Contents
- Creating a graph
- The different types of graphs
- 2D charts
- 3D charts
- Combi charts
- When to use which type?
- Modifying a graph
- Change the source data and its effects on the graph
- Add/remove elements on the graph such as legend, gridlines, titles,...
- Modifying the various chart elements
- Layout of a graph
- Sparklines
Certification
Participation certificate: participants receive a certificate that they have completed this training at the end of the training.