The Great Canadian Training & Consulting Company

Mastering Charts & Graphs in Excel

Course Length:

6 hours (1 day)

Learning Objectives

By the end of this course, you should be comfortable with applying best practices to considerably improve the design of your Excel charts, as well as apply simple and creative techniques to create more powerful data visualizations.

Target Student

All Excel users who want to significantly improve their Excel reports to create more powerful visualizations that communicate information in the best possible manner.

Course Outline

Understand the Key Principles of Data Visualizations
Learn Data Visualization Best Practices
Customize Charts in Excel
Chart Elements, Layouts, Colours, and Styles
Chart Formatting Options
Change Chart Types
Adjust Axis Options
Explore the Differences in the Effectiveness of Excel Chart Types
Create, Modify, and Apply Chart Templates
Master Basic Charts and Graphs
Bar and Column Charts
Line Charts and Trendlines
Combo Charts
Pie and Donut Charts
Histograms and Pareto Charts
Area Charts
Scatter Plots
Bubble Charts
Box and Whisker Charts
Tree Maps and Sunburst Charts
Waterfall Charts
Radar Charts
Funnel Charts
Stock Charts
Heat Maps
Surface and Contour Charts
Geospatial Maps (Power Map Introduction)
Sparklines

A seal with “Guaranteed to Run” written on it. In the middle is a person giving a thumbs up, standing behind a checkmark

Mastering Charts & Graphs in Excel

Upcoming Classes

All Public classes are held online
with a live instructor

Dates	Price	Qty
March 1, 2024 9:00 AM to 4:00 PM ET	$425.00 Online
July 12, 2024 9:00 AM to 4:00 PM ET	$425.00 Online
November 7, 2024 9:00 AM to 4:00 PM ET	$425.00 Online

* Applicable taxes will be applied on checkout

I want to talk to someone about private or customized training

Have questions about this course? See below or reach out to our training coordinators.

Group of 4 or more? Consider private training