Excel: Charts

Classical courses

Version: Microsoft 365
Duration: 1 day (09:00-17:00)
Price training (excl. VAT) starting at: €1490
Number of people: 1-12p

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

Book this training

Let's start a conversation!

Team Xylos is ready to meet you