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
 
Feasible Study and Decision-Making using Microsoft Excel `What-If-Analysis’Mid Valley City, KL 18 November 2019
Download Registration Form
 
What-If-Analysis is the process of changing the values in Excel computation to see how the changes will affect the outcome of formulas/results on the worksheet. Understanding the implications of changes and the factors that cause the changes are crucial when it comes to analysing your data and making decisions. What would be the effect of an increase of costs, or if the turnover rose/fell by a certain amount? How would a change in interest rates or exchange rates affect your profits? Excel offers easy-to-use tools to save time calculating and help to make more accurate forecast. The four types of `What-if-analysis’ are the Data Tables, Scenarios, Goal Seek and Solver.
 
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 -
 
This course will also be conducted at the following dates/venues
 
There are currently no events scheduled for other dates or venues.