Jump to Section

Course Overview

This is a 1-day short course which introduces participants to various advanced functions in Microsoft Excel 2010 or 2013 that will help improve an organisation’s productivity and streamline operational work. It covers the use of conditional formatting, macros, formulas, charts, filters and pivot tables to enhance spreadsheets, automate repetitive tasks and improve work efficiency.


This programme is suited for participants working in areas such as Banking, Financial Services, Finance and Accountancy. Individuals who use Excel extensively in their daily work will find this course especially helpful. Participants should have some basic knowledge of using Excel before attending the course. 

Who Should Attend

Learners who want to pick up the basics of data preparation, formatting with Microsoft Excel.

What You'll Learn

  • Introduction to data preparation 

  • Formats, Types, and Encodings part 1 

  • Formats, Types, and Encodings part 2 

  • Cleaning of Excel file part 1 

  • Cleaning of Excel file part 2 

  • Protecting cells in Excel 




Participants will be issued with a Certificate of Performance upon meeting 75% of the required course attendance.  

Course Schedule

Intake Info Application Closing Date Course Duration

9 AM – 5 PM


1 Day


Registration may be closed earlier due to overwhelming response.


Application Procedures


Click on the Apply button above to submit your application online. Steps to follow in your application:

Step 1 - Enter NRIC/ Passport No.
Step 2 - Select ZKC and course commencement date.
Step 3 - Enter personal, qualification, employment and sponsoring details (if applicable).
Step 4 - Select, rank your preference for the selected subject(s) and indicate the number of subject(s) you wish to take. Please note that the subject start date(s) denotes the semester start date.
Step 5 - Make declaration and submit online application.

Course Fees

Fee Type Item Total Fees (w GST)
Full Course Fee S$321.00

Singapore Citizens aged 39 years old and below / Singapore Permanent Residents

Singapore Citizens aged 40 years old and above / SME-Company sponsored Singapore Citizens & Singapore Permanent Residents S$36.30

SkillsFuture Credit Approved. For more details, please click here.


With effect from 1 Jul 2020, the Workforce Training Scheme (WTS) will be replaced by Work Support Scheme (WSS), for more information, please visit:





Please note that participants should achieve at least 75% of attendance and sit for the assessment at the end of the course. Participants who fail to meet the requirements will be withdrawn from their funding eligibility and participant/company sponsor will be requested to make payment for the difference in the course fee, which is the funded amount.

Lecturer/Trainer Profile

You May Also Be Interested In

Course Contact

  • 67881212
  • 8.30 am to 6.00 pm (Mon to Thu)

    8.30 am to 5.30 pm (Fri)

    Closed on Sat, Sun & Public Holidays

  • Website: https://www.tp.edu.sg/tsa
  • Temasek SkillsFuture Academy

    Temasek Polytechnic

    East Wing Block 1A,

    Level 3, Unit 81

    21 Tampines Avenue 1,

    Singapore 529757

  • Temasek Polytechnic reserves the right to alter the course, modify the scale of fee, amend any other information or cancel course with low enrolment.

Ask TP