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

UTAP Funding

IT036B : Excel Macros 2: Mastering Excel Objects with VBA for Effective Spreadsheet Automation

7.00 CPE Hours (Others)
Classroom


Notice
 
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
 
You may opt to bring along your laptop if you wish to use Excel 2013.

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.

 

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 2020
Members: $679.45
Non-Members: $815.34
IT036: Excel Macros 1: An Introduction to Excel Macros for Accounting and Finance Professionals
  • 20 Jan 2020   
  • 26 Mar 2020   
  • 02 Jul 2020    
  • 21 Sep 2020
Members: $348.28
Non-Members: $450.68
IT036B: Excel Macros 2: Mastering Excel Objects with VBA for Effective Spreadsheet Automation
  • 30 Jul 2020             
  • 12 Oct 2020
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

30 Jul 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 348.28
For Non-Members: $ 450.68

Programme Facilitator(s)

Zaid Ismail

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

12 Oct 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 348.28
For Non-Members: $ 450.68

Programme Facilitator(s)

Zaid Ismail

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

10 Oct 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Zaid Ismail

Date & Time

25 Jun 2019 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Zaid Ismail

Date & Time

04 Oct 2018 (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 member gets to enjoy UTAP funding 50% of the unfunded course fee capped at $250 every year. This excludes miscellaneous fees such as GST and registration fee etc.
 
This course is approved for UTAP support for intakes conducted between 01 April 2019 – 31 March 2020.
 
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.


Notice
 
Our Computer Lab is equipped with Microsoft Excel 2016 & 2010. Due to compatibility issue, Excel 2013 will not be provided.
 
You may opt to bring along your laptop if you wish to use Excel 2013.

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.

 

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 2020
Members: $679.45
Non-Members: $815.34
IT036: Excel Macros 1: An Introduction to Excel Macros for Accounting and Finance Professionals
  • 20 Jan 2020   
  • 26 Mar 2020   
  • 02 Jul 2020    
  • 21 Sep 2020
Members: $348.28
Non-Members: $450.68
IT036B: Excel Macros 2: Mastering Excel Objects with VBA for Effective Spreadsheet Automation
  • 30 Jul 2020             
  • 12 Oct 2020
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

30 Jul 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 348.28
For Non-Members: $ 450.68

Programme Facilitator(s)

Zaid Ismail

Venue

60 Cecil Street
ISCA House
Singapore 049709