Excel: Working with charts

  • Course types: In company
  • Duration: 1 day

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: Using 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

  • Ribbon
  • Keyboard shortcuts
  • Components of a chart: gridlines, legends, plot area, chart area, series, etc.

Part 2 Formatting

  • Options on the contextual tabs in the ribbon
  • Chart formatting control to add parts to the chart quickly
  • Formatting the components of a chart (e.g. add and position data labels, create floating charts)
  • Charts with a second Y axis
  • Adjust the scale of a chart

Part 3 Chart types

  • Recommended charts
  • Column (2D, 3D)
  • Bar (2D, 3D)
  • Line (2D, 3D)
  • Pie chart (2D, 3D)
  • Area (2D, 3D)
  • Scatter
  • Stock
  • Surface
  • Doughnut
  • Bubble
  • Radar
  • Treemap
  • Sunburst
  • Histogram
  • Box & Whisker
  • Waterfall
  • Built-in combined charts
  • Combinations of different types

Part 4 Miscellaneous

  • Trendlines
  • Error bars
  • Add other objects to a chart
  • Export a chart to or create a chart in other Office packages
  • Special chart (sparklines)

Part 5 Creating chart templates

Request an offer



Share this course on Facebook, Twitter, LinkedIn or e-mail

Requesting a quotation

Would you like to organize this training course for your employees? At your offices or at a Xylos training centre? We transform your requirements into the perfect solution.

Request

Questions?

Contact Inès Vansteenkiste

+32 2 264 13 20
xylos@xylos.com