Using MS Excel in Accounting (Classroom, Synchronous and Asynchronous)

Offered by School of Business & Accountancy

Short Course / 24 hours / TGS-2021009902

Note: To receive an alert about the future runs for this course, please click on the INDICATE INTEREST button. Thank you.
Course Information
Learning Outcomes
Course Schedule
Lesson Plan
Trainer Profile
Entry Requirements
Course Fees

Course Information

This is a certification program in which participants will obtain a Certification on Accounting Transformation upon completion of 6 courses:

  1. Accounting for Analysis and Decisions
  2. Using MS Excel in Accounting
  3. Performing Cloud-Accounting
  4. Finance-Business Partnering with Data Visualisation
  5. Strengthening Internal Controls with Analytics
  6. Automation of Processes with RPA

The overall program is aimed at equipping bookkeepers with skillset to enable them to chart out their progression paths in view of existing industrial developments causing disruption to job roles. The program provides participants with knowledge and hands-on skills in visualisation, automation, etc. in order to help them stay relevant and employable.

Learning Outcomes

Upon completion of this course on Using MS Excel in Accounting, participants will acquire knowledge of excel functions and organize data in Excel, and make use of various What-If Analysis tools to aid in data analysis.


Course Date: 5 Jan – 2 Feb 2024
Online date (7pm to 9pm): 5 Jan 2024
F2F dates (1pm to 5pm): 12, 19, 26 Jan, 2 Feb 2024
Application Period: 17 Nov – 17 Dec 2023
Duration: 24 hours
Time: 4 x 4 hours face-to-face lessons & 4 x 2 hours online lessons
Delivery Mode: Classroom with Synchronous & Asynchronous e-Learning
Venue: Classroom & Online

Ngee Ann Polytechnic reserves the right to reschedule / cancel any programme, modify the fees and amend information without prior notice.

Lesson Plan

All sessions will be conducted on a weekly basis within the same month

Session 1: (6 hours)

  • Working with Formulas & Functions (I) (E-Learning: 2 hours on a weekday evening)
  • Working with Formulas & Functions (II) (F2F: 4 hours on a weekday morning)

Session 2: (6 hours)

  • Formatting, Organizing & Getting Data: Excel Tables (E-Learning: 2 hours asynchronous)
  • Formatting, Organizing & Getting Data: Data Tables & Pivot Table (F2F: 4 hours on a weekday morning)

Session 3: (6 hours)

  • Creating Simple Chart objects (E-Learning: 2 hours asynchronous)
  • Formatting, Organizing & Getting Data: Sort, Filter, Group, Outline. Data Consolidation (F2F: 4 hours on a weekday morning)

Session 4: (6 hours)

  • Data validation & Formula Auditing (E-Learning: 2 hours asynchronous)
  • What-If Analysis (Scenario, Goal Seek, Solver) (F2F: 4 hours on a weekday morning)

Trainer's Profile

Yvonne Ng

Yvonne Ng holds a Bachelor degree in Business with a specialization in Actuarial Science and a Masters of Science (Financial Engineering) from Nanyang Technological University. She is also a certified Financial Risk Manager.

Prior to joining Ngee Ann Polytechnic, Yvonne was an actuarial analyst at Great Eastern Life. Yvonne’s teaching experience spans across fundamental to advanced finance courses in the polytechnic. A School Teaching Award recipient, Yvonne is well versed in teaching both pre-employment and adult learners.

Yvonne also actively engages in consulting projects with various organizations.


A Certificate of Performance will be awarded to participants who achieve at least 75% attendance and pass the assessment.

Participants will further obtain a Certificate on Accounting Transformation upon completion of all 6 courses in the program.

Entry Requirements

  • Basic Proficiency in English
  • Bookkeeping/ Accounting background

Course Fees

Funding period for this course is from 25 Nov 2021 to 30 Sep 2024.

SkillsFuture Credit
All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses. Visit the SkillsFuture Credit website to choose from the courses available on the Training Exchange course directory.

Union Training Assistance Programme (UTAP)
NTUC members enjoy 50% unfunded course fee support for up to $250 each year (or up to $500 for NTUC members aged 40 years old and above) when you sign up for courses supported under UTAP (Union Training Assistance Programme). Please visit e2i’s website to find out more.

Enhanced training support for SMEs
For enhanced training support for SMEs, enter SME in the promo code during course application.

Long Term Visit Pass Plus (LTVP+) holders, please furnish the following documents to the course administrator to qualify for SSG funding:
Self-sponsored learner (**LTVP+): Copy of your green visit pass card, with the word ‘PLUS’ on the back of the card.
Co-sponsored learner (##LTVP+): Copy of valid and current Letter of Consent (LOC) from MOM

GST Increment in 2024
Please note that the GST rate will be revised to 9% with effect from 1 Jan 2024. As such any payable course fees will be subjected to the new GST rate adjustments in 2024. Please refer to our STEP portal for the updated fees. (Click on STEP)


  • The fees below are determined based on prevailing funding policies and subject to review and revision.
  • Please refer to our FAQs for more information.

Ngee Ann Polytechnic reserves the right to reschedule/cancel any programme, modify the fees and amend information without prior notice.

Applicants / Eligibility Fees
Full Course fee$686.70
Enhanced Training Support for SMEs for Singapore Citizen$80.01
Enhanced Training Support for SMEs - SPR & LTVP+$80.01
SkillsFuture Mid-Career Enhanced Subsidy for Singapore Citizen aged 40 and above$80.01
SkillsFuture Baseline Funding for Singapore Citizen Aged Below 40$206.01
SkillsFuture Baseline Funding for SPR/LTVP+$206.01