2008 Course List

(All programmes are eligible for reimbursement under the HRDF - SBL Scheme and are held in Kuala Lumpur unless otherwise stated) Last Updated: 19 August 2008

 

July Courses 2008

7 & 8	Interviewing Techniques for Selection & Promotion
14 & 15	Teknik & Strategi Pemungutan Hutang yang Berkesan
21 & 22	Financial Analysis in Decision Making Using Excel Worksheet Models

 

August Courses 2008

19 & 20	Advanced Excel Techniques for Management
21 & 22	The Effective Training Administrator
25 & 26	Perkhidmatan Pelanggan Yang Cemerlang
27 & 28	Breakthrough Creative Thinking & Problem Solving (rescheduled to 9 & 10 September 2008)

 

September Courses 2008

9 & 10	Breakthrough Creative Thinking & Problem Solving (rescheduled from 27 &28 August 2008)
15 & 16	Mastering Financial Formulas & Functions in EXCEL
18 & 19	Rights & Obligations of Employers under Malaysian Laws
23 & 24	Creating & Analyzing Databases using MS Excel

 

October Courses 2008

23 & 24	Structuring & Managing Business Contracts
30 & 31	Advanced Excel Techniques for Management

 

 

---

BREAKTHROUGH CREATIVE THINKING & PROBLEM SOLVING       (A836)

Date:  9 & 10 September 2008      (rescheduled from August 2008)

Venue:  The Legend Hotel, Kuala Lumpur

Download Brochure

Key Benefits & Highlights:

Rediscover your own personal creativity

Apply the techniques of developing your thinking skills

Understand Left Brain & Right Brain characteristic: Whole brain thinking

Uncover your “mental blocks” to overcome barriers to creativity

Generate creative ideas.

Use powerful exercises for building personal and group creativity

Build up the ability to generate choices

The participants will practice solving a common problem

Course Contents:

CREATIVITY

•   What is it?

•   Why be creative?

•   What is creative thinking?

•   Exercises: Connecting the unconnected

THE BRAIN

•   Functions

•   The Left - Right brain: characteristics and uses

•   Convergent & Divergent Thinking

•   What is needed for creative thinking

•   Visualization

•   Video

•   Instrument: Your Creative Profile?

THE MINDSET

•   Paradigm effect

•   Strategies for changing mindset and increase perspectives

•   Video

•   Exercise

CREATIVE PROBLEM SOLVING

•   Steps in problem solving

•   How do you define a problem?

•   Consequences of an unattended problem

•   Exercise

STRATEGIES FOR CREATIVE PROBLEM SOLVING

•   Brainstorming for identifying problems

•   Rules for generating ideas

•   Mind / Concept mapping

•   Exercise

ISHIKAWA DIAGRAM

•   Determine causes of the problem

•   Prioritise the main causes

•   Determine alternatives

STRATEGIES FOR CREATIVE THINKING

•   Seeing what no one is seeing

•   Using the SCAMPER approach

•   Making thoughts visible

•   Presentation

•   Use of ‘Think Pak’

EVALUATION & CLOSING

 ▲Top

---

ADVANCED EXCELtm TECHNIQUES FOR MANAGEMENT        (A834)

Date: 19 & 20 August 2008

Venue: The Legend Hotel, Kuala Lumpur

Download Brochure

Key Benefits & Highlights:

Creating an interactive inventory program with current running balance

Calculating a person’s age based on today’s date

Formatting: removing unwanted spaces from a sentence, and replacing text

Calculating difference between two dates and times

Using Logical functions to indicate data relationships and decision criteria

Looking up employee’s information based on his/her name and vice-versa

Determining letter grades for test scores

Working out loan repayment calculations based on different interest rates and number         of years

Calculating sales forecast figures based on previous sales figures; etc…

Course Contents:

1.   ADVANCED FORMATTING AND VALIDATING RANGE

·  Learn various tools and techniques in formatting and validating a range of values

·  Learn to apply Conditional Formatting

2.   LOGICAL FUNCTIONS

·  Applying the IF statement

·  Applying the Nested IF statement

3.   LOOKUP FUNCTION

·  Applying VLOOKUP

4.   FINANCIAL FUNCTIONS

