Building Infographics Utilizing Microsoft Excel for Data Visualization

Infographics Utilizing Microsoft Excel for Data Visualization

mr palani murugappan

Duration : 2 Days

Intermediate to Advanced

Target Audience: Anyone with decent understanding on the workings of Excel and how they can tweak Excel charts to appear as infographics and present it meaningfully.

About the Course:

A well designed infographic can help simplify a complicated subject or turn a subject into captivating experience. An infographic is visual representation of information or data, e.g. as a chart or diagram. Adding an interactive content like infographics can be a good strategy in any reports and marketing campaigns. Ideally, an infographic is visually engaging, contains subject matter that is appealing to your target audience, and supported by other engaging content across various channels. This is what this program caters for in a highly descriptive and visually impacting manner.

Course Outline:

  1. UNDERSTANDING BASICS OF INFOGRAPHICS
    Identifying target audience
    Organizing your data
    Various aspects of chart types and subtypes
    Shapes that can be categorized as rectangles, lines, arrows, etc.
    Modifying different layouts
    Ability to link data to graphics
    Formatting of cell
    EXERCISE
  2. CREATING INFOGRAPHICS WITHIN EXCEL
    Displaying complex connection on a relatively small space
    Introducing vector objects
    Modifying charts and replacing with objects
    Creating custom infographics using icons
    EXERCISE
  3. SEEKINGINFORMATION FROM INFOGRAPHIC
    Informing your message
    Comparing similarities or differences among values
    Showing changes that are continuous over time
    Organizing groups, patterns, and order
    Seeking for relationship amongst data
  4. MAKING A TIMELINE INFOGRAPHIC
    Creating a story based on a Timeline
    Updating time periods with objects
    Replacing placeholder text and formatting of objects and colors
    Narrowing the scope of Timeline
    EXERCISE
  5. CREATING A COMMUNICATIVE INFOGRAPHIC
    Conveying a message with infographic
    Modifying structure of chart to accommodate communicative infographic
    Adding images and descriptive data
    Importance of looking good
    The final touch
    EXERCISE
  6. CREATING AN ANNUAL REPORT INFOGRAPHIC
    Defining the audience
    Structuring the story to communicate impact
    Aligning with existing design elements
    Tabulating the data
    Presenting the findings
    EXERCISE
  7. CASES & EXERCISES