Data Storytelling with Microsoft Excel and PowerPoint
Software Version: M365-2010
Course Code: MS-DS-EXPP
Course Certification: -
Duration: 1 Day
Introduction
Data storytelling is the process of presenting data in a clear, compelling, and visually appealing way to communicate insights and information to an audience. Microsoft Excel and PowerPoint are both commonly used tools for data storytelling, as they allow users to organise, analyse, and present data in a variety of ways.
In Excel, data can be analysed and organised using functions, pivot tables, and charts. This allows users to uncover insights and trends in the data that can be used to inform their story. PowerPoint can then be used to create a presentation that visually represents the data and insights in a clear and compelling way. Users can create charts, tables, and graphics, and arrange them in a way that guides the audience through the story. They can also add text, images, and other multimedia elements to supplement the data and make the story more engaging.
Participants will learn how to transform raw data into impactful stories, and with the assistance of Copilot and other generative AI tools, they will also see how intelligent tools can support them in analysing data, generating visuals, and drafting narrative text—helping to make data storytelling faster, clearer, and more impactful.
Course Objectives
Data storytelling should be more than just showing numbers, it should be way to discover, interpret and communicate insights to others.
- A clear story: The story should be easy to understand, have a clear structure and logical flow, and be relevant to the audience.
- Relevant data: The data used should be meaningful and relevant to the story, and should be presented in a way that supports the story's main points.
- Visualisation: The data should be visualised in a way that makes it easy to understand and interpret. Charts, graphs, tables, and other visualisation types can help to communicate complex data in a simple and easy-to-understand format.
- Engagement: The story should be engaging and interactive. This can be achieved by using a mix of text, images, and other multimedia elements, as well as by involving the audience in the story through questions or activities.
- Actionable insights: The story should provide actionable insights that the audience can use to make decisions or take action.
- Context: The story should provide the context that is needed to understand the data and its relevance.
- Clarity: The data and insights should be communicated in a concise, clear and simple manner.
Methodology
- Real-life case studies and simulations.
- Hands-on tasks and exercises to help participants build modern workplace skills and stimulate critical thinking.
- Delivered in your preferred language: Choose from English, Malay, or Mandarin to ensure maximum engagement and comprehension for diverse participants.
Prerequisites
Completion of Microsoft Excel – Basic and Intermediate, and PowerPoint – Basic, Intermediate and Advanced; or equivalent knowledge.
Who Should Attend
This course would be beneficial for individuals who use Excel and PowerPoint to create reports and presentations. It would also be useful for anyone who wants to improve their data visualisation skills and learn how to effectively communicate data through storytelling. This course may be particularly useful for professionals in business, finance, marketing, and other data-intensive fields.
Please get in touch with us for the latest, updated course outline.
