Python
4 lessons
Beginner
#PY01
Python Lists, Dicts & Loops — The Essentials
Master Python's most-used data structures with practical examples you'll use every day in data work.
Intermediate
#PY02
Pandas DataFrames — Clean & Transform Data Fast
Load, filter, group and reshape data with Pandas. The skill every data professional must have.
Intermediate
#PY03
Automate Excel with Python (openpyxl)
Stop doing repetitive Excel work manually. Use Python to generate, format and populate spreadsheets automatically.
Coming Soon
#PY04
Python for Data Visualisation — Matplotlib & Seaborn
Create stunning charts and insights visualisations from raw data.
MS Excel
3 lessons
Beginner
#XL01
VLOOKUP vs INDEX-MATCH — Which to Use & When
The most important lookup functions in Excel explained clearly, with real examples from finance and HR data.
Intermediate
#XL02
Pivot Tables — Summarise 10,000 Rows in 60 Seconds
Turn raw data into powerful business summaries with Pivot Tables. The skill that will save you hours every week.
Coming Soon
#XL03
Excel Dashboard — Build a KPI Dashboard from Scratch
Charts, slicers, conditional formatting — build a professional dashboard in Excel.
VBA
2 lessons
Beginner
#VB01
Your First VBA Macro — Automate Repetitive Excel Tasks
Record, edit and run your first macro. Automate formatting, copying, and report generation in minutes.
Coming Soon
#VB02
VBA Loops & Conditionals — Process 1000 Rows Automatically
For loops, If-Then logic, and working with ranges to process large datasets.
Machine Learning
2 lessons
Intermediate
#ML01
Your First ML Model — Predict with Scikit-Learn
Train a classification model in under 20 lines of Python. Understand train/test split, accuracy, and predictions.
Coming Soon
#ML02
Fraud Detection — Build a Real Banking ML Model
From raw transaction data to a working fraud detection classifier. Based on real DBS use cases.
MS Word
1 lesson
Beginner
#WD01
Styles & Templates — Write Professional Documents 3x Faster
Use Word Styles, headings, and templates to create consistent, professional documents without reformatting every time.
PowerPoint
1 lesson
Beginner
#PP01
Slide Design Principles — Make Slides That Actually Work
One idea per slide, visual hierarchy, and the 10 rules that separate good decks from great ones.
Generative AI
2 lessons
Beginner
#AI01
Prompt Engineering — Get 10x Better Results from AI
Learn how to write prompts that actually work. Role, context, format, examples — the framework that makes AI useful.
Coming Soon
#AI02
Claude Code for Test Automation — Practical Guide
How I mentor Singapore university graduates to use Claude Code for building knowledge bases and automating tests.