Notice
To reduce the environmental impact and contribute to sustainability efforts, ISCA will contribute our part by eliminating the printing of course materials for selected courses with effect from 2023.
Tips: To make your paperless learning experience more enjoyable, you may bring along a digital device such as a Windows based laptops or tablets to read your online materials during the class. QR code will be provided in the class for you to download the materials in PDF.
Join us and be a Difference Maker! | | 
|
|
Software Installation and Laptop
As this class places strong emphasis on the hands-on experience, you will be working with data for the majority of the time in the class. To optimize the learning experience, it is mandatory for all participants to be equipped with a laptop, pre-installed with Microsoft Excel 2010, 2013, 2016 (full licence) or any latest version.
Programme Objective
There is little dispute that Excel is one of the main tools in the accountants’ toolbox, and yet many are self taught in its features. It is natural for some to feel comfortable with the basics, and to keep away from the more perplexing black art of trying a hand in writing macros. However, one of the more efficient ways to accomplish routine tasks is found to be underutilized by many users is the use of VBA macros in Excel. Many users feel that programming is too complicated, difficult to understand or set-up properly.
This programme includes extensive explanations and examples of how each of these areas could be applied to real-world situations in Management Reporting and typical Accounting/Finance tasks.
Programme Outline
- Introduction to Macros & VBA
- An introduction to all the building blocks required to write macros in Excel’s VBA. Introduction to Programming
- An introduction to programming concepts and writing code.
- Best practices to make your VBA easier to read, quicker to run, and more robust. Controlling Code
- How to make code do what you want it to do.
- How to write code that can be easily modified.
- How to make your macros run as fast as possible. Interacting with Excel
- How to automate common Excel functions such as copy, move, format, print, delete etc.
- Getting responses from users.
- How to read/write data from/to Excel worksheets.
- How to write your own functions and extend the range of functions available in Excel.
- How to link your macros to buttons and other controls. Debugging
- How to use VBA’s tools to quickly find problems and errors then resolve them. Files
- How to create new Excel files within VBA.
- How to open existing Excel files via VBA.
- How to save Excel files using VBA.
- How to work with multiple Excel files and copy or move data between them.
To view our full list of Infocomm courses, please click here.
Closing Date for Registration
1 week before programme or until full enrolment.
Intended For
Analysts, Accountants, and Finance Professionals with significant experience in Excel, who wants to take their skills to a new level by learning how VBA macros can enhance their work and make life easier. This seminar assumes participants have little or no prior programming experience. Users of Excel 2003 or 2010 version are welcomed.
Competency Mapping
Category 5 = 14.00 Hours
Schedule & Fees
Date & Time
06 Mar 2025 (9:00 AM - 5:00 PM)
07 Mar 2025 (9:00 AM - 5:00 PM)
Fee (inclusive of GST)
For Members:
$ 779.35
For Non-Members:
$ 925.41
Programme Facilitator(s)
Dr Lim Thou Tin
Venue
60 Cecil Street
ISCA House
Singapore 049709
Date & Time
07 Jul 2025 (9:00 AM - 5:00 PM)
08 Jul 2025 (9:00 AM - 5:00 PM)
Fee (inclusive of GST)
For Members:
$ 779.35
For Non-Members:
$ 925.41
Programme Facilitator(s)
Dr Lim Thou Tin
Venue
60 Cecil Street
ISCA House
Singapore 049709
Testimonial
Funding
1] NTUC Union Training Assistance Programme (UTAP)
UTAP (Union Training Assistance Programme) is an individual skills upgrading account for NTUC members.
To find out more on the UTAP funding and support validity period please click here.
Should you have queries on the funding scheme, you can email to UTAP@e2i.com.sg or call NTUC Membership Hotline at 6213-8008
Programme Facilitator(s)
Dr Lim Thou Tin, DACE
Dr Lim Thou Tin is a business graduate with the National University of Singapore. He holds double masters in information systems and knowledge management with further postgraduate qualifications in systems analysis, intelligent systems, marketing, management consulting and training. He has a doctor of business administration from Southern Cross University with current research interests in information systems and business modelling.
His work experience includes working in large Singapore companies to MNCs in senior corporate, IT and project management positions. As a management consultant and practitioner, he has facilitated organizational initiatives/projects over a span of more than 15 years in the region, including Australia, Singapore, Malaysia, Mauritius, China, India, Indonesia, and Thailand.
Notice
To reduce the environmental impact and contribute to sustainability efforts, ISCA will contribute our part by eliminating the printing of course materials for selected courses with effect from 2023.
Tips: To make your paperless learning experience more enjoyable, you may bring along a digital device such as a Windows based laptops or tablets to read your online materials during the class. QR code will be provided in the class for you to download the materials in PDF.
Join us and be a Difference Maker! | |
|
|
Software Installation and Laptop
As this class places strong emphasis on the hands-on experience, you will be working with data for the majority of the time in the class. To optimize the learning experience, it is mandatory for all participants to be equipped with a laptop, pre-installed with Microsoft Excel 2010, 2013, 2016 (full licence) or any latest version.
Programme Objective
There is little dispute that Excel is one of the main tools in the accountants’ toolbox, and yet many are self taught in its features. It is natural for some to feel comfortable with the basics, and to keep away from the more perplexing black art of trying a hand in writing macros. However, one of the more efficient ways to accomplish routine tasks is found to be underutilized by many users is the use of VBA macros in Excel. Many users feel that programming is too complicated, difficult to understand or set-up properly.
This programme includes extensive explanations and examples of how each of these areas could be applied to real-world situations in Management Reporting and typical Accounting/Finance tasks.
Programme Outline
- Introduction to Macros & VBA
- An introduction to all the building blocks required to write macros in Excel’s VBA. Introduction to Programming
- An introduction to programming concepts and writing code.
- Best practices to make your VBA easier to read, quicker to run, and more robust. Controlling Code
- How to make code do what you want it to do.
- How to write code that can be easily modified.
- How to make your macros run as fast as possible. Interacting with Excel
- How to automate common Excel functions such as copy, move, format, print, delete etc.
- Getting responses from users.
- How to read/write data from/to Excel worksheets.
- How to write your own functions and extend the range of functions available in Excel.
- How to link your macros to buttons and other controls. Debugging
- How to use VBA’s tools to quickly find problems and errors then resolve them. Files
- How to create new Excel files within VBA.
- How to open existing Excel files via VBA.
- How to save Excel files using VBA.
- How to work with multiple Excel files and copy or move data between them.
To view our full list of Infocomm courses, please click here.
Closing Date for Registration
1 week before programme or until full enrolment.
Intended For
Analysts, Accountants, and Finance Professionals with significant experience in Excel, who wants to take their skills to a new level by learning how VBA macros can enhance their work and make life easier. This seminar assumes participants have little or no prior programming experience. Users of Excel 2003 or 2010 version are welcomed.
Competency Mapping
Category 5 = 14.00 Hours
Programme Facilitator(s)
Dr Lim Thou Tin, DACE
Dr Lim Thou Tin is a business graduate with the National University of Singapore. He holds double masters in information systems and knowledge management with further postgraduate qualifications in systems analysis, intelligent systems, marketing, management consulting and training. He has a doctor of business administration from Southern Cross University with current research interests in information systems and business modelling.
His work experience includes working in large Singapore companies to MNCs in senior corporate, IT and project management positions. As a management consultant and practitioner, he has facilitated organizational initiatives/projects over a span of more than 15 years in the region, including Australia, Singapore, Malaysia, Mauritius, China, India, Indonesia, and Thailand.