ONLEARN COURSE
Data Storytelling with Excel: Beyond the Spreadsheet
Transform raw Excel data into compelling narratives and persuasive visualizations that drive decisions, not just display numbers. Learn to communicate insights effectively.
IntermediateEnglish3 sections4.5 hours443 students
What you’ll be able to do
- Identify key insights and trends within complex datasets using Excel's analytical features.
- Master advanced Excel charting techniques to create compelling and informative visualizations.
- Design and build interactive dashboards that allow for dynamic exploration of data.
- Apply principles of data visualization and storytelling to communicate insights effectively.
- Structure a data narrative to persuade stakeholders and drive informed decision-making.
- Utilize Excel's conditional formatting and sparklines for enhanced data presentation.
Inside this course
3 sections · 17 activities · 4.5 hours total length
01Module 1: Foundations of Data Storytelling & Advanced Visualization
- Introduction to Data Storytelling: Why it Matters15:00
- Identifying Your Audience and Message10:00
- Beyond Bar & Pie: Choosing the Right Chart25:00
- Crafting Effective Chart Titles and Labels10:00
- Hands-on: Advanced Chart Creation Practice30:00
02Module 2: Building Dynamic Dashboards and Interactive Reports
- Introduction to Interactive Dashboards in Excel15:00
- Using Slicers and Timelines for Dynamic Filtering20:00
- Form Controls: Drop-downs, Checkboxes, and Scroll Bars20:00
- Leveraging Conditional Formatting for Visual Cues15:00
- Sparklines and Data Bars: Mini-Charts for Maximum Impact10:00
- Hands-on: Designing Your First Interactive Dashboard35:00
03Module 3: Principles of Data Storytelling & Presentation
- The Narrative Arc: Structuring Your Data Story15:00
- Minimizing Clutter and Maximizing Clarity (Data-Ink Ratio)10:00
- Using Color Effectively in Your Visualizations10:00
- Annotations and Explanations: Guiding the Audience10:00
- Presenting Your Data Story with Confidence15:00
- Project: Crafting and Presenting a Full Data Story30:00
About this course
Transform your raw Excel data into compelling narratives. This course goes beyond basic charting, equipping you with advanced techniques to craft powerful data stories that drive insight and action.
Who this is for
- Business analysts, marketing professionals, and project managers who need to present data clearly.
- Anyone currently using Excel who wants to enhance their data visualization and reporting skills.
- Professionals looking to move beyond basic charts and create more dynamic and interactive reports.
- Individuals who want to improve their ability to communicate data-driven insights to stakeholders.
- Students and researchers needing to present complex information in an understandable format.
Before you begin
- A basic understanding of Excel functions and formulas (e.g., SUM, AVERAGE, VLOOKUP).
- Familiarity with creating basic charts and pivot tables in Excel.
- Microsoft Excel 2016 or newer (Office 365 recommended) installed on your computer.
- A desire to transform raw data into impactful insights and stories.
LEARNING EXPERIENCES
294 ratingsLearner ratings
4.5 / 5 · Average learner rating
A few useful details
How will I learn?
Work through the course sections and activities in your Onlearn course player, at your own pace. Your progress is saved to your account.
Is this a subscription?
No. Each course is purchased separately with one payment.