Dear Students,
To kick off the year, NBS Business Analytics Club (BAC) is excited to announce the return of our annual Excel VBA Workshop! This course is designed to equip participants with practical data analytics and programming skills using Excel VBA, which is value-adding both academically and professionally.
It will be a 7-day course, held from 19 January 2026 to 9 February 2026, physically only at NBS's Financial Trading Room, S4 - B1B - 14/16. Do take note that the 5th February, Thursday lesson will be held in Financial Trading Room 2, S4 - B1C - 35/36.
Each lesson has a fee of $5. Participants are to pay according to the number of lessons they sign up for. (E.g: If they sign up for 3 lessons, the total amount to be paid is $ 15.) Please take not that we are only left with one last slot of 6 lessons for $30!
We are pleased to have Mr Koh Choon Chye as the instructor for this course. He has been a lecturer with NBS for over a decade while conducting programming courses part-time. He has taught subjects such as computational mathematics, data structures and databases. With his rich experience, he will be able to equip the participants with the knowledge and applications of Excel VBA.
Lesson 1: Excel Advanced Functions and Features - 19 Jan 2026, Monday, 6.45 pm - 9.45 pm
- Excel Features
- Visual Basic For Application: Excel
- Programming Techniques
- Data Analytics
Lesson 2: Decision Controls with Looping Techniques in VBA For Excel - 22 Jan 2026, Thursday, 6.45pm - 9.45pm
- Variables
- Looping (for, while)
- Arithmetic Operators and Precedence
- Relational Operators
- Logical Operators
- Simple Data Validation
- Simulations
Lesson 3: Structured Programming - 26 Jan 2026, Monday, 6.45 pm - 9.45 pm
- Handling Sheets in Excel
- Modularization
- Procedures vs functions
Lesson 4: Automation with Macro - 29 Jan 2026, Thursday, 6.45 pm - 9.45 pm
- How to record a Macro
- How to 'study' a Macro
- Record and run macros easily
- Convert Macro to structured programming tool
Lesson 5: Data Preparation - 2 Feb 2026, Monday, 6.45 pm - 9.45 pm
- Excel Tables
- User Form for Data Capture (Mac Users are unable to use this)
- Form Controls for Data Manipulations
Lesson 6: Data Transformation with Excel and Power Query - 5 Feb 2026, Thursday, 6.45 pm - 9.45 pm
- Handling files and folders
- Import data from Web Site
- Traditional Web Scraping
Lesson 7: Data Visualisation With Excel and PowerBI - 9 Feb 2026, Monday, 6.45 pm - 9.45 pm
- Pivot Table
- Pivot Chart
- Extended Tool: PowerBI
Upon completion of this workshop *, you will receive a certificate of completion. As for our newly implemented BAC Membership System, every participant will be awarded 2 BAC points for each physical lesson attended!
* Requirements for completion:
- Physically attend 5 out of 7 workshop sessions
- Complete and submit assignments 1 and 2
Registrations will close 2 days before each lesson by 11.59 pm, so hurry while registrations are open!
Please note that attendance will be taken during the session, and absent students might be barred from future activities by BAC. For any inquiries, please feel free to email us at abc-bac-events@e.ntu.edu.sg