Excel: Data Storytelling for Beginners

Excel: Data Storytelling for Beginners

34mIntermediate2024-01-04

Authors

Jordan Goldmeier

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

Introduction

  • Telling stories with your data in Excel
  • Why storytelling in Excel is important

The Basics of Data Storytelling

  • What does it mean to tell a story with data
  • The four key components of a data story

Using Excel to Tell Data Stories

  • Laying out the data set in Excel
  • Examples of data story telling with Excel charts
  • Enhance the story with labels, titles, and other elements
  • Highlighting key data points with conditional formatting
  • Creating interactive Excel elements to engage the audience

Advanced Tips for Excel Data Storytelling

  • Enhancing data visualization with Excel add-ins
  • Analyzing trends and patterns with AI
  • Engaging the audience with emotion, metaphors, and more

Conclusion

  • Bringing it all together
40,000 Toman