Automate Excel with Python for Beginner
A 2 day course that teaches Python basics and how to use Python to automate spreadsheet operations. Suitable for beginners!
COURSE DETAILS
9AM to 5PM
HRP Course Type Code: SZC-PY21
Course Fees: $1200.00 nett
View course dates and times →
Trusted by companies, institutions and government agencies
for training and implementation needs
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Company logo
Course Overview
WHY LEARN PYTHON?
Python is one of the fastest-growing programme language and is favoured by data analysts globally.
OUTCOMES
By the end of this course, participants will achieve the following:‍
  • Understand programming basics and Python syntax
  • Understand the concept of open source libraries
  • Manipulate tabular data using the pandas library
    - Filtering
    - Data Operations (Adding columns)
    - Merge and concat tables
    - Aggregation
    - Dealing with string data types and timestamps
THIS COURSE IS SUITABLE FOR:
  • Beginners who are new to programming and analytics
  • Lifelong learners who would like to upgrade their skillsets in an increasingly data driven world
  • Apply data analytics and automation in their daily work
COURSE DETAILS
9AM to 5PM
HRP Course Type Code: SZC-PY21
Course Fees: $1200.00 nett
Course Dates And Venue
LOADING ..
Venue:  
Course Syallabus
  • Python and programming basics
  • Data structure - Lists and dictionaries, how the internet passes data around with JSON
  • Basics to Application Programming Interface (Python’s request library)
  • Table data manipulation with Pandas - Querying / selecting data
    - Data Operations
    - Merge, Concat
    - Aggregation
    - Dealing with string data types and timestamps
Pre-requisites
  • Need a laptop with unrestricted internet access (no download of software is needed)
  • Have good English proficiency (English language at GCE 'O' Level of B4 and above, or WSQ Workplace Literacy skills of Level 7 and above).
  • Possess basic information and communication technology (ICT) skills.
  • Programming knowledge is not required
Course Instructor
Brandon Ong
Lead Trainer at Sozcode
I highly recommend the Data Analysis and Visualization with Python course taught by Brandon Ong. The course is suitable for both complete novices and people who have some prior coding experience.

Brandon understands his audience's needs very well and pitches his lessons at a suitable level, avoiding complex jargon and concepts where possible. He also motivates concepts and techniques he teaches with interesting anecdotes.
Kenneth Kwok
Principal Research Scientist
A*STAR
Brandon was very clear in articulating his words and constantly reminding us that we can stop him at any point for him to repeat a process. The activities that were taught to us are very relevant to the use cases in SCDF.
Kimi Soh
Development Officer
Singapore Civil Defence Force
Brandon is really dedicated, passionate, patient. he managed to package the training in a super interactive, concise and fun manner. Its easy to retain knowledge by seeing the application of Python. This is refreshingly different from other courses
Peck Hwang Wong
Marketing Manager
Amazon
Brandon has received consistent positive feedback from the course attendees on his clear content delivery and patience in guiding the participants through scenarios which are relevant and applicable to real world challenges faced by organisations. The attendees were kept engaged during the highly interactive, well designed course and are encouraged to continue their learning of the subject matter beyond the workshop.
Doreen Ang
Trainer
Nanyang Technological University
Brandon is very knowledgeable and passionate about this topic, with plenty of real-life experiences in-built into his teaching. Instead of going chapter by chapter, we learn to apply the basic but important knowledge and go straight to playing with the software and visualization.
Ding Hui Fang
Senior Executive (Procurement)
Prime Minister’s Office
Brandon provides good project focused learning rather than the typical classroom style lecture. Examples given are very practical and real world
Yip Churn Keit
AOO
Singapore Police Force

Refreshingly different from other courses

Brandon is really dedicated, passionate, patient. he managed to package the training in a super interactive, concise and fun manner. Its easy to retain knowledge by seeing the application of Python.
Peck Hwang Wong
Marketing Manager, Amazon

Plenty of real-life experiences in-built into his teaching

Brandon is very knowledgeable and passionate about this topic. Instead of going chapter by chapter, we learn to apply the basic but important knowledge and go straight to playing with the software and visualization.
Ding Hui Fang
Senior Executive (Procurement), Prime Minister’s Office

Very relevant to our use cases

Brandon was very clear in articulating his words and constantly reminding us that we can stop him at any point for him to repeat a process.
Kimi Soh
Development Officer, Singapore Civil Defence Force

Attendees were kept engaged during the highly interactive, well designed course

Brandon has received consistent positive feedback from the course attendees on his clear content delivery and patience in guiding the participants through scenarios which are relevant and applicable to real world challenges faced by organisations. The attendees are encouraged to continue their learning of the subject matter beyond the workshop.
Doreen Ang
Trainer, Nanyang Technological University

Project focused learning rather than a lecture

Brandon provides good project focused learning rather than the typical classroom style lecture. Examples given are very practical and real world
Yip Churn Keit
AOO, Singapore Police Force
OUR TRAINING METHODOLOGY
Big-Picture Learning
Long, chapter-by-chapter course
tedious to understand
Traditional technology courses are usually taught chapter by chapter. Students often get bored and lost in a very lengthy learning process.This lengthy learning process discouragesmost students through their learning journey.
Big picture understanding of data and AI by teaching selected chapters in a 2 day course
By teaching only relevant chapters to achieve a big picture understanding, we keep students engaged throughout our course. We hope to educate and inspire individuals just enough to get started, experiment and break things.
Big-picture learning with selected chapters
Predict Singapore property prices in 2 days
• Python Basics
• How to think of Lists and Dictionary like a table
• Pandas and plotly
• Data visualisation hackathon (colleagues will present insights)
• Intuition and concepts behind machine learning
• Scikit-learn, Tensorflow
A generic Python course
Introduction to Python
• Python Basics: chapter 1, chapter 2...
• Loops, If: chapter 1, chapter 2...
• Functions: chapter 1, chapter 2...
• NumPy: chapter 1, chapter 2...
OUR TESTIMONIALS
Hear it from our participants
1 Goldhill Plaza, #02-27,
Singapore 308899


Email: courses@sozcode.com


Whatsapp: +65 8505 8176
© 2023 SozCode. All Rights Reserved.