Testing Message abc

Using MS Excel in Accounting

Offered by School of Business & Accountancy

Short Course / 24 hours / TGS-2021009902

Apply
Indicate Interest
Note: This course is now open for registration, please click on the APPLY button to submit your application. Please click on the INDICATE INTEREST button, to receive an alert about the future runs for this course. Thank you.
Course Information
Learning Outcomes
Course Schedule
Lesson Plan
Certification
Entry Requirements
Course Fees
Apply
Indicate Interest
Contact us for more information

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 
Schedule

,
,
,
,
,

Course Date:

  • 3 Aug (Online)
  • 5 Aug (F2F)
  • 12 Aug (F2F)
  • 19 Aug (F2F)
  • 26 Aug (F2F)

Application Period: 1 Jun – 3 Jul 2022
Duration: 24 hours
Time: 4 x 4 hours face-to-face lessons & 4 x 2 hours online lessons

  • 3 Aug (Online – 7pm – 9pm)
  • 5 Aug (F2F – 9am – 1pm)
  • 12 Aug (F2F – 9am – 1pm)
  • 19 Aug (F2F – 9am – 1pm)
  • 26 Aug (F2F – 9am – 1pm)

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)

Certification

Certification

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

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

(Course fee is payable upon acceptance. It is inclusive of 7% GST and subject to review.)

Applicants / Eligibility Fees
Full Course Fee$674.10