Creating powerful charts with Excel

Tailor-made training

Would you rather have a tailor-made training based on this course? Contact us and we will make it work.
 
 

Description

With Excel you can create efficient and attractive charts in no time at all. However, there are still many properties that are not as readily accessible and therefore not as well-known. This training course will enable you to clearly visualize your data using the different charts available in Microsoft Excel.

Contents

Creating a chart

  • A standard chart via one keyboard shortcut
  • Create charts via the wizard or via the ribbons

Formatting the elements of a chart

  • What are all the elements in a graph (axes, legend, titles, scale, ...)
  • Formatting options for these chart elements
    • Changing the scale
    • Adding/removing a legend
    • Adding/removing/modifying the titles
    • Options regarding the axes
    • Formatting options of the background(s)
    • Formatting the data elements (color, shading, images)
    • Add, delete data series
    • Working with a second Y-axis
    • The 3D formatting options
  • Changing the Chart Type
  • Combining two chart types into one chart
  • Know which chart type is right for which type of data

Adding extra elements

  • Adding and parameterizing a trend line
  • Adding margin of error indicators
  • Adding free text and/or arrows or other graphic elements

Export charts

  • To Word or PowerPoint
  • With or without a link to Excel

Charts associated with a pivot table

  • Quickly create a (pivot) chart based on a pivot table
  • Changing a PivotChart

Target audience

Anyone who regularly needs to create charts to support, visualise or report numerical data.

Prerequisites

You have completed the Excel introduction training course or you have a comparable level of knowledge.

Duration

1 day

E-Learning

95 EUR
Tailor-made training
Each organization is unique in its identity, and no co-worker is the same. That's why we at Learnia offer our clients tailor-made courses as well.
Continue reading