The Great Canadian Training & Consulting Company

What You'll Learn in Custom Data Visualizations in Excel

Course Length:

6 hours (1 day)

Learning Objectives

By the end of this course, you will understand how to work with Excel’s graphics tools, as well as create basic Excel charts. You will then learn how to combine these two skills to create several non-standard, visually effective charts and visualizations such as pictographs, gauge charts, and progress bars.

Target Student

All Excel users who want to significantly improve their Excel charting skills to create more eye-catching data visualizations which can be used as a one-off data summarization tool or to create stunning Excel dashboards.

Course Outline

Section 1: Create Charts

Charts

Chart Types

Chart Insertion Methods

Resizing and Moving the Chart

Adding Additional Data

Switching Between Rows and Columns

Section 2: Modify and Format Charts

The Difference Between Modifying and Formatting

Chart Elements

Minimize Extraneous Chart Elements

The Chart Tools Contextual Tabs

Formatting the Chart with a Style

Section 3: Working with Graphics

Insert and Modify Graphic Objects

Graphical Objects

Inserting Shapes

Inserting Text Boxes

Inserting Images

The Picture Tools – Format Contextual Tab

The Drawing Tools – Format Contextual Tab

Section 4: Layer and Group Graphic Objects

Layering Objects

Grouping Objects

Positioning Objects

Section 5: Creating the Custom Data Visualizations

Creating Pictographs

Using Conditional Formatting and Icons to Create a Progress Bar

Thermometer Chart

Speedometer (Dial Gauge) Chart

Fancy Speedometer (Dial Gauge) Chart

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

Custom Data Visualizations in Excel

Upcoming Classes

All Public classes are held online
with a live instructor

Dates	Price	Qty
May 24, 2024 9:00 AM to 4:00 PM ET	$495.00 Online
July 16, 2024 9:00 AM to 4:00 PM ET	$495.00 Online
November 18, 2024 9:00 AM to 4:00 PM ET	$495.00 Online
February 24, 2025 9:00 AM to 4:00 PM ET	$495.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