15 Oct1 day
- Time
- 09:00 – 17:00
- Venue
- Venue to be confirmed
$600 nettRegister
Generative AI · SZCAI11
Automate Excel with ChatGPT and AI
Clean, combine and classify Excel data with ChatGPT in one day. Practise formulas, data enrichment and document extraction.
✓ Beginner level✓ Lunch, snacks and refreshments provided
Course overview
Why use ChatGPT and AI in Excel?
Pair familiar Excel skills with generative AI. By using AI inside spreadsheets and prompt templates, participants learn to ingest, clean, transform and reconcile data in a fraction of the usual time — directly in Excel.
Outcomes
- Recognise where generative AI delivers the biggest time savings when manipulating Excel data
- Apply prompt techniques to ask ChatGPT for advanced Excel formulas
- Use a custom GENAI() function inside Excel to enrich, classify and complete data row by row
- Automate tedious cleaning tasks such as deduplication, standardisation, merging and PDF extraction with ChatGPT
This course is suitable for
- Beginners who are new to AI
- Lifelong learners upgrading their skills in a more data-driven workplace
- People who want to apply automation and AI 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.
24 Nov1 day
- Time
- 09:00 – 17:00
- Venue
- Venue to be confirmed
$600 nettRegister
27 Apr1 day
- Time
- 09:00 – 17:00
- Venue
- Venue to be confirmed
$600 nettRegister
29 Jul1 day
- Time
- 09:00 – 17:00
- Venue
- Venue to be confirmed
$600 nettRegister
12 Oct1 day
- Time
- 09:00 – 17:00
- Venue
- Venue to be confirmed
$600 nettRegister
Course fees and funding
Fees and funding
Course fee: $600 nett
The course fee is $600 nett. Contact us with any questions about payment or registration.
Course syllabus
From formulas to AI-driven cleaning.
1.Understanding AI’s role across different steps in manipulating Excel data
2.Refresher on key Excel formulas
3.Prompt engineering: generating complex Excel formulas with AI
4.Create a custom GenAI() formula and use it directly within Excel
5.AI-driven data cleaning and transformation
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
- Use Excel at least once a week in your day-to-day job
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