For Youth Associate members onlySign up for complimentary ISCA student membership here now to enjoy similar entitlements.NoticeAs 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 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.Programme ObjectiveThis course aims to equip participants with a working knowledge of Excel’s VBA capabilities and its applications. Using VBA as an automation tool, participants would be introduced to the various concepts of programming and appreciate how macros are applied in common spreadsheet data processing scenarios through hands-on demonstrations and coding exercises.The workshop also leverages on learner’s prior knowledge of Excel features by associating VBA code and OOP concepts with those features. Through such associations, the learning curve od VBA is greatly shortened as learners quickly become familiar with the techniques of writing macros and the approach taken when undertaking the automation of repetitive spreadsheet tasks.
For Youth Associate members onlySign up for complimentary ISCA student membership here now to enjoy similar entitlements.
NoticeAs 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 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.
Programme ObjectiveThis course aims to equip participants with a working knowledge of Excel’s VBA capabilities and its applications. Using VBA as an automation tool, participants would be introduced to the various concepts of programming and appreciate how macros are applied in common spreadsheet data processing scenarios through hands-on demonstrations and coding exercises.The workshop also leverages on learner’s prior knowledge of Excel features by associating VBA code and OOP concepts with those features. Through such associations, the learning curve od VBA is greatly shortened as learners quickly become familiar with the techniques of writing macros and the approach taken when undertaking the automation of repetitive spreadsheet tasks.
Components of Macro ProgrammingData Manipulation with Range Object and VBADeveloping Dynamic Macros with VBAManaging Data with Worksheet and Workbook ObjectsCode DebuggingTraining MethodologyCourse would be conducted fully virtually. Curriculum would be taught through interactive e-resources and online lectures, accompanied by hands on demonstrations and exercises for a holistic learning experience. Closing Date for Registration1 week before programme or until full enrolment
Youth Associates and Accountancy undergraduates only
You are about to leave ISCA eServices Portal and the registration link will be opened in a new tab. Do you wish to continue?
This course has been added successfully
Declaration to be provided by CPE
This Course is Intended for CA Singapore Users..
If you have an account with us, please sign-in first. If you do not have an account with us, create one now for free.
Do you wish to apply for SFC funding? (Singapore Citizenship Only)