Stay ahead with our interactive training sessions designed for today’s professionals.
From corporate tax and GST to financial reporting and governance, our workshops connect you with leading experts and real-world insights. Learn through practical case studies, peer discussions, and up-to-date regulatory content—crafted to elevate your capabilities.
Tuesday
October 2026
This hands-on course equips finance professionals to modernize corporate budgeting using Excel 365, Power Query, VBA, and Generative AI. Participants learn to automate data preparation, build dynamic budgets and scenarios, and use AI as a coding co-pilot to generate and troubleshoot VBA macros—without prior programming experience. The curriculum covers scenario modeling, sensitivity analysis, capital budgeting (NPV/IRR), and governance controls. Designed for FP&A professionals, accountants, and finance managers, the course shifts focus from repetitive processing to strategic analysis and decision support.
Time: 9:00 AM - 5:00 PM
Hotel: To Be Advised
Fee: $540.00 nett
Thursday
November 2026
The programme combines the productivity benefits of Generative AI with essential VBA knowledge. Participants develop sufficient code literacy to understand how AI-generated macros work, identify incorrect assumptions, apply business rules accurately, and build reliable Excel automation for finance and business workflows. Event Outline 1. Vibe Coding and Generative AI for Excel Automation From syntax-driven programming to intent-driven development; structuring effective VBA prompts; the Describe–Generate–Execute–Observe–Refine workflow; recognising AI assumptions and hallucinations. 2. VBA Foundations Developer Tab and Visual Basic Editor; modules and procedures; variables and data types; "Option Explicit"; user interaction using "MsgBox" and "InputBox"; writing portable VBA. 3. Business Rules and Control Structures Conditional logic with "If...Then...Else"; categorisation using "Select Case"; automating repetitive tasks with "For...Next"; processing variable datasets with "Do While" and "Do Until". 4. Debugging and Refining AI-Generated Code Running macros safely; stepping through code; identifying logical and runtime errors; feeding error messages and observations back to AI for iterative improvement. 5. Excel Object Model and Professional Automation Working with "Application", "Workbook", "Worksheet", "Range" and Excel Tables; properties and methods; understanding "Sub" procedures and custom "Function" procedures. 6. Building Practical Finance and Business Tools Text and date handling; data cleansing; arrays for high-volume processing; opening and consolidating external workbooks and CSV files; automated report preparation. 7. Controls and Defensive Programming Data validation, exception handling and "On Error" techniques; handling missing files and invalid data; reviewing generated code before deployment; maintaining human oversight and auditability. Learning Outcomes By the end of the workshop, participants will be able to: - Apply the 5-step Vibe Coding Loop: Describe, Generate, Execute, Observe and Refine. - Use AI assistants to generate and improve Excel VBA macros from natural-language requirements. - Navigate the VBA Editor and understand variables, data types, procedures, functions and the Excel Object Model. - Apply "If...Then...Else", "Select Case", "For...Next" and "Do...Loop" structures to automate business rules and repetitive processes. - Build interactive macros using "InputBox" and "MsgBox". - Read, test and debug AI-generated VBA rather than accepting generated code without verification. - Automate data cleaning, formatting, reconciliation, reporting and workbook consolidation. - Improve macro performance using arrays and efficient range handling. - Incorporate validation and error handling to create more reliable and auditable automation. - Generate portable VBA solutions suitable for both Windows and Mac environments where practicable. Target Audience Accounting and finance professionals, FP&A analysts, auditors, business analysts and managers who want to automate Excel workflows and develop practical VBA solutions with the assistance of Generative AI. Prerequisites Participants should have a good working knowledge of Microsoft Excel, including formulas, formatting and basic data manipulation. No prior VBA or programming experience is required. Technical Requirements Participants should bring a Windows PC or MacBook with the desktop version of Microsoft Excel 365, access to an AI assistant such as ChatGPT, Claude or Microsoft Copilot. This workshop teaches finance professionals to automate Excel with VBA using Generative AI and "vibe coding"—describing intent in natural language, then reviewing, testing, and refining AI-generated code. It covers VBA foundations, business rules, debugging, the Excel Object Model, and building reliable, auditable finance tools. No programming experience required; participants need Excel 365 desktop and an AI assistant.
Time: 9:00 AM - 5:00 PM
Hotel: To Be Advised
Fee: $540.00 nett
Tuesday
December 2026
This course qualify for UTAP funding UTAP (Union Training Assistance Programme) is an individual skills upgrading account for NTUC members.
Time: 9:00 AM - 5:00 PM
Hotel: To Be Advised
Fee: $540.00 nett
Wednesday
December 2026
This one-day hands-on workshop teaches finance professionals to use Microsoft 365 Copilot for faster analysis, variance explanations, and commentary drafting within Excel, Word, and PowerPoint. Attendees gain practical prompting skills and confidence to reduce manual effort—no AI background or Copilot licence required.
Time: 9:00 AM - 5:00 PM
Hotel: To Be Advised
Fee: $530.00 nett