Course Detail(IT030C : Excel Macro Fundamentals (Classroom))

SDF Funding, SkillsFuture Credit, UTAP Funding

IT030C : Excel Macro Fundamentals (Classroom)

14.00 CPE Hours (Category 5)
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

There is little dispute that Excel is one of the main tools in the accountants’ toolbox, and yet many are self taught in its features. It is natural for some to feel comfortable with the basics, and to keep away from the more perplexing black art of trying a hand in writing macros. However, one of the more efficient ways to accomplish routine tasks is found to be underutilized by many users is the use of VBA macros in Excel. Many users feel that programming is too complicated, difficult to understand or set-up properly.

This programme includes extensive explanations and examples of how each of these areas could be applied to real-world situations in Management Reporting and typical Accounting/Finance tasks.
 

Programme Outline

 

  • Introduction to Macros & VBA
  • An introduction to all the building blocks required to write macros in Excel’s VBA. Introduction to Programming
  • An introduction to programming concepts and writing code.
  • Best practices to make your VBA easier to read, quicker to run, and more robust. Controlling Code
  • How to make code do what you want it to do.
  • How to write code that can be easily modified. 
  • How to make your macros run as fast as possible. Interacting with Excel
  • How to automate common Excel functions such as copy, move, format, print, delete etc.
  • Getting responses from users.
  • How to read/write data from/to Excel worksheets.
  • How to write your own functions and extend the range of functions available in Excel.
  • How to link your macros to buttons and other controls. Debugging
  • How to use VBA’s tools to quickly find problems and errors then resolve them. Files
  • How to create new Excel files within VBA.
  • How to open existing Excel files via VBA.
  • How to save Excel files using VBA.
  • How to work with multiple Excel files and copy or move data between them.


To view our full list of Infocomm courses, please click here.

Closing Date for Registration

1 week before programme or until full enrolment.

Intended For

Analysts, Accountants, and Finance Professionals with significant experience in Excel, who wants to take their skills to a new level by learning how VBA macros can enhance their work and make life easier. This seminar assumes participants have little or no prior programming experience. Users of Excel 2003 or 2010 version are welcomed.

Competency Mapping

Category 5 = 14.00 Hours

Schedule & Fees

Date & Time

11 Aug 2022 (9:00 AM - 5:00 PM)
12 Aug 2022 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 647.35
For Non-Members: $ 770.40

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Date & Time

10 Nov 2022 (9:00 AM - 5:00 PM)
11 Nov 2022 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 647.35
For Non-Members: $ 770.40

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709

Testimonial

Funding

1] SkillsFuture Credit (SFC)
Funding Period: Until 14 Jul 2023
Course Reference Number: TGS-2020500275

All Singaporeans aged 25 and above will receive an opening credit of S$500 from the government. You may wish to use your SFC to pay for partial/full ISCA course fees. 

On 1 Oct 2020, the Government provided a one-off SkillsFuture Credit Top-up of $500 for all eligible Singaporeans aged 25 or above by 31 Dec 2020. Singaporeans aged 40 to 60 by 31 Dec 2020 will also receive an Additional SkillsFuture Credit (Mid-Career Support) of $500 which can be used for courses under: (i) SGUnited Skills Programme, (ii) SGUnited Mid-Career Pathways Programme – Company Training, and (iii) Career Transition Programmes. This additional SFC (Mid-Career Support) is NOT applicable for use on ISCA courses. (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:

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 14 Jul 2023
Funded Hours: 14 hours
Course Reference Number: TGS-2020500275

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”.
     

 

For course run start date before 1 Nov 2020, submit training grant application in SCN until 30 Nov 2020.

For course run start date on or after 1 Nov 2020, Enterprises/employers are NOT required to log into TPGateway/SCN to submit training grant.

Remarks

Step 2: After receiving email that the programme status is confirmed, please proceed to submit the Training Grant application via SkillsConnect Portal (https://www.skillsconnect.gov.sg/).

Employers of company-sponsored participants must submit training grant via SkillsConnect 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.

The employee’s enrolment, attendance and assessment recordswill be submitted by ISCA onto TPGateway.


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).

3] 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.
 

