Custom Data Visualizations in Excel
Custom Data Visualizations in Excel
Course Length:
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
Custom Data Visualizations in Excel
Upcoming Classes
All Public classes are held onlinewith a live instructor
| Dates | Price | Qty |
|---|---|---|
| November 28, 2023 9:00 AM to 4:00 PM ET | $495.00 Online | |
| February 27, 2024 9:00 AM to 4:00 PM ET | $495.00 Online | |
| May 24, 2024 9:00 AM to 4:00 PM ET | $495.00 Online |
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