Duration
2 days
INTRODUCTION
Infographics has grown in importance in the business environment. One of the most powerful aspects of an infographic is to help readers understand information more quickly.
Did you know you could create amazing Professional Looking Infographics using Microsoft Excel? Explore the power of Microsoft Excel to create beautiful Visual and dynamic Infographics to make your Dashboards look smarter and be appreciated for your data Visualization Skills.
Combine the skills of creating infographic by extracting important data from Excel, together with the amazing tools and great features from PowerPoint to impress your audience with professional infographic presentation.
PREREQUISITES
This course is meant for students who wish to create beautiful, animated infographics using MS Excel and PowerPoint for Data Visualization and Presentation.
You should possess basic knowledge in Excel formulas and functions, able to create simple charts and know how to use PowerPoint to create simple presentation slides.
LEARNING OBJECTIVES
You will be able to come out with good presentations, captivate different audiences and make yourself memorable, stand out among your peers & competitors, and allow your good work to be valued by your superiors & clients, leading to smooth career progression. For managers, you will inspire and move people to action.
MODULE 1: PRESENTATION STRUCTURE
- What are the objectives of your presentation?
- How can you capture attention from the start?
- Why & how should you always introduce a problem?
- How do you solve the problem?
- How do you end with impact?
- How do you answer questions?
MODULE 2: UNDERSTANDING YOUR DATA
- How to get the most out of your data
- Creating a Table in Excel
- How to Create the Pivotable Table
- How to use Power Query to Clean up and Import Messy Data into Excel
- Preparing PivotTable and Creating Pivot Chart
MODULE 3: Understanding Advanced Array Functions in Excel 365
- What is an Array function and when should we use it
- Unique Functions
- Sort, and Sortby Functions
- Filter Functions
- Offset Function
- Sequence Function
MODULE 4: Important Excel Functions for Data Preparation
- Sumproduct Function
- Index/Match Function
- Iferror Function
- Text Function
- Rows/Columns Function
MODULE 5: Creating Infographic and Dynamic Chart in Excel
- Prepare all data and putting all PivotTable and Data together
- Creating a Speedometer Chart
- Creating Interactive and Dynamic Chart with Excel Functions
- How to create Interactive Infographics in Excel
Module 6 – A Quick Overview of PowerPoint Tips and Tricks
- Using PowerPoint as a Graphic Design Tool
- Saving and Exporting GIF Images from PowerPoint
Module 7 - Simple animation & Transition
- Entrance, emphasis & exit animation
- Start animation using trigger
- How to use transition to create endless timeline or processes
Module 8 -SmartArt
- Inserting SmartArt
- One clicks Organization Chart with SmartArt
- Add Assistant(s) to your Organization Chart
Module 9 – Linking Charts and Infographic from Excel to PowerPoint
- How to link charts and infographics from Excel to PowerPoint
- Completing the whole presentation of the Infographic creation from Excel and PowerPoint, with interactive controls and animation
Programme scope, delivery arrangements and suitability are confirmed during enquiry.