Excel: Data Storytelling for Beginners
34mIntermediate2024-01-04
Authors
Jordan Goldmeier
Author, Entrepreneur, and Keynote Speaker
Course details
What’s the difference between a confusing, information-packed spreadsheet and one that clearly communicates key data points? Storytelling. You may not think of Excel as the right place for business storytelling, but it’s actually the perfect place. Combining Excel's data visualization features with a few basic storytelling techniques can ensure you communicate your data in a simple and concise way for your audience. In this course, Microsoft Excel MVP Jordan Goldmeier begins by outlining the basics of data storytelling, including the key components of a good data story. Then he shows how to use Excel to tell your data story, covering how to create your data set, choose the right chart types, and enhance your story with labels, titles, and other elements. Plus, Jordan highlights how to enhance your story with data visualization features from Excel add-ins.
Skills covered
Data VisualizationBusiness IntelligenceSpreadsheetsMicrosoft ExcelData ScienceBusiness Analysis and StrategyBusiness Software and ToolsMicrosoftOne-Off
Concepts
0. Introduction
- 01 - Telling stories with your data in Excel
- 02 - Why storytelling in Excel is important
1. The Basics of Data Storytelling
- 03 - What does it mean to tell a story with data
- 04 - The four key components of a data story
2. Using Excel to Tell Data Stories
- 05 - Laying out the data set in Excel
- 06 - Examples of data story telling with Excel charts
- 07 - Enhance the story with labels, titles, and other elements
- 08 - Highlighting key data points with conditional formatting
- 09 - Creating interactive Excel elements to engage the audience
3. Advanced Tips for Excel Data Storytelling
- 10 - Enhancing data visualization with Excel add-ins
- 11 - Analyzing trends and patterns with AI
- 12 - Engaging the audience with emotion, metaphors, and more
4. Conclusion
- 13 - Bringing it all together