Description

A chart says more than a thousand numbers. And visual representations of figures are also simply easier to remember. Do you regularly work with figures in Excel and want to be able to whip up the best charts with ease? Then be sure to take our course "Excel: Charts".

Objectives

After this training you will:

• Know which chart best illustrates your figures

• Be able to create charts and format them with different options

• Be able to create your own chart templates and save time

• Be able to export charts smoothly and insert them into a Word or PowerPoint file

Target audience

Anyone who regularly creates charts to reinforce, visualise or report on figures.

Prerequisites

You have a good basic knowledge of Excel.

Contents

Part 1: Creating charts

• Via the ribbon

• Via shortcuts

Part 2: Components and format

• The different parts of a chart (gridlines, legend, plot area, chart area, series, ...)

• Options on the contextual tabs in the ribbon

• Chart formatting control to quickly add elements to a chart

• Formatting the different parts of a chart (e.g. adding and positioning data labels, creating floating charts)

• Working with a second y-axis

• Adjusting a chart's scale

Part 3: Types of charts

• Overview of the different types of charts (e.g. the difference between line and scatter)

• Combining charts (e.g. column and line charts)

Part 4: Extras

• Trendlines

• Error bars

• Adding other objects to a chart

• Exporting charts to/creating them in other Office applications

• In-cell charts (sparklines)

• Working with creative charts (conditional formatting in charts, speedometer, waffle chart...)

Part 5: Chart templates