Skip to main content

Excel: Charts

Version: Office 365
Duration: 1 day
Price incompany training: € 1100 VAT excl. / Terms for incompany training.

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…)

Part 5 Creating Chart Templates

View all our trainings

Request a quote

"*" indicates required fields

Address*
Name*
In which language(s) do you wish to organise this training?
You apply for this course as:
Do you want the training online or on-site?