Course Detail()

https://eservices.isca.org.sg/CourseDetailClone?courseMasterId=a0g2t000000TTCoAAOPlease 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 designed as an introduction to understanding the role of macros in automating tasks within Microsoft Excel.

Programme Outline

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

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

Programme

IT036Cv: Excel Macros 1 & 2: Excel Macros Workshop (Live Webinar)

IT036v: Excel Macros 1: An Introduction to Excel Macros for Accounting and Finance Professionals (Live Webinar)

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

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

Schedule & Fees

Testimonial

Funding

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

To find out more on the UTAP funding and support validity period please click here.

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)