Description
A graph is worth a thousand numbers; when dealing with numbers, a visual representation is often easier to remember. Do you process numbers in Excel regularly and do you want to create useful charts effortlessly? Be sure to register for our ‘Excel: Charts’ training.
Objectives
After this training, you’ll know:
- Which charts to use to illustrate your data
- How to create charts and how to format them using different options
- How to create your own chart templates, which saves you a lot of time
- How to export charts and insert them in a Word or PowerPoint file
Target Group
Everyone who regularly makes charts to enhance, visualise or report numbers.
Prerequisites
Basic Excel knowledge is required.
Content
Part 1 Creating charts
- Via ribbon
- Via Shortcuts
Part 2 Components and format
- The various parts of a chart (grid lines), legend, plot area, chart area, series, …)
- Options on the contextual tabs in the ribbon
- Chart formatting control to add components to a chart quickly
- Formatting the various components of a chart (e.g. adding and positioning data labels, creating floating charts)
- Working with a second y-axis
- Adjusting the scale of a chart
Part 3 Types of chart
- Overview of the various chart types (e.g.: difference between line and scatter)
- Combining charts (e.g. Column and line charts)
Part 4 Miscellaneous
- Trend lines
- Error Bars
- Adding other objects to a chart
- Exporting charts to/creating them in other Office suites
- In-cell charts (spark lines)
- Getting creative with charts (Conditional formatting in charts, speedometer, waffle chart…)
