LOOKING FOR RATES AND SCHEDULES TO JOIN A PUBLIC CLASS?
CLICK HERE.

NEED A PROPOSAL FOR COMPANY? 
​EMAIL [email protected]

Data Visualization and Storytelling
Modern organizations generate large volumes of data, but data alone does not create understanding. The ability to transform numbers into clear insights is now a critical workplace skill for analysts, supervisors, managers, and professionals who need to influence decisions. This program focuses on helping participants communicate meaning through charts, dashboards, and narratives that are easy to interpret and actionable for different audiences.
​
Participants will learn how to structure a compelling data story, choose the right visuals, apply psychological principles in design, and create professional charts and dashboards using Microsoft Excel and PowerPoint. The workshop emphasizes practical application, clarity of communication, and real-world business presentation techniques rather than simply creating visually appealing charts.


Main Objectives
By the end of the program, participants will be able to:

• Differentiate data visualization from data storytelling and explain how insights influence decision-making
• Select appropriate chart types based on data structure and communication objectives
• Create concise and audience-focused data stories using business datasets
• Build and customize charts in Excel for clarity, professionalism, and readability
• Apply psychological and design principles to improve interpretation and attention
• Integrate Excel visuals into PowerPoint presentations effectively
• Develop dashboards that present information logically, ethically, and clearly

Who Should Attend
This program is ideal for:

• Data analysts and reporting personnel
• Supervisors and managers presenting operational metrics
• Finance, sales, HR, and operations professionals
• Business professionals working with Excel reports and dashboards
• Trainers and consultants presenting data-driven insights
• Anyone responsible for communicating findings through charts and reports

Methodologies
Methodology 1: Guided Demonstration and Hands-on WorkshopsParticipants will follow live demonstrations in Excel and PowerPoint while building charts, dashboards, and visual stories using structured datasets and practical exercises.

Methodology 2: Data Storytelling Presentation ActivitiesParticipants will analyze datasets, identify key insights, and present short data stories while receiving feedback on clarity, visual effectiveness, and audience adaptation.

Outline

I. Introduction to Communicating with Data

• Understanding the language of data and how audiences interpret numbers
• Stages of data storytelling from raw data to insight and action
• Differentiating data visualization from data storytelling

II.  Data and Charting Concepts

• Data types: categorical vs. numerical
• Matching charts to purpose: comparison, trends, distribution, relationships
• Choosing metrics: percentages vs. raw values
• Tables vs. charts vs. pie charts

III. Preparing to Tell Your Data Story

• Creating a focused 3-minute data story
• Identifying the single main idea your data needs to communicate
• Adapting the story for different audiences (clients, managers, colleagues)

IV. Creating and Customizing Charts in Excel

• Creating basic charts from structured data
• Modifying formats for clarity and professionalism
• Editing key elements: labels, data series, gridlines, legends, data tables
• Adding titles and annotations for context

V. Special Charts and When to Use Them (Curated Selection)

• Line and Scatter charts for trends and correlations
• Pie, Tree Map, and Sunburst for composition
• Waterfall and Area charts for change over time
• Histograms for distribution
• Map charts for geographic data
• Sparklines for compact trend visualization

VI. Applying Psychological Principles in Data Storytelling

• Applying Tufte’s data-ink ratio to remove clutter and noise
• Using Gestalt principles to control visual perception:
  • Good order and symmetry
  • Similarity and continuation
  • Proximity and closure
• Applying pre-attentive attributes to guide attention
  • Using light–dark shading effectively
  • Applying size, contrast, and orientation to emphasize meaning
  • Effective color usage for readability

VII. Presenting and Linking Charts to PowerPoint

• Linking charts from Excel
• Embedding vs. linking
• Using Paste Special to preserve format and data

VIII. Applying Context to Visuals

• Adding clarity through legends, chart titles, and axis labels
• Using annotations to highlight insights
• Adding subtitles and short explanatory texts to support interpretation

IX. Preparing Your Dashboard

• Structuring and laying out dashboard components
• Adding objectives, story stream, and indicators of dashboard certainty
• Data Visualization Ethics

Related Courses

Basic MS Excel

MS PowerBI for Beginners

Advanced MS Excel

Macros and VBA Programming

​Excel for Data Analytics

Download Outline

Find Public Class

Send Email