City of St. Catharines Learning & Development

To take this course, you must have a solid understanding of most topics covered in Excel Course 1Aand 1B.

Learn how to create charts in Excel that actually tell a story. This course takes you from the basics to more advanced techniques, with plenty of tips and tricks to help your visuals stand out and get your message across clearly.

Includes:

Charts Basics

• Create Column/Bar/Line/Pie/Donut charts
• Select, Move, Size, Print Charts
• Change Chart Type / Transpose
• The Chart Buttons / The Chart Tools tabs

Chart Settings & Formatting

• Change Data Ranges / Add Series
• Select, Move & Size Elements
• Navigate the Format Pane
• Format Chart Elements
• Add Trendlines, Error Bars, Up/Down

More Chart Types

• Combined Charts / Modern Bar Chart
• Waterfall Chart / Dumbbell Chart

Creating Effective Charts

• Convey Your Message
• Use of Colours, Elements & Objects
• Use Illustrations as Bars
• Add Text Boxes, Shapes, Icons &