Vision & Mission
Upcoming Events
MEFA Monthly Calendar
Training Programs
 
Industrial Relations
HR Management
& Development
Occupational Safety
& Health
Business Management
ICT
Certification &
Academic Courses
SWINBURNE
Certified Programs
UNIMAS
Certified Programs
In-house Courses
PSMB Scheme
Academy Staff
Contact Us
 
Training Directory 2024
 
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-7498 7200

 
 
Information & Communication Technology
Data Visualisation with Microsoft Excel Interactive Charts
 
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 -