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 &

1279 - Excel Course 2D: Creating Charts