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 encouraged for all participants to be equipped with a laptop, pre-installed with either Microsoft Excel 2010, 2013, 2016 (full licence) or any latest version. If you have a Microsoft Office 365 subscription, you will need to have a locally installed Excel 365 application in your PC or laptop. Macros cannot be executed when the workbook containing them is opened in Excel online. Also, kindly note that Mac Excel version has limited Excel functionality.
This is a refreshed course and was previously titled "Excel Macros 1 & 2: Excel Macros Workshop"
Programme Objective
This two-day workshop is designed to equip the participants with the skills and knowledge of developing macros using the Visual Basic for Applications (VBA) programming language for automating repetitive spreadsheet tasks. By leveraging their knowledge of Microsoft Excel, participants will learn the fundamentals and implementation of object-oriented programming in manipulating Excel Objects with VBA as the basis of automation on the first day. Eventually they will proceed to go deeper into VBA programming to develop more sophisticated macros that will be able to perform dynamic and more efficient data manipulation and processing on the second day. No prior programming experience is needed but a working knowledge of Excel in aspects such as data entry in worksheets, using simple formula and functions, cells formatting and navigating between worksheets and workbooks, is essential.
Programme Outline
Day 1:
• Introduction to Excel Macros
• Recording Macros
• Basic Object-oriented Concepts in Macro Programming
• Data Manipulation with Range Object and VBA
• Demonstration of macro application to common use cases with hands-on exercises
Day 2:
• Developing Dynamic Macros with VBA
• Using Functions in Macros
• Decision structures and Looping
• Managing Data Workbook Objects
• Code Debugging
On the completion of this course, you will be able to:
• Record macros for simple and linear repetitive tasks
• Understand and apply basic object-oriented concept in programming macros for task automation in common use cases
• Use VBA language elements to enable dynamic and intelligent data processing in macros through the use of functions, decision structures and looping statements
• Manage data extraction from external workbooks and Excel supported files dynamically
• Debug or troubleshoot, and resolve errors in code statements using built-in debugging tools in the Visual Basic editor
Training Methodology
Lecture style, with hands-on exercises
Closing Date for Registration
1 week before programme or until full enrolment
Intended For
Accounting and finance professionals who are looking to upgrade their spreadsheet knowledge to the next level by automating common repetitive tasks. Those who are already recording or writing simple macros, and are looking to go in-depth with VBA programming to develop more flexible and dynamic macros, may also benefit from this workshop.’
Schedule & Fees
Testimonial
Funding
1] NTUC Union Training Assistance Programme (UTAP)
NTUC members enjoy 50% *unfunded course fee support for up to $250 each year when you sign up for courses supported under UTAP. NTUC members aged 40 and above can enjoy higher funding support up to $500 per individual each year, capped at 50% of unfunded course fees, for courses attended between 1 July 2020 to 31 December 2025.
*Unfunded course fee refers to the balance course fee payable after applicable government subsidies. This excludes material fees, registration fees, misc. fees etc.
This course is approved for UTAP support for intakes conducted between 11 May 2024 – 31 March 2025.
As UTAP is given on calendar year basis, and calculated based on year of training taken, it cannot be accumulated.
- Maintained paid-up NTUC membership before course, throughout course duration and at the point of claim and;
- Course by training provider must be supported under UTAP and training must commence within the supported period and;
- Unfunded course fee must not be fully sponsored by company or other types of funding
- Unfunded course fee must be S$20.00 and above, and;
- Member must achieve a minimum of 75% attendance for each application and sat for all prescribed examination(s), if any and;
- UTAP application must be made within 6 months after course ends.
For more information on UTAP Funding and to submit for UTAP claims, please visit https://www.ntuc.org.sg/uportal/programmes/union-training-assistance-programme. Terms and conditions apply.
Programme Facilitator(s)
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 encouraged for all participants to be equipped with a laptop, pre-installed with either Microsoft Excel 2010, 2013, 2016 (full licence) or any latest version. If you have a Microsoft Office 365 subscription, you will need to have a locally installed Excel 365 application in your PC or laptop. Macros cannot be executed when the workbook containing them is opened in Excel online. Also, kindly note that Mac Excel version has limited Excel functionality.
This is a refreshed course and was previously titled "Excel Macros 1 & 2: Excel Macros Workshop"
Programme Objective
This two-day workshop is designed to equip the participants with the skills and knowledge of developing macros using the Visual Basic for Applications (VBA) programming language for automating repetitive spreadsheet tasks. By leveraging their knowledge of Microsoft Excel, participants will learn the fundamentals and implementation of object-oriented programming in manipulating Excel Objects with VBA as the basis of automation on the first day. Eventually they will proceed to go deeper into VBA programming to develop more sophisticated macros that will be able to perform dynamic and more efficient data manipulation and processing on the second day. No prior programming experience is needed but a working knowledge of Excel in aspects such as data entry in worksheets, using simple formula and functions, cells formatting and navigating between worksheets and workbooks, is essential.
Programme Outline
Day 1:
• Introduction to Excel Macros
• Recording Macros
• Basic Object-oriented Concepts in Macro Programming
• Data Manipulation with Range Object and VBA
• Demonstration of macro application to common use cases with hands-on exercises
Day 2:
• Developing Dynamic Macros with VBA
• Using Functions in Macros
• Decision structures and Looping
• Managing Data Workbook Objects
• Code Debugging
On the completion of this course, you will be able to:
• Record macros for simple and linear repetitive tasks
• Understand and apply basic object-oriented concept in programming macros for task automation in common use cases
• Use VBA language elements to enable dynamic and intelligent data processing in macros through the use of functions, decision structures and looping statements
• Manage data extraction from external workbooks and Excel supported files dynamically
• Debug or troubleshoot, and resolve errors in code statements using built-in debugging tools in the Visual Basic editor
Training Methodology
Lecture style, with hands-on exercises
Closing Date for Registration
1 week before programme or until full enrolment
Intended For
Accounting and finance professionals who are looking to upgrade their spreadsheet knowledge to the next level by automating common repetitive tasks. Those who are already recording or writing simple macros, and are looking to go in-depth with VBA programming to develop more flexible and dynamic macros, may also benefit from this workshop.’
Programme Facilitator(s)