·  Learn to apply the NPV and IRR functions for project appraisal

·  Application of PMT Function for loan calculation

5.   TEXT FUNCTIONS

·  Learn to use the CONCATENATE, REPLACE, TRIM, EXACT, and UPPER Functions

6.   CREATING PIVOT TABLE AND ANALYZING DATA

·  Creating Pivot Table

·  Updating Pivot Table

·  Modifying Calculated Field in Pivot Table

·  Creating Chart From Pivot Table

7.   AUTOMATING ROUTINE TASKS WITH MACROS

·   Understanding Macros

·   Recording Macros

·   Applying Macros

8.   STATISTICAL FUNCTIONS

·   Learn functions for Forecasting and Comparison (Eg. Sales figures...)

9.   OTHER EXCEL FUNCTIONS

·  Learn to Rank variables

·  Learn the use of SUMPRODUCT Function

·  Analysing Tables

 ▲Top

---

CREATING AND ANALYZING DATABASES USING MICROSOFT EXCEL             (A838)

Date:  23 & 24 September 2008

Venue:  The Legend Hotel, Kuala Lumpur

Download Brochure

Key Benefits & Highlights:

How to create a database; sort; search, extract, manipulate data for analysis

All about manipulating data within a given set (database) – which is generally not covered and taught at other courses

To create forms to enter data into an Excel database. It is there as soon as Excel recognizes your set of data as a database

To use the Query Wizard and Array formulas to develop reports that have the layout that you need, when you need them

The techniques of interfacing with Access databases; and analysing imported data from dedicated database applications like Oracle, PeopleSoft, and SQL Server into Excel

Course Contents:

1. Understanding concept of a database

2. Application of logical functions (IF, NOT, AND, OR)

3. One-way and two-way data tables     (when to use either one)

4. Creating a Data Form, and moving around on the Form

5. Introducing array formulas

6. Dimensions of an array     (one and two dimensional arrays)

7. Working with array formulas     (learn application of array formulas with other built-in Excel functions)

8. Performing operations on an array     (some use of mathematical operators within arrays)

9. Understanding some Database functions

10. Working with Lists        (understand what you can do with lists)

11. Filtering a List       (application of filters and advanced filters for summarizing data)

12. Applying Database functions with Lists

13. Using external database file        (understand how Excel extracts data from an external file)

14. Performing a query       (use of Query Wizard)

15. Analyzing data with Pivot Tables       (another method of summarizing and presenting data)

16. Putting it all together       (case study given)

 ▲Top

---

TEKNIK & STRATEGI PEMUNGUTAN HUTANG YANG BERKESAN          (A828)

Date: 14 & 15 Julai 2008

Venue: The Legend Hotel, Kuala Lumpur

Download Brochure

Matlamat & Faedah Kursus:

Memahami kepentingan pemungutan hutang dan implikasinya terhadap aliran wang tunai

Menggunakan pelbagai cara yang efektif untuk memudahkan pemungutan hutang, terutamanya melalui telefon, surat peringatan atau notis, dan sebagainya.

Menyertai bengkel praktikal yang dapat mengasah kecekapan tawar-menawar untuk penyelesaian hutang dan sebagainya.

Memahami minda penghutang dan cara-cara menanganinya untuk pemungutan yang lebih efektif.

Kandungan Kursus:

1. Pentadbiran Bahagian Pemungutan Hutang

·   Memahami rintangan pemungutan di syarikat anda

·   Apakah waktu perniagaan anda?

·   Sistem “pegawai sokongan” dalam pasukan pemungut

·   Persetujuan mengenai struktur dan aliran proses

2. KPI Kewangan yang harus diawasi

·   Hutang Harian yang belum selesai (DSO)

·   Bilangan panggilan dalam sehari

·   Nisbah Pungutan / Panggilan

·  Kos tanggungan bayaran yang belum dipungut

3. Mewujudkan bahasa yang selaras

·   Peraturan komunikasi yang tetap untuk pemungutan

·   Pencatatan perjanjian di dalam diari Kredit anda

·   Rintangan yang dihadapi untuk pemungutan yang jauh

4. Mewujudkan sistem pemungutan hutang anda

·   Bersedia untuk panggilan yang harus dibuat besok

