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
Feasible Study and Decision-Making using Microsoft Excel `What-If-Analysis’
 
Objectives
 
Topics Covered
Module 1: Data Tables
  • Develop a calculation system to analyse your data
  • Effectively selecting the most viable option from the multiple of results shown
  • Apply `sensitivity analysis’ model to determine which assumption are critical in decision making
 
Module 2: Goal Seek Function
  • Effectively get the optimum output/factors to attain your objective/results or target value in a single dimension problem
  • Leveraging on practical examples and applying the concepts and factors at work
 
Module 3: Scenarios
  • Identify and accessing the various output results by selecting the best case and worst case scenarios/situation.
  • Apply practical example in projecting forecast, costings and analysis
 
Module 4: Solver
  • Effectively manage multi-variable problems in Excel
  • Identify your constraints and limitation in analyzing and solving problems
  • Leveraging on practical examples and applying concepts at your work setting
 
 
Target Audience
 
Methodology
  • Lecture

  • Demonstration

 
Scheme SBL Fee RM 636
Duration 7 Hours Members Less -