Excel Charts

Build Clear Excel Charts That Communicate Key Data Insights

This practical half-day course helps you turn workplace data into clear, effective Excel charts. You will learn how to select an appropriate chart type and data range, format chart elements, edit data series, add trendlines and error bars, and use sparklines to highlight trends.

This course is designed for people who create or present workplace charts and want to make better choices about chart type, layout and formatting. It will help you refine existing charts and communicate comparisons, patterns and trends more clearly.

Excel Charts is ideal for people who:

• Work with data that needs to be presented visually
• Create Excel charts for workplace reports
• Need to customise charts while keeping information clear
• Want to choose chart types more effectively
• Want to communicate key insights from data

To attend Excel Charts, you should:

• Have knowledge equivalent to Excel Essential Skills
• Be comfortable creating Excel formulas
• Be familiar with basic Excel functions
• Be familiar with absolute references

Excel Charts is ideal for people who:

• Work with data that needs to be presented visually
• Create Excel charts for workplace reports
• Need to customise charts while keeping information clear
• Want to choose chart types more effectively
• Want to communicate key insights from data

Understanding Chart Fundamentals

• Explore the purpose of charts and when to use them.
• Identify the key components of a chart.
• Choose the most effective chart type for your data.

Creating Charts from Worksheet Data

• Build charts from existing Excel data.
• Create charts using recommended chart options.
• Work with chart layouts and styles.

Working with Common Chart Types

• Create column, bar, line, and pie charts.
• Compare data using different chart types.
• Understand the strengths and limitations of each chart.

Customising Chart Appearance

• Modify chart titles, legends, and labels.
• Apply colours, styles, and formatting options.
• Enhance chart readability and visual impact.

Using Charts for Visual Analysis

• Create combo and secondary-axis charts.
• Use sparklines for quick visual analysis.
• Add trendlines and error bars to charts to provide analytical context.

Managing and Updating Charts

• Edit chart source data and ranges.
• Update charts when data changes.
• Move, resize, and organise charts effectively.

Presenting and Sharing Insights

• Prepare charts for reports and presentations.
• Select and arrange charts to communicate the main message clearly in reports and presentations.
• Apply best practices for clear data storytelling.