Vision & Mission
Upcoming Events
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 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
 
Interactive Visual Reporting and Analytics with Microsoft Excel DashboardMid Valley City, KL 5-6 December 2019
Download Registration Form
 
Data Visualization is crucial in enhancing decision making and addressing critical corporate issues. With Excel Dashboard, it brings users to the forefront on the technology of data visual display to enhance reporting, analysis and performance management. Visual analytics will enable users to spot business issues, crucial data and problems needing attention at a glance. Microsoft Excel Dashboard is an ideal tool in putting all these data together, making meaning out of it and displaying the analysis easily in an interactive dashboard form.
 
Objectives
Enable users to create appropriate, informative, easy to understand and interactive visual dashboards by:
  • Understanding the concepts of creating dashboards and visual displays
  • Identifying the essential techniques and methods of visual reporting
  • Integrating all the critical components in data analysis by using the relevant functions and formulas
  • Applying the creative combinations of dashboard charting techniques and design in analyzing data
 
Topics Covered
Day 1
 
Lesson 1: What is Visual Reporting
  • Outlining steps of creating reports
  • Identifying what to do and what to avoid in creating reports
 
Lesson 2: Identifying the Right Charts in Visual Reporting
  • Excel Charts as the key element in visual reporting
  • Identifying the different charts:-Thermo-meter charts, Tornado Charts, Indexed Charts, Funnel Charts, Sparklines and Interactive Chartings
 
Lesson 3: Form Controls
  • Leveraging Form Control, an interactivity tool in creating interactive, user friendly and powerful reports.
  • Uncovering the `big mystery’ of Form Controls. Exploring and mastering the usage of the 5 important Form Controls.
 
Day 2
 
Lesson 4: Conditional Formatting
  • Extending functional capabilities of Conditional Formatting in creating Visual Reporting.
  • Leveraging on the 5 conditional formatting `tips and tricks’ in transforming reports into impressive visual reports.
 
Lesson 5: Applying Functions in Visual Reporting
  • Applying the relevant functions in Visual Reporting.
  • Leveraging the creative combination of Excel Functions and Form Controls in creating a visual report.
  • Create reports that are fully interactive which enables updating automatically.
 
Lesson 6: Evaluating Case Studies
  • With the practical approach in using both the KPI (Key Performance Indicators) and Sales Interactive Visual Report (SIVR) case studies throughout the class, users evaluate and learn the applicability of Visual
 
 
 
Target Audience
This course is relevant to managers in Human Resources, Sales, Finance and all who needs to analyze, design and present meaningful visual reports. Participants are required to have the knowledge of Excel Functions prior to attending.
 
 
Methodology
  • Lecture
  • Demonstration
 
 
Scheme SBL Fee RM 1378
Duration 14 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.