Visualizing data with Excel («ME3»)

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:

COURSE
Efficient calculations and visualizations with Microsoft Excel («ME2»)
2 days
• Basel, Berne, Geneva, Lausanne, Virtual Training, Zürich
CHF
1'140.–
Learn more
COURSE
Microsoft Excel Foundation («ME1»)
2 days
• Basel, Berne, Geneva, Lausanne, Zürich
CHF
1'140.–
Learn more