Creating powerful charts with Excel

Thursday
7 November 2019
Noorderlaan 139
Antwerpen
09:00 - 17:00
NL  Dutch
Wednesday
13 November 2019
St-Lendriksborre 8
Brussel
09:00 - 17:00
FR  French
Friday
22 November 2019
Villermontstraat 9
Kontich
09:00 - 17:00
EN NL FR
Wednesday
11 December 2019
St-Lendriksborre 8
Brussel
09:00 - 17:00
NL  Dutch

Tailor-made training

You rather have a tailor-made training based on this course? Contact us and we will make it work.
 
 

Description

With Excel you can create efficient and attractive charts in no time at all. However, there are still many properties that are not as readily accessible and therefore not as well-known. This training course will enable you to clearly visualize your data using the different charts available in Microsoft Excel.

Contents

Creating charts:

•Using the wizard and the ribbons
•The various elements of a chart (gridlines, legend, plot area, chart area, series, …)

Formatting charts:

•Formatting the various elements of a chart (for example: Data labels, adding and positioning, creating floating charts…)
•Working with a 2nd Y-axis
•Modifying the scale of a chart

Exploring some types of charts:

•Column (2D, 3D, Cylinder, Cone, Pyramid)
•Bar (2D, 3D, Cylinder, Cone, Pyramid)
•Line (2D, 3D)
•Pie (2D, 3D)
•Rare (but useful) types: Area (2D, 3D), Stock, Surface, Doughnut, Bubble, Radar
•Scatter charts for XY-data
•Combinations of several types

Other:

• AddingTrend lines to your chart
• Using Error bars in statistical charts
•Adding other objects to a chart (a logo, ...)
•Exporting charts to/creating charts in other Office packages

Target audience

Anyone who regularly needs to create charts to support, visualise or report numerical data.

Prerequisites

You have completed the Excel introduction training course or you have a comparable level of knowledge.

Duration

1 day

Prix par participant

360 EUR

E-Learning

60 EUR
Tailor-made training
Iedere organisatie werkt op een andere manier en geen enkele werknemer is hetzelfde. Wij bieden al onze opleidingen ook op maat van jouw organisatie.
Continue reading