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

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

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