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 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

 
 
Upcoming Trainings & Events
 
[IT] Interactive Visual Dashboard Reporting and Analysis with Microsoft Excel Online Learning – Microsoft Teams 20-21 June 2024; 15-16 July 2024 (9.00 AM – 5.00 PM)
Download Registration Form
 
Course Fee
RM 1, 400 (inclusive SST) per participant

 
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.
 
LEARNING OUTCOME
Using CASE STUDIES as a framework, this course will enable users to create appropriate, informative, easy to understand and interactive visual dashboards.
 
• Step 1 Understanding the concepts of creating dashboards and visual displays
• Step 2 Identifying the essential techniques and methods of visual reporting
• Step 3 Integrating all the critical components in data analysis by using the relevant functions and formulas
• Step 4 Applying the creative combinations of dashboard charting techniques and design in analysing data
 
WHO SHOULD ATTEND
This course is relevant to managers in Human Resources, Sales, Finance and all who needs to analyse, design and present meaningful visual reports. Participants are required to have the knowledge of Excel Functions prior attending.
 
COURSE OUTLINE
Module 1: What is Visual Reporting
Module 2: Identifying the Right Charts in Visual Reporting
Module 3: Form Controls
Module 4: Conditional Formatting
Module 5: Applying Functions in Visual Reporting
Module 6: Evaluating Case Studies
 
*For more information, please click and refer to the brochure.
 
This course will also be conducted at the following dates/venues
 
There are currently no events scheduled for other dates or venues.