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

Tel: 603-7498 7200

Information & Communication Technology
Feasible Study and Decision-Making using Microsoft Excel `What-If-Analysis’
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
  • Lecture

  • Demonstration

Scheme SBL Fee RM 636
Duration 7 Hours Members Less -