Great Canadian Training Company color logo

Custom Data Visualizations in Excel

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
March 15, 2024
9:00 AM to 12:00 PM ET
$495.00 SOLD OUT
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
* 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

The Great Canadian Training & Consulting Company Advantage

When you train with us, your training will not just check a box. We make sure it is GREAT!

  • Experienced Trainers
  • Guaranteed to run classes
  • Learning Guarantee
  • Anytime after-training support for 30 days
  • Bilingual training, manuals & post-training support available

This course comes with

PDF Reference Guide

Take the Reference Guide anywhere and save the environment with an electronic copy of your training Reference Guide for use on any of your computers or devices



Printed Reference Guide

Instead of the PDF that comes with your course, purchase a printed paper Reference Guide for use during your class and future reference