[01] COURSE INTRODUCTION

Excel is one of the most important programs for the Accounting professionals. Anyone with a strong Excel knowledge will find it can be readily applied in various business processes, from analyzing stocks, business viability, budgeting, generating financial results, or financial planning. Simply put, Excel skill is an indispensable tool for supporting major business decisions.

Learn What-if analysis, Goal Seek & Solver to improve your finance, budget, cash flow & P&L performance. Familiarise with widely used techniques using Excel NPV, IRR, Payback to monitor your financial projects. Software programs with well-tested Excel templates will be provided. Attendees will also learn better via the handholding workshop session filled with examples, exercises and practical.

[02] COURSE OBJECTIVES

By the end of this course you will be able to (practical hands on experience):

• How to manage your Profit & Loss, Cash Flow position in Excel

• How to plan your Budgets

• Using Goal Seek to manifest Management Expectations on Sales, Profit & Cash Flow

• Improve your Financial Project Evaluation Skills

[03] WHO SHOULD ATTEND

Accountants, Business Managers, Marketing Managers, Treasurers, Entrepreneurs, Supervisors, Executives and Managers and all professionals who are interested in Microsoft Excel Advance for Finance.

[04] PREREQUISITES / METHODOLOGY

Please bring laptop along equipped with Microsoft Excel 2016 or above.

Case Study & Group Discussion, Exercises.

[05] DATE, TIME & FEE

Date:           18 July 2025 (Fri)
Time:           9.00am - 5.00pm
Mode:         Online/ Interactive

FEE

[ HRDF Claimable ] 

   - Early Bird Offer (before 30 Jun 2025) – RM 720
   - Special Offer (before 14 Jul 2025) – RM 780
   - Normal Fee – RM 840

>> Fee includes Course Notes, Certificate of Completion and 8% Service Tax

OFFER  

- 10% Cashback for SST2u Learner Card+ (SLC+) members. T&Cs applied.

[06] COURSE OUTLINE

Module 1: What-If Analysis, Excel Goal Seek & Solver - Managing P&L & ROI

• Introduction

• Revisit measurements: Sales, Purchases, Operating Expenses, Investment, Capital Injection, Depreciation & Interest Payment

• Understand your own P&L, Balance Sheet, Cash Flow & Equity

• Suggest Strategies (using Goal Seek) to improve your Cash Flow & P&L positions

Module 2: What-If Analysis to Improve Financial Ratios Performance

Objective: Understand how to interpret the Financial ratios

• Liquidity

• Solvency

• Efficiency

• Profitability

• Asset Management

Module 3: What-If Analysis to Prepare & Monitor Budgeting & Sales, Collection, Expenses Performance 

Objective: Step-by-Step Guidance in Budget Making

• Sales

• Cost of Sales

• Gross Profit

• Operation Expenses

• Net Profit

Module 4: Excel NPV, IRR, Free Cash Flow Tools for Project Financial Planning & Monitoring

Objective:

(i) Assess Project Evaluation & its Risks

(ii) Accepting/Rejecting Project or Business Proposal after factoring in all Financial & Quality Considerations

• Forecasting Relevant Project Cash Flows

• Project Evaluation Techniques – Payback, NPV, IRR

• Excel Applications – Using the Payback, NPV and IRR functions

• Accepting or Rejecting Projects

Module 5: Specific Formula & Function

• Gantt Chart (Project Scheduling)

• Scenario Planning (Best, Worst & Likely Scenario)

Q&A Session

End of Training

[07] TRAINER PROFILE

DR. STEVEN LIEW

HRDF Accredited Trainer, Consultant

Dr Steven Liew is a fellow member of the Chartered Institute of Management Accountants, UK and is a Chartered Accountant by profession. He has an Asia Pacific Executive MBA (for senior executives) from the National University of Singapore and a PhD in international finance with Rushmore University of USA.

Dr Liew had worked in private sector companies, ranging from family-run businesses to professionally managing multi-national corporations in South Asia and the ASEAN region. He has accumulated more than 30 years working experience in senior financial & operational management positions spearheading the profitability and growth of companies. He has worked for the MBF Finance & its related group of companies over the 10 years period.

He is a registered Trainer with the Government Human Resources Development Berhad (Pembangunan Sumber Manusia Berhad). And he is a GST Tax Consultant and has successfully completed the Custom examination.

Dr Steven Liew had conducted various seminars for corporate clientele including:

Association of Credit Management Malaysia, Chartered Institute of Management Accountants, Malaysia Institute of Management, Malaysia Institute of Accountants, Institute of Bank Bank Malaysia, Nestle, IQPC Worldwide Pte Ltd (Singapore), Lexis Nexis, Proton Edar Malaysia, Brunei Investment Agency, Small Medium Industries Development Corporation, Ministry of Development Brunei, BICPA Asean Management Brunei, Risda Group of Companies, Sales & Marketing Training Forum (Sri Lanka), Giant Retail Sdn Bhd, Telekom Brunei, Ministry of Foreign Affairs Malaysia, Sabah Electricity Sdn Bhd, Bank Islam Brunei Darussalam, Continental Tyres, Sime Darby Bhd, Sony Malaysia Sdn Bhd, Perodua Sdn Bhd, Credit Guarantee Corporation (M) Bhd, Fujixerox, UDA Holdings, SPNB, Diners Club, Elk Desa Capital Bhd, Antah Schindler, UCSI, Ministry of Finance, Seccom Sdn Bhd, Bridgestone Chemical Products (M) Sdn Bhd, Dialog Group Bhd, SEDCO KK, Hosiden Electronics (M) Sdn Bhd, STO Maldives, Indah Water Consortium Sdn Bhd, CPA Australia (M) Sdn Bhd.

He is currently providing management consultancy and training specializing in Fast Closing Monthly, Leadership, Strategic Planning, Sales Management, Budgeting, Accounting, Finance, Cost Reduction, Credit Management & Loan Recovery.

[08] ENQUIRY & REGISTRATION

Enquiry: yes@sst2u.com

Contact:

   - Whatsapp Only (012 - 824 8874)
   - Teo (011 - 3178 9203)
   - Logesh (012 - 503 0346)
   - Siti (012 - 383 8603)
   - Nisa (019 - 851 5134)
   - Central Region (03 - 8604 7270)
   - Northern Region (04 - 222 6850)
   - Southern Region (07 - 213 3676)
   - East Malaysia (011 - 3178 9203)