Vision & Mission
Upcoming Events
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 2020
3A06-3A07, Block A,
Phileo Damansara II,
No. 15 Jalan 16/11, Seksyen 16,
46350 Petaling Jaya,
Selangor Darul Ehsan,

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.
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 -
This course will also be conducted at the following dates/venues
There are currently no events scheduled for other dates or venues.