Course

Visualizing data with Excel («ME3»)

A picture tells more than words or numbers. Learn how to visualize your numbers and data using Excel charts, sparklines, conditional formatting, and other techniques.
Duration 1 day
Price 700.–
Course documents Digital Digicomp courseware

Course facts

  • Visualising figures and using different types of diagrams to achieve your goals
  • Understanding and using special charts such as waterfall, map and funnel charts
  • Using histograms
  • Creating compelling visualisations

1 The chart types

  • Column
  • Line
  • Bar
  • Pie and doughnut
  • Area
  • XY (scatter) and bubble
  • Stock
  • Surface
  • Radar
  • Combo

2 Create chart

  • Chart retrieving
  • Elements of a chart

3 Adjust chart

  • Context tab chart tools
  • Chart buttons
  • Align to cell grid
  • Format data series
  • Axis options 
  • Legend
  • Data label
  • Chart and axis titles
  • Gridlines
  • Data tables
  • Add data tables and adjust order
  • Change chart

4 Statistical elements

  • Trend lines
  • Error bars

5 Secondary axis

6 Moving and printing charts

7 Dynamic data ranges

8 Special diagrams

  • Gantt
  • Waterfall
  • Funnel

9 Alternatives to charts

  • Data visualization with sparklines
  • Charts from symbols

10 Tips and Tricks

  • Adjust data point symbol
  • Chart templates
  • Beginning of line for value axis
  • Highlight bars dynamically
  • High-Low lines
  • Series lines
  • Adjust data label form

This course is aimed at people who want to gain in-depth knowledge of charts to skillfully visualize their data.

Practical experience with Excel as well as knowledge according to our Excel courses:

Download

Questions

Choose your date

Further courses