Please be informed that in view of the current COVID-19 situation, we will be changing the format of this course into a Live Webinar. A detailed set of instructions on the Live Webinar will also be sent to you closer to date. Please sign up for a Zoom account (https://zoom.us/) if you currently do not have an account. Programme Objective This two-day training programme is an intensive macro programming course, covering introduction to advanced Excel Macro. Participants must have basic to intermediate level of Excel experience as a prerequisite. Course participants will learn the crucial aspects of writing macros for dynamic spreadsheet data processing.
Programme Objective This two-day training programme is an intensive macro programming course, covering introduction to advanced Excel Macro. Participants must have basic to intermediate level of Excel experience as a prerequisite. Course participants will learn the crucial aspects of writing macros for dynamic spreadsheet data processing.
Day 1: This one-day training programme is designed as an introduction to understanding the role of macros in automating tasks within Microsoft Excel. Introduction to Excel MacrosThe History of Visual Basic for Applications (VBA)An Orientation of the Visual Basic Integrated Development EnvironmentSaving Workbooks Containing MacrosRecording MacrosUnderstanding the purpose of recording MacrosPreparation before Recording a MacroBasic Object-oriented Concepts in Macro programmingProperties and MethodsThe Core of MacrosExcel Object Model and CollectionsRange Exercises: A Demonstration on Using Objects for Data ManipulationUsing Functions in MacrosFunctions in Excel VBA Intrinsic Functions Built-in Excel FunctionsCreating User-defined Function with VBA Characteristics of FunctionsHands-on Demonstration and ExerciseApplication in real life scenariosApplying Macros to common scenariosAdding code to partially-completed Macros Day 2: 3 Components of MacrosThis introductory chapter elaborates the role played by the 3 components of macro: knowledge of Excel features, Objects and VBA.Data Manipulation with Range Object and VBAThis chapter explores selected methods and properties of the Range object that can be used for spreadsheet data manipulation without having to code entirely from scratch.Developing Dynamic Macros with VBAVBA transforms a macro into a dynamic piece of code through the use of variables, functions, control-of-flow statements. This chapter provides scenarios on the use of VBA constructs for data manipulation.Managing Data with Worksheet and Workbook ObjectsMacros are more often used to extract data from or copy to different worksheets and workbooks. To make it more complicated, data may come from various sources and format like CSV, XML or even databases. This chapter provides several scenarios of writing macros to deal with diverse sources of data.Code DebuggingCode debugging is an essential part of any programming task. This chapter explores and demonstrates the use of several debugging tools available within the Visual Basic integrated development environment to fix errors.To view our full list of Infocomm courses, please click here. ProgrammeDateCourse Fees (With GST)IT036C: Excel Macros 1 & 2: Excel Macros Workshop Cost Saving$17.11(members)$86.02 (non members)2 & 30 Jul 2020 21 Sep & 12 Oct 2020 28 & 29 Dec 2020Members: $679.45 Non-Members: $815.34IT036: Excel Macros 1: An Introduction to Excel Macros for Accounting and Finance Professionals20 Jan 2020 26 Mar 2020 02 Jul 2020 21 Sep 2020Members: $348.28Non-Members: $450.68IT036B: Excel Macros 2: Mastering Excel Objects with VBA for Effective Spreadsheet Automation30 Jul 2020 12 Oct 2020Members: $348.28Non-Members: $450.68 Training Methodology Lecture style, with hands-on exercises Closing Date for Registration1 week before programme or until full enrolment
Day 1: This one-day training programme is designed as an introduction to understanding the role of macros in automating tasks within Microsoft Excel.
Day 2:
To view our full list of Infocomm courses, please click here.
Training Methodology Lecture style, with hands-on exercises Closing Date for Registration1 week before programme or until full enrolment
Users with Microsoft Excel experience of at least Intermediate Level’
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)