3–5 Nov3 days
- Time
- 09:00 – 17:00
- Venue
- Venue to be confirmed
$1,200 before fundingRegister
Automation With Programming & AI · SZCPY21
Automate Excel with Python for Beginners
Learn Python and Pandas to filter, combine and summarise spreadsheet data in repeatable workflows.
✓ Beginner level✓ Lunch, snacks and refreshments provided✓ SkillsFuture Singapore funding eligible
Course overview
Why learn Python?
Python is one of the fastest-growing programming languages and is widely used by data analysts. This beginner course teaches Python basics, then uses Pandas to automate spreadsheet operations. SkillsFuture subsidies of up to 70% are available.
Outcomes
- Understand programming basics and Python syntax
- Understand the concept of open-source libraries
- Manipulate tabular data using Pandas, including filtering, adding columns, merge and concatenate, aggregation, and working with strings and timestamps
This course is suitable for
- Beginners who are new to programming and analytics
- Lifelong learners upgrading their skills in a more data-driven workplace
- People who want to apply data analytics and automation in daily work
Course dates and venue
Upcoming public runs.
Unconfirmed runs may be held at Village Hotel Bugis or Goldhill Plaza. We'll confirm the exact location before class.
16–17 Feb2 days
- Time
- 09:00 – 17:00
- Venue
- Venue to be confirmed
$1,200 before fundingRegister
12–13 Apr2 days
- Time
- 09:00 – 17:00
- Venue
- Venue to be confirmed
$1,200 before fundingRegister
13–14 Jul2 days
- Time
- 09:00 – 17:00
- Venue
- Venue to be confirmed
$1,200 before fundingRegister
17–18 Aug2 days
- Time
- 09:00 – 17:00
- Venue
- Venue to be confirmed
$1,200 before fundingRegister
14–15 Sept2 days
- Time
- 09:00 – 17:00
- Venue
- Venue to be confirmed
$1,200 before fundingRegister
16–17 Nov2 days
- Time
- 09:00 – 17:00
- Venue
- Venue to be confirmed
$1,200 before fundingRegister
Course fees and funding
Fees and funding
Course fee: $1,200 before funding
Nett fees below are after SkillsFuture funding. Remaining fees may be offset with SkillsFuture Credit where eligible.
Singaporeans aged 40 and above
- Full programme fee: S$1,200.00 nett
- Nett fee after SkillsFuture funding (70%): S$360.00 nett
Singaporeans aged below 40
- Full programme fee: S$1,200.00 nett
- Nett fee after SkillsFuture funding (50%): S$600.00 nett
Permanent Residents
- Full programme fee: S$1,200.00 nett
- Nett fee after SkillsFuture funding (50%): S$600.00 nett
Sponsored by SMEs (Enhanced Training Support for SMEs)
- Full programme fee: S$1,200.00 nett
- Nett fee after SkillsFuture funding (70%): S$360.00 nett
HRP sponsored
- Full programme fee: S$1,200.00 nett, with lunch, snacks and refreshments provided
- You can use SkillsFuture Credit, SkillsFuture Enterprise Credit (SFEC) and SkillsFuture Credit Top-Up to offset the remaining fees.
- SME-sponsored employees must be Singapore Citizens or Permanent Residents.
Course syllabus
Python basics, then Pandas on real tables.
1.Python and programming basics
2.Data structures: lists and dictionaries, and how the internet passes data with JSON
3.Application Programming Interface basics using Python’s requests library
4.Table data manipulation with Pandas
- Querying and selecting data
- Data operations
- Merge and concatenate
- Aggregation
- Working with string data types and timestamps
Pre-requisites
Before you attend
- Bring a laptop with unrestricted internet access; no software download is required
- Good English proficiency (GCE O-Level English B4 and above, or WSQ Workplace Literacy Level 7 and above)
- Basic information and communication technology (ICT) skills
- No programming knowledge required
Attendance requirement
Attendance requirements
- Singapore Citizens and Permanent Residents attending SkillsFuture Singapore (SSG) funded courses must take attendance digitally via the Singpass app, for both classroom and synchronous e-learning sessions.
- You must achieve at least 75% attendance.
Course completion requirements
Completion requirements
- You must achieve at least 75% attendance.
- Achieve "Competent" in all the assessments.
Course instructor
Who you'll learn from.
Brandon Ong
Lead Trainer at Sozcode
Brandon teaches Python, AI and automation and leads course design at Sozcode. His classes connect programming concepts to projects such as processing documents, analysing data and building applications.
Training methodology
End-goal driven learning.
Start with the end goal
Every foundation course begins with a practical project, from automating a task to building a simple app.
Learn only what matters
Only the topics that serve the end goal, so every lesson applies.
Verified reviews