Welcome to TED Learning!

  • 12-07, Binjai 8 Premium SOHO, No. 2 Lorong Binjai, 50450 Kuala Lumpur
  • Phone: +603-2742 1828
  • training@ted.com.my

Infographic Training Course - Infographics Using Microsoft Office

By tedadmin | March 26, 2018

Awesome ImageEasy In Conveying Information

Awesome ImageInteresting and Easy To Understand

Microsoft Office can be very usefull for your daily work whether in the office or at home. But lot of people don’t know that Microsoft Office also can be used to create an infographic.

This 1-day course will teach participants some of the techniques involved in creating an info- or data graphic using no more than the basic tools found in Microsoft Office.

What Will I Learn From Infographic Training Course?

Planning The Infographic

Great explorer of the truth, the
master-builder of human happiness
No one rejects.

Storytelling Technique

Participants will learn the techniques, with a particular emphasis on identifying critical pieces of
information.

Using Shape and Images

chooses to enjoy a pleasure that
has no annoying consequences, one a
pain that produces.

Course Outline

Employers across all industry sectors to ensure that their internal sed Human Resource systems processes align to their business requirements idea of denouncing pleasure and praising pain was born and I will give you a complete account of the system, and expound the actual teachings of the great explorer of the truth.

  • Module 1 : Planning
  • Module 2 : Document Setup
  • Module 3 : Showcasing Information
  • Module 4 : Beyond the infographic

From Information to Story

  • What to keep, what to lose
  • “Chunk-ifying” the information Planning
  • Planning the infographic
  • The do’s and don’ts of infographic creation
  • Styling considerations – Infographic styles & usage

Setting up

  • Page/slide sizing
  • Using guides and the grid

Working with colour

  • Basic colour theory
  • Selecting & setting colours
  • Creating & saving colour schemes

Fonts

  • Font selection & readability
  • Using symbol fonts (dingbats)

Conveying Statistics

  • Emphasizing Data – using pictograms
  • Showing People – using silhouettes & repeating shapes
  • Depicting Time & Timelines – using progression & icons
  • Information segmentation

Using Charts

  • Creating & formatting charts for infographics
  • Using Chart Layouts
  • Best Practices for charts

Data Comparisons

  • Datasets
  • Shapes & Drawing
  • Creating custom shapes
  • Editing shape points

  • Saving & sharing the finished
  • Resources for infographics










Previous client that we have conducted training with

Lorem Ipsum is simply dummy text of the printing and typesetting industry.
Lead Manager
Text Title
Lorem Ipsum is simply dummy text of the printing and typesetting industry.
Lead Manager
Text Title
Lorem Ipsum is simply dummy text of the printing and typesetting industry.
Lead Manager
Text Title

Over 32 years of experience we’ll ensure you get the best guidance.

Request Quote

Awesome Image

Easy In Conveying Information

Awesome Image

Interesting and Easy To Understand

Microsoft Office can be very usefull for your daily work whether in the office or at home. But a lot of people don't know that Microsoft Office also can be used to create an infographic.

This 1-day course will teach participants some of the techniques involved in creating info- or data graphic using no more than the basic tools found in Microsoft Office.

What Will I Learn From Infographic Training Course?

Planning The Infographic

After attending this course, student will be able to understand and apply the concept of basic spreadsheet in Microsoft Excel.

Students also will able to format and use multiple worksheets when working with MS Excel.

Storytelling Technique

Participants will learn the techniques, with a particular emphasis on identifying critical pieces of information.

Using Shape and Images

Chooses to enjoy a pleasure that has no annoing consequences, one a pain that produces.

Course Outline for This Programme

  • Module 1
  • Module 2
  • Module 3
  • Module 4

 

Module A1: Consolidating Data with Excel

  • Creating Links
    • Linking Sheets Within the Workbook
    • Linking to Other Workbooks
    • Amending Broken Links
  • Using Data Consolidate
    • Consolidate By Position
    • Consolidate By Category
  • Consolidate Data Using Formulas

 

Module A2: Auditing a Worksheet

  • Tracing Formulas and Errors
    • Trace cells that provide data to a formula (precedents)
    • Trace formulas that reference a particular cell (dependents)
  • Error Checking
    • Correct common formula errors one at a time
    • Correct an error value
  • Watch Window
    • Add cells to the Watch Window
    • Remove cells from the Watch Window
  • Protecting Your Files and Worksheets
    • Locking & Unlocking Cells
    • Setting Multiple Range Passwords
    • Protecting The Contents of a Worksheet
    • Protecting The Structure of a Workbook
    • Encrypting Your Workbook

 

Module A3: Managing Excel Data

  • Introducing Excel Tables
    • Inserting a Table
    • Benefits of A Table
    • Removing A Table
  • Sorting Data
    • Performing A Quick Sort
    • Performing A Complex Sort
    • Using A Custom List
    • Sorting Based On Colors
  • Entering Data Using Forms
    • Customizing the Quick Access Toolbar
    • Entering New Data
    • Editing Data
    • Performing A Criteria Base Search
    • Filtering Data
    • Using Filters
    • Using Custom AutoFilter
  • Advanced Filtering
    • Using Multiple OR To Filter
    • Using Multiple AND To Filter
    • Using AND & OR To Filter
    • Using Wildcards To Filter
  • Subtotals
    • Adding Subtotals
    • Adjusting Views with Subtotals
    • Removing Subtotals
    • Performing Nested Subtotals
  • Validating Data Entry
    • Creating A Drop Down List
    • Creating A Customized Error Message
    • Controlling Values & Dates
    • Using Formulas to Control Data
  • Importing Text Files
    • When to Use Delimited
    • When to Use Fixed Width
    • Using Text To Column to manipulate data

Dcoument Setup : Setting up

  • Page/slide sizing
  • Using guides and the grid Working with colour
  • Basic colour theory
  • Selecting & setting colours
  • Creating & saving colour schemes Fonts
  • Font selection & readability
  • Using symbol fonts (dingbats)

Showcasing Information : Conveying Statistics

  • Emphasizing Data – using pictograms
  • Showing People – using silhouettes & repeating shapes
  • Depicting Time & Timelines – using progression & icons
  • Information segmentation Using Charts
  • Creating & formatting charts for infographics
  • Using Chart Layouts
  • Best Practices for charts Data Comparisons
  • Datasets Shapes & Drawing
  • Creating custom shapes
  • Editing shape points

Beyond the infographic

  • Saving & sharing the finished
  • Resources for infographics

Feel Free To Inquire About our Range of IT Training in Malaysia







Previous client that we have conducted training with

The Coffee Bean & Tea Leaf Malaysia
Swis Resources Sdn Bhd
Cypark Resources Berhad

Over 32 years of experience we’ll ensure you get the best guidance.

Request Quote