Vision & Mission
Upcoming Events
Training Programs
 
Industrial Relations
HR Management
& Development
Occupational Safety
& Health
Business Management
ICT
Certification &
Academic Courses
In-house Courses
PSMB Scheme
Academy Staff
Contact Us
 
Training Directory 2019
 
MEF ACADEMY
3A06-3A07, Block A,
Phileo Damansara II,
No. 15 Jalan 16/11, Seksyen 16,
46350 Petaling Jaya,
Selangor Darul Ehsan,
Malaysia

Tel: 603-7955 7778
Fax: 603-7955 1945
 
 
Upcoming Trainings & Events
 
Data Visualisation with Microsoft Excel Interactive Charts Midvalley City, KL 24 June 2019
Download Registration Form
 
How do you present your data and reports using Excel Charts in a concise, effective and appealing way? As your audience struggle to grapple with lots of numbers and loads of information, you have a demanding task to choose the most relevant visual techniques and get the message across.
This course enables you to quickly discover options and techniques for your audience to grasp your presentation easily and effectively. Your charts will get your audience to see what they want to see and what is useful to them.
 
Objectives
  • Learn to deliver the Excel Chart presentation in a focused, comprehensible and convincing manner.
  • Identify which charts to use in different scenarios, for different purposes and how best to present your data.
  • Leverage on the Excel Functions to create dynamic and interactive Charts. These will enable you to update and filter your data and all information will be reflected in your chart immediately.
  • Explore innovative ideas to enhance your chart presentation.
 
Topics Covered
Module 1: Introducing the Microsoft Excel Charting
  • Explore various types of Excel Charts
  • Identify the relevant chart for different scenarios, presentations and purposes
  • Familiarize the distinctive components in creating charts
  • Create Essential Charts – Combination Chart, Column Chart and a Bar of Pie Chart
Module 2: Chart Sparklines to Spot Data Trends
  • Leverage the feature of Sparklines – enable audience to analyse trends on the spot.
  • Discover the Types of Sparklines – Line, Column, Win/Loss
  • Apply changes in Sparklines – The Style, The Sparkline Type, Points on the Sparkline and Display Range
 
Module 3: Key Data Visualization Options

Select the most relevant charts for different presentations, scenarios and purposes.

  • Thermometer Chart – Tracks attainment on how much on a goal has been achieved
  • Target Conditional formatting – Indicates Max and Min points with comments
  • Line Chart with KPIs Colored band – presents a clearer and distinct visualization context
  • Variance Chart – Indicates the actual performance against expected performance
  • Waterfall Chart – Understands the cumulative effect of positive and negative values impacting a subtotal or total value
 
Module 4: Applying Interactive Charts
Apply crucial formulas in setting a framework of a feasible, dynamic and Interactive Chart
  • Create chart that automatically expand as new data is entered
  • Produce Charts that are scalable, feasible which enable users to automatically update, summarize trends, report of a latest 12 month period
  • Incorporate dynamic scroll bar to increase and decrease the data range of the chart
  • Insert checkboxes to allow users to choose what to display
 
Target Audience

​This course is relevant to professionals of all levels who present reports and figures using Excel Charts. The audience will be able to get a quick and precise grasp of their presentation.

 
Methodology
  • Lecture
  • Demonstration
 
Scheme SBL Fee RM 530
Duration 7 Hours Members Less -
 
This course will also be conducted at the following dates/venues
 
There are currently no events scheduled for other dates or venues.