·   Menetapkan sasaran pemungutan

·   Merancang cara perbualan untuk pemungutan

5. Peranan Pemungut untuk mengesan and     menindas taktik berlengah

·   Penggunaan ketegasan sambil menekan tanpa berkasar (biadap)

·   Tanggungjawab utama sebagai seorang pemungut hutang

·   Prihatin terhadap kata kekunci yang digunakan oleh penghutang dan membincangkannya di mesyuarat ahli-ahli pemungut

·   Memahami punca perlengahan (kelambatan) yang benar

6. Kecekapan berkomunikasi untuk pemungutan yang efektif

·  Ciri-ciri perbualan vokal dan lisan *  Pertuturan yang positif untuk penghasilan yang positif *  Nada dan keyakinan *  Had keramahan dengan penghutang/pelanggan

·   Perbezaan berkomunikasi secara tegas (asertif) dan agresif

7. Memahami penghutang (pelanggan) yang cuai dan lalai

·   Faktor-faktor utama yang menyebabkan kecuaian penghutang

·   5 keadaan emosi yang lazimnya menyebabkan kecuaian penghutang

8. Penafsiran, Maklum balas dan Soal Jawab

 ▲Top

---

FINANCIAL ANALYSIS IN DECISION MAKING Using EXCEL Worksheet Model     (A831)

Date:  21 & 22 July 2008

Venue:  The Legend Hotel, Kuala Lumpur

Download Brochure

Some Key Benefits and Reasons not to miss this event!

Get an overview of Financial Modeling and its applications to various        financial decision making situations

Learn to apply specific tools of worksheet construction to assist in analysing        business information

Apply precise and specific ratios to develop a profile of business        performance over time with some predictive ability

Understand how to incorporate market data into financial planning for         corporate decision making

Develop specialized templates as part of workshop activities (which will then be        emailed to each participant for their personal use)

Learn to apply specific tools of risk analysis to enhance the decision making process

Program Outline:

Day One: FINANCIAL ANALYSIS

Introduction to Financial Modelling

·  Financial Modelling applications

·  Limitations and caveats in the use of Financial Models

·  Financial Modelling enhancements to Financial Analysis

Financial Analysis for Decision Making

·  Decisions related to revenue generation:   * Market Share vs. Profit Margin   * ROI or absolute profits

·  Decisions related to Outsourcing (Make, Do or Buy):   * Projected Cash Flow Profiles   * Issues of relevance, price stability and taxes

·  Decisions related to Borrowing Levels

·  Decisions related to level of Working Capital:   * Tracking the Cash Conversion Cycle

·  Other decisions based on individual participant requirements

Workshop Session I

·  Financial Analysis Models for :   * Revenue Analysis   * Cost Structure Analysis   * Working Capital Analysis

Day Two: RISK ANALYSIS

Modeling for Risk

·  Sensitivity

·  Breakeven or tolerance levels

·  Flexible Budgets

·  Expected Values and Standard Deviations

·  Beta Values

Capital Expenditure Decisions

·  Feasibility Studies

·  Establishing Target rate of return

·  Analysis of Projected Cash Flows using :   * Payback Period   * Net Present Value   * IRR

·  Customising your worksheet to compute these values ‘manually’ so that information is clearly presented for decision making

Workshop Session II

·  Establishing the projected cash flow profile

·  Developing the templates for Analysis

·  Building in Sensitivity into the template

·  Applications of sensitivity to :   * Operating Leverage   * Financial Leverage   * Total Leverage

·  Determining tolerance levels from sensitivity

Analysis, Reporting and Decision Making

 ▲Top

---

INTERVIEWING TECHNIQUES FOR SELECTION & PROMOTION             (A833)

Date:  7 & 8 July 2008

Venue:  The Legend Hotel, Kuala Lumpur

Download Brochure

Key Benefits & Highlights:

Reduce costly selection errors

Improve productivity by hiring the "right" person for the job

Use the format for interviewing & scoring

Improve your skills in the art of asking questions

Improve listening skills - an often neglected skill

Get the relevant information by developing an application form

Verify information & evaluate resumes

Identify & promote talented people from within

Do’s and don'ts at an interview

Know how to spot suspicious or faulty documents