Course Detail(IT036Bv : Excel Macros 2: Mastering Excel Objects with VBA for Effective Spreadsheet Automation (Live Webinar))

UTAP Funding

IT036Bv : Excel Macros 2: Mastering Excel Objects with VBA for Effective Spreadsheet Automation (Live Webinar)

7.00 CPE Hours (Others)
Live Webinar

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. 


Notice
 
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 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 Objective
 
This one-day training programme is an intensive macro programming course, designed as a follow-up to course IT036: An Introduction to Excel Macros for Accounting and Finance Professionals. Participants must have basic to intermediate level of Excel experience as a prerequisite. In addition, they must have either attended course IT036 OR have some experience in writing macros to fully benefit from this course. Course participants will learn the crucial aspects of writing macros for dynamic spreadsheet data processing.

Programme Outline

 

  • 3 Components of Macros
    • This 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 VBA
    • This 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 VBA
    • VBA 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 Objects
    • Macros 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 Debugging
    • Code 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.

Pre-requisites

Please take note of the following admission requirements:

  • Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsory
  • Mandatory for video camera to be turned on throughout the course
  • Display your official name (as per NRIC) in Zoom, to facilitate attendance taking

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)
  • 4 Feb & 15 Mar 2021
  • 3 May & 21 Jun 2021
  • 24 Aug & 6 Sep 2021
  • 27 & 28 Dec 2021
Members: $679.45
Non-Members: $815.34
IT036: Excel Macros 1: An Introduction to Excel Macros for Accounting and Finance Professionals
  • 4 Feb 2021
  • 3 May 2021
  • 24 Aug 2021
  • 22 Nov 2021
Members: $348.28
Non-Members: $450.68
IT036B: Excel Macros 2: Mastering Excel Objects with VBA for Effective Spreadsheet Automation
  • 15-Mar-21
  • 21 Jun 2021
  • 6 Sep 2021
Members: $348.28
Non-Members: $450.68

         

 
Training Methodology
 
Lecture style, with hands-on exercises
 
Closing Date for Registration

1 week before programme or until full enrolment

Intended For

Users with Microsoft Excel experience of at least Intermediate Level and are current users of macros or have created macros through recording or simple editing.

Competency Mapping

Others = 7.00 Hours

Schedule & Fees

Date & Time

21 Mar 2022 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 348.28   $ 278.63
For Non-Members: $ 450.68   $ 360.55
Discount till 30 Jun 2022

Programme Facilitator(s)

Zaid Ismail

Venue

Online Classroom in or outside of
Singapore

Date & Time

06 Sep 2021 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Zaid Ismail

Date & Time

21 Jun 2021 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Zaid Ismail

Date & Time

15 Mar 2021 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Zaid Ismail

Testimonial

Funding

1] NTUC Union Training Assistance Programme (UTAP)
UTAP (Union Training Assistance Programme) is an individual skills upgrading account for NTUC members.

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 2022. *This excludes miscellaneous fees such as GST and registration fee etc.
 
This course is approved for UTAP support for intakes conducted between 01 April 2021 – 31 March 2022.
 
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.

To submit for UTAP claims, please visit http://skillsupgrade.ntuc.org.sg/. Terms and conditions apply.
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)


Zaid Ismail

Zaid Ismail has been in the IT and training industry for 20 years. His experience as an IT practitioner encompasses software development, database administration and end-user support. He is also a consultant and developer of IT solutions for SMEs utilising Excel macros and Access databases.

 
A Microsoft Certified Trainer since 1997, Zaid has been conducting Microsoft Office courses and Microsoft Official Curriculum (MOC) systems training in areas of programming, SQL Server database administration and development, and web technologies such as HTML5, CSS3 and JavaScript.

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. 


Notice
 
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 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 Objective
 
This one-day training programme is an intensive macro programming course, designed as a follow-up to course IT036: An Introduction to Excel Macros for Accounting and Finance Professionals. Participants must have basic to intermediate level of Excel experience as a prerequisite. In addition, they must have either attended course IT036 OR have some experience in writing macros to fully benefit from this course. Course participants will learn the crucial aspects of writing macros for dynamic spreadsheet data processing.

Programme Outline

 

  • 3 Components of Macros
    • This 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 VBA
    • This 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 VBA
    • VBA 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 Objects
    • Macros 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 Debugging
    • Code 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.

Pre-requisites

Please take note of the following admission requirements:

  • Trainings will be conducted on Zoom platform, thus video camera and microphone are compulsory
  • Mandatory for video camera to be turned on throughout the course
  • Display your official name (as per NRIC) in Zoom, to facilitate attendance taking

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)
  • 4 Feb & 15 Mar 2021
  • 3 May & 21 Jun 2021
  • 24 Aug & 6 Sep 2021
  • 27 & 28 Dec 2021
Members: $679.45
Non-Members: $815.34
IT036: Excel Macros 1: An Introduction to Excel Macros for Accounting and Finance Professionals
  • 4 Feb 2021
  • 3 May 2021
  • 24 Aug 2021
  • 22 Nov 2021
Members: $348.28
Non-Members: $450.68
IT036B: Excel Macros 2: Mastering Excel Objects with VBA for Effective Spreadsheet Automation
  • 15-Mar-21
  • 21 Jun 2021
  • 6 Sep 2021
Members: $348.28
Non-Members: $450.68

         

 
Training Methodology
 
Lecture style, with hands-on exercises
 
Closing Date for Registration

1 week before programme or until full enrolment

Intended For

Users with Microsoft Excel experience of at least Intermediate Level and are current users of macros or have created macros through recording or simple editing.

Competency Mapping

Others = 7.00 Hours

Programme Facilitator(s)

Zaid Ismail

Zaid Ismail has been in the IT and training industry for 20 years. His experience as an IT practitioner encompasses software development, database administration and end-user support. He is also a consultant and developer of IT solutions for SMEs utilising Excel macros and Access databases.

 
A Microsoft Certified Trainer since 1997, Zaid has been conducting Microsoft Office courses and Microsoft Official Curriculum (MOC) systems training in areas of programming, SQL Server database administration and development, and web technologies such as HTML5, CSS3 and JavaScript.

Upcoming Schedule

Date & Time

21 Mar 2022 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 348.28   $ 278.63
For Non-Members: $ 450.68   $ 360.55
Discount till 30 Jun 2022

Programme Facilitator(s)

Zaid Ismail

Venue

Online Classroom in or outside of
Singapore