Automate Excel with ChatGPT and AI
In this 1 day hands-on workshop, learn how to pair familiar Excel skills with cutting-edge generative-AI tools. By embedding Generative AI directly in spreadsheets and using prompt-engineering templates, participants learn to ingest, clean, transform, and reconcile data in a fraction of the usual time directly on Excel.
In partnership With:
COURSE DETAILS
✅ Suitable for beginners
✅ Lunch / snacks / refreshments provided
1 day, 9AM to 5PM
HRP Course Type Code: SZC-AI11
Nett Course Fees: $668.00
View course dates and times →
Brandon teaching in front of the class
OUR TESTIMONIALS
Hear it from our participants
Course Overview
OUTCOMES
By the end of this course, participants will achieve the following:‍
  • Recognise where Generative AI delivers the biggest time-savings when manipulating Excel data.
  • Apply prompt techniques to ask ChatGPT to create advanced Excel formulas for your problem
  • Use a custom GENAI() function inside Excel to enrich, classify, and complete data row by row.
  • Automate tedious cleaning tasks on spreadsheets such as deduplication, standardisation, merging, PDF extraction with ChatGPT
THIS COURSE IS SUITABLE FOR:
  • Beginners who are new to AI
  • Lifelong learners who would like to upgrade their skillsets in an increasingly data driven world
  • Apply automation and AI in their daily work
COURSE DETAILS
9AM to 5PM
HRP Course Type Code: SZC-AI03
Course Fees: $600.00 nett
Course Dates And Venue
LOADING ..
Venue:  
If our venue is not confirmed, we will be using one of these facilities below:
Course Syallabus
  • Understanding AI’s Role Across Different Steps In Manipulating Excel Data
  • Refresher on key Excel formulas
  • Prompt Engineering: Generating Complex Excel Formulas with AI
  • Create a custom GenAI() formula and use it directly within Excel
  • AI-Driven Data Cleaning and Transformation
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.
  • Use Excel at least once a week in your day to day job
Course Instructor
Brandon Ong
Lead Trainer at Sozcode
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
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
End-Goal Driven Learning
OUR MOTIVATION
For Beginners, Learning Programming Chapter-By-Chapter Can Feel Like A Never Ending Journey
As a beginner, learning programming can feel overwhelming with multiple chapters to cover. It’s easy to lose sight of the purpose behind each topic and how they come together to create a final product.

Often, the relevance and objectives of individual chapters may not be immediately clear, making the learning process seem exhausting.

OUR APPROACH
Starting with the End Goal in Mind
Instead of learning concepts chapter-by-chapter, all of our foundational courses begin by defining a clear, practical project or problem to solve.

This could be anything from automating a task to building a simple application.

Learning Only What Matters
We don’t cover every possible chapter—instead, we select only the most essential topics that significantly contribute to achieving the end goal.

Every chapter is taught in direct relation to its practical use, ensuring learners understand why it matters and how it fits into the end goal. This keeps learning focused, efficient, and highly applicable.
1 Goldhill Plaza, #02-27,
Singapore 308899


Email: courses@sozcode.com
Instagram: Sozcode

LinkedIn: Sozcode

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