Course Detail(IT036C : Excel Macros 1 & 2: Excel Macros Workshop)

SDF Funding, SkillsFuture Credit

IT036C : Excel Macros 1 & 2: Excel Macros Workshop

14.00 CPE Hours (Others)
Classroom


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 Outline


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 Macros
    • The History of Visual Basic for Applications (VBA)
    • An Orientation of the Visual Basic Integrated Development Environment
    • Saving Workbooks Containing Macros
  • Recording Macros
    • Understanding the purpose of recording Macros
    • Preparation before Recording a Macro
  • Basic Object-oriented Concepts in Macro programming
    • Properties and Methods
    • The Core of Macros
    • Excel Object Model and Collections
    • Range Exercises:
      A Demonstration on Using Objects for Data Manipulation
  • Using Functions in Macros
    • Functions in Excel 
    • VBA Intrinsic Functions 
    • Built-in Excel Functions
    • Creating User-defined Function with VBA 
    • Characteristics of Functions
  • Hands-on Demonstration and Exercise
    • Application in real life scenarios
    • Applying Macros to common scenarios
    • Adding code to partially-completed Macros

 
Day 2:
 

  • 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’

Competency Mapping

Others = 14.00 Hours

Schedule & Fees

Date & Time

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

Fee (inclusive of GST)

For Members: $ 679.45
For Non-Members: $ 815.34

Programme Facilitator(s)

Zaid Ismail

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

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

Fee (inclusive of GST)

For Members: $ 679.45
For Non-Members: $ 815.34

Programme Facilitator(s)

Zaid Ismail

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

28 Dec 2020 (9:00 AM - 5:00 PM)
29 Dec 2020 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 679.45
For Non-Members: $ 815.34

Programme Facilitator(s)

Zaid Ismail

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

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

Registration is closed

Programme Facilitator(s)

Zaid Ismail

Date & Time

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

Registration is closed

Programme Facilitator(s)

Zaid Ismail

Date & Time

12 Sep 2018 (9:00 AM - 5:00 PM)
04 Oct 2018 (9:00 AM - 5:00 PM)

Registration is closed

Programme Facilitator(s)

Zaid Ismail

Testimonial

Funding

1] SkillsFuture Credit (SFC)
Funding Period: Until 26 Jun 2020
Course Ref No.: CRS-N-0050046

All Singaporeans aged 25 and above will receive an opening credit of S$500 from the government. The credits will not expire and periodic top-ups will be provided by the government. SFC may be accumulated to pay for skills related course fees. You may wish to use your SFC to pay for partial/full ISCA course fees.  (For more information on the SFC scheme, please visit http://www.skillsfuture.sg/credit)

If you wish to enrol for the course with SFC Funding, please proceed with the following steps:

  • Step 1: Register for the course online via ISCA Portal. Upon adding to cart, the system will prompt a question “Do you wish to apply for SkillsFuture Credit?”, click “Yes” and input all required information. At the Cart page, please ensure that SFC funding is applied before clicking “Checkout”.
  • Step 2: After successful enrolment, please proceed to submit SFC claim on Skillsfuture Portal within 60 days before the course start date and obtain the necessary approval. Please submit SFC claim via SFC portal here: http://www.skillsfuture.sg/credit.

Failure to submit claim application and obtain necessary approval before the course start date will result in topping up of the SFC indicated for use. Please note that there will be an administrative fee of $42.80 for any revision of invoice.


2] WDA Training Grant - SDF Funding
This course is approved for SDF funding ($2 per training hour) for Company-sponsored participants only (Eligibility criteria apply). 

Funding Period: Until 26 Jun 2020
Funded Hours: 14 hours
Course Ref No.: CRS-N-0050046

If you wish to enrol participants with SDF Funding, please proceed with the following steps (For Corporate enrolments only) :

  • Step 1: Register for the course online via ISCA Portal. Upon adding to cart, the system will prompt a question “Do you wish to apply for WDA Funding?”, click Yes and input all required information. At the Cart page, please ensure that SDF funding is applied before clicking “Checkout”.
     
  • Step 2: After successful enrolment, please proceed to submit the Training Grant application via SkillsConnect Portal here: https://www.skillsconnect.gov.sg/

 

Employers of company-sponsored participants must submit training grant via SkillsConnect system to obtain training grant for course fees. You may submit the Training Grant application within the period from 30 days before the course start date to 30 days after course start date. Please note that there will be an administrative fee of $42.80 for any revision of invoice.

 

Eligibility Criteria:

  • Company must be registered or incorporated in Singapore and;
  • Applicant is taking the course for the first time.
  • Applicant must be employed, and is either Singapore Citizen or Permanent Resident of Singapore and;
  • Applicant must achieve at least 75% attendance, and pass all examinations /assessments and;
  • Applicant must be fully sponsored by the Company for all costs associated with the training and;
  • Payment has to be made via corporate means (e.g. corporate cheque, corporate GIRO, corporate credit card).

 

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.


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 Outline


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 Macros
    • The History of Visual Basic for Applications (VBA)
    • An Orientation of the Visual Basic Integrated Development Environment
    • Saving Workbooks Containing Macros
  • Recording Macros
    • Understanding the purpose of recording Macros
    • Preparation before Recording a Macro
  • Basic Object-oriented Concepts in Macro programming
    • Properties and Methods
    • The Core of Macros
    • Excel Object Model and Collections
    • Range Exercises:
      A Demonstration on Using Objects for Data Manipulation
  • Using Functions in Macros
    • Functions in Excel 
    • VBA Intrinsic Functions 
    • Built-in Excel Functions
    • Creating User-defined Function with VBA 
    • Characteristics of Functions
  • Hands-on Demonstration and Exercise
    • Application in real life scenarios
    • Applying Macros to common scenarios
    • Adding code to partially-completed Macros

 
Day 2:
 

  • 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’

Competency Mapping

Others = 14.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

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

Fee (inclusive of GST)

For Members: $ 679.45
For Non-Members: $ 815.34

Programme Facilitator(s)

Zaid Ismail

Venue

60 Cecil Street
ISCA House
Singapore 049709