About This Course
This intensive hands-on course covers a number of key areas relating to the visualization of data to produce an interactive infographic. Infographic enhancements enable you to create visual representations of regionally related worksheet data that can point out trends and quickly convey their most pertinent information.
Learning Objectives
By the end of the course, learner will be able to:
- manipulate tables of data & use relevant functions to summarize the calculation into card/scorecard
- structure data efficiently in order to create infographic by filtering the TOP or BOTTOM in calculation
- use conditional formatting techniques to highlight specific data in color or in icon
- use specific charting techniques to indicate data numbers or percentage
Prerequisites
Learners must have advance knowledge & skill in Microsoft Excel.
Target Audience
Learners who need to interpret and communicate large quantities of information clearly by summarizing it into a single sheet of infographic.
Training Outline
- Introduction to Infographics
- Essentials Techniques for Creating Interactive Infographics
- Building an Interactive Infographic