Short Course

Excel

Data Storytelling With Microsoft Excel

Overview

This course empowers participants to transform raw data into impactful stories using Excel. Participants will learn how to combine analytical insight with narrative and visualization design to communicate key messages effectively. Through practical exercises, learners will use Excel features such as PivotTables, Conditional Formatting, Charts, and Sparklines to reveal trends, patterns, and insights.

By the end of the course, participants will be able to craft compelling data stories that drive decisions—merging analytical logic with emotional resonance through visualization, structure, and narrative flow.

Who Should Attend

This course is intended for

  • Business analysts and data professionals seeking to enhance storytelling and visualization skills
  • Marketing, operations, and finance staff needing to communicate insights clearly
  • Managers and decision-makers interested in data-driven presentation techniques
  • Anyone who regularly prepares business reports or dashboards using Excel

Pre-requisites

  • No pre-requisite required
  • Participants are required to bring their own laptop PC or MacBook for the practical hands-on portions of the workshop
Enroll Now

1 Day

8 Hours

Level

Beginner

What You Will Learn

Understand the Principles and Framework of Data Storytelling

Explain the core concepts of data storytelling, including how to combine data, visuals, and narrative techniques to communicate meaningful insights that support business objectives and informed decision-making.

Apply Excel Data Visualization Tools Effectively

Utilize Excel features such as PivotTables, PivotCharts, Charts, Conditional Formatting, Sparklines, and other visualization tools to transform raw data into clear, engaging, and informative visual representations.

Design Audience-Centered Data Narratives

Create structured and compelling data stories by identifying the target audience, defining the key message, selecting appropriate visualizations, and presenting insights within a relevant business context.

Develop Interactive Dashboards and Insightful Reports

Build dynamic Excel dashboards and reports using interactive features such as slicers, timelines, and linked visualizations to enable users to explore data and uncover actionable insights.

Present Data Stories to Support Business Decisions

Deliver professional data presentations that effectively communicate findings, justify recommendations with evidence, and inspire stakeholders to make informed, data-driven decisions.

Course Outline

Day 1
  • Foundations of Data Storytelling
    • Understanding Data Storytelling: what, why, and how
    • The Data Storytelling Framework – narrative, visuals, and context
    • Knowing your audience and defining story objectives
    • Storyboarding and narrative planning using Excel and PowerPoint integration.
  • Drawing Insights from Data Visualizations
    • Visualization principles and choosing the right chart in Excel
    • Designing visual hierarchy using Conditional Formatting and Color Scales
    • Using PivotTables and Pivot Charts to identify patterns and trends
    • Employing Sparklines and mini-charts for micro visual storytelling
  • Presenting and Reviewing Stories
    • Best practices for presenting insights through Excel visuals
    • Tailoring stories for management, clients, and technical stakeholders
    • Collaborating with subject matter experts for validation
    • Reviewing and refining stories: ensuring message clarity and data accuracy
  • Creating Interactive and Dynamic Visualizations
    • Using Slicers, Filters, and Drop-down Lists for interactivity
    • Emphasizing clarity: avoid clutter, maintain simplicity, and focus on message delivery
    • Dynamic storytelling through scenario analysis and What-If tools
    • Enhancing interactivity with dynamic ranges and formulas

Trainers Profile

Peter goh

R. Swaminathan

Swami is a seasoned IT leader with over four decades of experience driving software development, consulting, and project management across the Asia Pacific region. Based in Singapore, he is the Co-founder and Director of Alegre Ventures Pte Ltd, a consulting firm dedicated to providing Data, AI, and Digital Transformation services.