Present Compelling Data Stories with Excel

Overview

In the course Present Compelling Data Stories with Excel, you will learn to transform your data from rows of numbers into a compelling story that drives decisions. In this intermediate course, you'll move beyond basic charts to master the art and science of data storytelling in Excel. Designed for financial analysts and professionals who need to communicate complex information, this course teaches you to apply proven design principles to build persuasive, easy-to-understand visual narratives. You will learn to select the right chart for your message, use visual cues such as color and annotations to highlight critical insights, and build dynamic, Excel-linked dashboards that update automatically. Through hands-on activity and real-world scenarios inspired by the visual strategies of companies like Apple and Amazon, you'll construct a layered waterfall chart to walk executives through a quarterly business review. Crucially, you'll also master the soft skill of refining your narrative by gathering, analyzing, and incorporating peer feedback, ensuring your final presentation is clear, logical, and impactful. By the end of this course, you'll be equipped to turn any dataset into a persuasive story that commands attention and inspires action.

Syllabus

Crafting the Narrative with Excel Charts

This module lays the foundation for effective data storytelling by focusing on the “how-to” of creating impactful visuals in Excel. Learners will move beyond basic charts to understand the principles of visual rhetoric, learning to select the right chart type to convey a specific message. They will get hands-on experience building dynamic, presentation-ready charts that use color, annotations, and structure to tell a clear financial story, inspired by best-in-class examples from companies like Apple and Tesla.

Refining and Presenting Your Data Story

This module focuses on the critical soft skills required to ensure a data story lands with impact. Learners will discover why even a well-designed chart can fail if its narrative is unclear. Using the Target Canada expansion failure as a cautionary tale of misleading data, they will learn to structure a peer review session, analyze constructive feedback, and use it to refine their presentation’s flow and clarity. The module culminates in a final project where learners revise their story based on AI-driven feedback, proving their ability to iterate and improve.