Uncover Python in Excel for Data Analysis (Classroom & Asynchronous e-learning)

Offered by School of InfoComm Technology

Short Course / 3 days lessons and 1 day async learning / TGS-2024041204

Course Information
Learning Outcomes
Course Schedule
Lesson Plan
Entry Requirements
Course Fees

Course Information

This is an introductory exploration of Python programming specifically tailored for use within the Excel environment. This course aims to equip individuals with the foundational knowledge of Python programming and its application in data manipulation and analysis within Microsoft Excel.

Combining Python and Excel would change how users organise, analyse and visualise their data with Machine Learning, Predictive Analytics and Forecasting to specialized visualizations such as heatmaps, violin plots and swarm plots.

Learning Outcomes

By the end of this course, participants will have the fundamental skills to apply Python within the Excel environment, empowering them to manipulate data and enhance their productivity in using Excel.



Course Date: TBC
Application Period: TBC
Duration: 32 hours (24 hours classroom + 8 hours asynchronous learning)

Time: 9am to 6pm
Delivery Mode: Classroom
Venue: Ngee Ann Polytechnic

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

Lesson Plan

Topics covered:

  • Introduction to Python and Excel Integration
  • Variables, Data Types, and Operators
  • Conditional Statements and Loops
  • Functions and Libraries for Excel
  • Data Manipulation and Analysis in Excel using Python
  • Error Handling and Debugging


A Certificate of Performance will be awarded to participants who achieve at least 75% attendance and pass all required assessment(s).
A Certificate of Participation will be awarded to participants who meet the 75% attendance requirement but did not pass all required assessment(s).

Entry Requirements

  • Basic digital literacy

Course Fees

Funding period for this course is from 03 Jan 2024 to 30 Sept 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.


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 9% GST and subject to review.)

Applicants / Eligibility Fees
Full Course Fee$872.00
Singaporeans aged below 40 qualified for SkillsFuture Funding*$261.60
Singaporeans aged 40 & above qualified for SkillsFuture Mid-Career Enhanced Subsidy*$101.60
Singaporeans qualified for Enhanced Training Support for SMEs*$101.60
Singapore Permanent Residents & **LTVP+ qualified for SkillsFuture Funding$261.60
Singapore Permanent Residents & ##LTVP+ qualified for Enhanced Training Support for SMEs$101.60
Others (and Repeat Students)$872.00