To find out more on the UTAP support validity period please click here.
 
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)


Dr Lim Thou Tin, DACE
 
Dr Lim Thou Tin is a business graduate with the National University of Singapore. He holds double masters in information systems and knowledge management with further postgraduate qualifications in systems analysis, intelligent systems, marketing, management consulting and training. He has a doctor of business administration from Southern Cross University with current research interests in information systems and business modelling.

His work experience includes working in large Singapore companies to MNCs in senior corporate, IT and project management positions. As a management consultant and practitioner, he has facilitated organizational initiatives/projects over a span of more than 15 years in the region, including Australia, Singapore, Malaysia, Mauritius, China, India, Indonesia, and Thailand.

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

There is little dispute that Excel is one of the main tools in the accountants’ toolbox, and yet many are self taught in its features. It is natural for some to feel comfortable with the basics, and to keep away from the more perplexing black art of trying a hand in writing macros. However, one of the more efficient ways to accomplish routine tasks is found to be underutilized by many users is the use of VBA macros in Excel. Many users feel that programming is too complicated, difficult to understand or set-up properly.

This programme includes extensive explanations and examples of how each of these areas could be applied to real-world situations in Management Reporting and typical Accounting/Finance tasks.
 

Programme Outline

 

  • Introduction to Macros & VBA
  • An introduction to all the building blocks required to write macros in Excel’s VBA. Introduction to Programming
  • An introduction to programming concepts and writing code.
  • Best practices to make your VBA easier to read, quicker to run, and more robust. Controlling Code
  • How to make code do what you want it to do.
  • How to write code that can be easily modified. 
  • How to make your macros run as fast as possible. Interacting with Excel
  • How to automate common Excel functions such as copy, move, format, print, delete etc.
  • Getting responses from users.
  • How to read/write data from/to Excel worksheets.
  • How to write your own functions and extend the range of functions available in Excel.
  • How to link your macros to buttons and other controls. Debugging
  • How to use VBA’s tools to quickly find problems and errors then resolve them. Files
  • How to create new Excel files within VBA.
  • How to open existing Excel files via VBA.
  • How to save Excel files using VBA.
  • How to work with multiple Excel files and copy or move data between them.


To view our full list of Infocomm courses, please click here.

Closing Date for Registration

1 week before programme or until full enrolment.

Intended For

Analysts, Accountants, and Finance Professionals with significant experience in Excel, who wants to take their skills to a new level by learning how VBA macros can enhance their work and make life easier. This seminar assumes participants have little or no prior programming experience. Users of Excel 2003 or 2010 version are welcomed.

Competency Mapping

Category 5 = 14.00 Hours

Programme Facilitator(s)

Dr Lim Thou Tin, DACE
 
Dr Lim Thou Tin is a business graduate with the National University of Singapore. He holds double masters in information systems and knowledge management with further postgraduate qualifications in systems analysis, intelligent systems, marketing, management consulting and training. He has a doctor of business administration from Southern Cross University with current research interests in information systems and business modelling.

His work experience includes working in large Singapore companies to MNCs in senior corporate, IT and project management positions. As a management consultant and practitioner, he has facilitated organizational initiatives/projects over a span of more than 15 years in the region, including Australia, Singapore, Malaysia, Mauritius, China, India, Indonesia, and Thailand.


Upcoming Schedule

Date & Time

11 Aug 2022 (9:00 AM - 5:00 PM)
12 Aug 2022 (9:00 AM - 5:00 PM)

Fee (inclusive of GST)

For Members: $ 647.35
For Non-Members: $ 770.40

Programme Facilitator(s)

Dr Lim Thou Tin

Venue

60 Cecil Street
ISCA House
Singapore 049709