Excel for Data Storytellers
Excel data visualization course online or in person
Why does abundance of Excel formatting features often lead us to confusing charts, that feel more like a labyrinth than a clear narrative? Why do we settle for “the recommended charts” that overwhelm rather than enlighten?
In today's data-driven world, your Excel charts need to do more than just display numbers; they need to tell an engaging story.
In this action-oriented workshop, you'll learn the secrets to transforming Excel from a mere data-crunching tool into a powerful storytelling device. Just in two hours you will master the most frequently needed formatting techniques for data storytelling that turn complex data sets into engaging, insightful narratives.
In a hands-on environment you will discover how to cut through the clutter, highlight critical insights, and craft stories that captivate and inform.
Step beyond the traditional data presentation. Join us to unlock the power of storytelling with Excel, ensuring your data not only informs but also inspires.
Course Duration:
Elevate your Excel data storytelling skills in a concise 2-hour workshop, filled with practical exercises for an immediate effect.
Who Should Attend:
This workshop welcomes anyone who uses Excel to create visual data representations. If visualizing data in Excel is part of your job, this workshop is designed for you.
Prerequisites:
Lack of experience in data visualization with Excel? Not an issue. This workshop is perfectly tailored for beginners.
Languages:
Dive into Excel for Data Storytellers in either Czech or English – it's your choice.
Where & How:
Online: Join me on MS Teams or any platform you prefer for a convenient online session.
In-Person: If you're in Prague or anywhere in Czech republic or nearby in Slovakia, Poland, Hungary, Germany, or Austria, I'll come to you. And if you're further away, just let me know – I love to travel for training!
Excel for Data Storytellers Course Syllabus
1. Data Storytelling process
- What's the Essence of Data Storytelling?
Revisit the core principles and key steps of the data storytelling process, setting a solid foundation for narrative excellence with Excel.
2. Chart Selection in Excel
- Which Chart Speaks Best?
Navigate through the process of choosing the ideal chart type, learning how to create, change, and manage combo charts and data series for your narrative needs.
3. Decluttering Your Charts
- What Can We Remove for Clarity?
Discover how to eliminate unnecessary chart elements and master formatting techniques to focus attention on the story your data tells.
4. Formatting Axes and Legend
- Do we need Axes and Legends for Our Story?
If we do keep them, let’s learn the ins and outs of axes and legend formatting to make these components integral to your data narrative.
5. Formatting Data Series and Data Points
- Where Does Data Storytelling Start?
Explore the critical role of data series formatting in highlighting key aspects of your story, emphasizing the narrative’s focal points.
6. Leveraging Labels and Markers
- How Do Labels and Markers Contribute to Our Story?
Uncover the power of labels and markers in guiding your audience through the data narrative, with practical tips on formatting.
7. Advanced Conditional Formatting
- Can We Automate Styling for Consistency?
Benefits of advanced conditional formatting to streamline the visual styling of frequently updated charts, ensuring consistency and reducing manual effort.
8. Incorporating Titles and Narratives
- What Should Our Charts Say?
Learn the art of integrating textual elements, such as titles and narratives, into your charts to succinctly and effectively convey your story.
9. Hands-on Practice
- Are You Ready to Apply What You’ve Learned?
Apply the design principles and formatting techniques through individual practical exercises.
10. Advanced Tips and Tricks and Interactive Q&A
- How Can We Elevate Our Data Story?
Finalize your learning journey with an interactive Q&A session, addressing specific challenges and deep-diving into Excel’s storytelling capabilities.
