Creating powerful charts with Excel
19 June 2020
17 August 2020
19 October 2020
21 December 2020
Tailor-made trainingWould you rather have a tailor-made training based on this course? Contact us and we will make it work.
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.
•Using the wizard and the ribbons
•The various elements of a chart (gridlines, legend, plot area, chart area, series, …)
•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
• 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
Anyone who regularly needs to create charts to support, visualise or report numerical data.
You have completed the Excel introduction training course or you have a comparable level of knowledge.