Current Promotions

PMP Exam Free Preview Session

May 28, 2013 - Tuesday @6:15pm and

June 11, 2013 - Tuesday @ 6:15 pm

 

 

 
 
 
 

Excel 2007 VBA (Macro)


Excel VBA 2007 Course Duration: This is a 3 full day Excel 2007 VBA Course.

VBA Macro 2007Programming Course is also available for Excel 2010 (VBA Macro).

Call our Corporate Training Hotline at (65) 6296-2995 or email to training@intellisoft.com.sg if you have a group participants interested in learning Microsoft Excel 2007 VBA Macro Programming.

 "VBA training will enable me to automate job functions. There is a good explanation on basics of programming variables, arguments, etc" - Chong Lian Chiu, BNY Mellon.


Course Objectives

After attending the VBA Macro Training course, you will be able to:

  • Record and Run Macros
  • Write VBA Code Manually
  • Perform Loops, Controls and Error Handling
  • Create User forms and Sheet Controls in Excel
  • Use Events to trigger specific VBA code
Target Audience

This course is aimed at experienced Excel users who wish to automate repetitive tasks or simplify more complex tasks using Excel macros and Visual Basic for Applications (VBA) programming language.

Course Outlilne

Lesson 1:

  • Make a Macro do Simple Tasks
  • Difference between VBA & Macro
  • Creating a Simple Macro
  • Changing Multiple Properties at Once
  • Manipulating Recorded Properties
  • Recording Methods in a Macro

Lesson 2:

  • Make a Macro Do Complex Task
  • Opening the Report File
  • Filling in Missing Labels
  • Adding a Column of Dates
  • Appending to the Database
  • Deleting the Worksheet

Lesson 3:

  • Explore Workbooks and Worksheets
  • Understanding Workbooks
  • Understanding Worksheets

Lesson 4:

  • Explore Range Objects

Lesson 5:

  • Explore Data Objects
  • Working with Excel Table
  • Working with Pivot Table Reports

Lesson 6:

  • Explore Graphical Objects
  • Explore Chart Objects

Lesson 7:

  • Control Visual Basic
  • Creating Loops
  • Managing Large Loops

Lesson 8:

  • Extend Excel and Visual Basic
  • Creating Custom Functions
  • Handling Errors

Lesson 9:

  • Launch Macros with Events
  • Creating Custom Command buttons
  • Handling Worksheet and Workbook Events

Lesson 10:

  • Use Dialog Box Controls on a Worksheet
  • Using a loan Payment Calculator
  • Retrieving a Value from a list
  • Protecting the Worksheet

Lesson 11:

  • Create a Custom Form
  • Preparing a form’s functionality

 

 

Prerequisites

You must have good Excel skills and understand key concepts of spreadsheets, or equivalent. It is not necessary to have prior programming knowledge.

Excel VBA Course Location / Schedule

This course is scheduled to run at our  Microsoft Office Excel training center at Beach Road in Singapore. View our Training Calendar for available dates. Register by filling the form at the top right of this page.

How to Register

Register for the 3 Day Excel VBA Macros 2007 today. Simply fill the Course Registration form on the top, and book your seat today. Or send an online enquiry for any questions. You can call us at (65) 6296-2995 or (65) 9066-9991.

To claim SDF Funding of $48 for this training, you must register for the training at the SkillsConnect website. This SDF funding is available to ALL companies registered in Singapore. The funding is not available to individuals - only available if you apply through your company.

Call Kamini at (65) 9066-9991 or email to training@intellisoft.com.sg for any questions, or to register for the upcoming class for Excel VBA 2007 Macro. We have regular public classes each month, and Custom Corporate Trainings can be arranged at your office  too!

 

 

Intellisoft System Facebook Link Intellisoft System Linkedin Link Intellisoft System Youtube Link Intellisoft System Twitter Link Intellisoft System Blog Link

Course Enquiry

Select Your Course *
Course Date*
Sponsored*
Full Name*
Address*
Telephone*
Fax
Email*  
Pass Type
No. of Participants*
Our Clients
Mindef Singapore Ministry of Manpower Nanyang Polytechnic National Heart Center Singapore National University Hospital NUS PSB Academy Richemont Standard Chartered Bank Singapore Polytechnic Singapore Land Authority StatsChipPac ST Electronics The RITZ Carlton At Sunrice AXA BNY Mellon Guthre HDB Johnson Control JTC Marina Bay Sands National Park Paypal Semdcorp Vodaphone Xilinx

 

Testimonial for VBA
Simple, step-by-step instructions that make it easy for me to automate complex tasks - Joyce Lim

I can now use VBA (Macro) to simplify complex job. The training content is proper for person without programming knowledge – Wang Zheng, Bayer

“Very interactive trainer to show real examples & troubleshooting during all hands-on practice session for VBA class – Sherene, Abbott Laboratories

The VBA instructor is very knowledgeable and follows up closely with slow learners. The examples are easy to follow up & understand, concepts are clearly demonstrated & explained – Hui Hong, CTS Singapore Pte Ltd

VBA training will enable me to automate job functions. There is a good explanation on basics of programming variables, arguments, etc. – Chong, BNY Mellon

The topics from the VBA class were very interesting & very useful. The strength of the workshop is the usefulness of the subject & the instructor’s knowledge on the subject and she had no problem communicating with the participants – Marilie Yu, Marina Bay Sands

I especially liked that the training has a book so that I can always go back and refer something better than my notes. This training will help me a lot as about 50% of my job is in excel, some of which is regular reporting. I plan to use the VBA to automate more & improve existing macros – Steve L, IM Flash, Singapore

 

Testimonial for VBA
Simple, step-by-step instructions that make it easy for me to automate complex tasks - Joyce Lim

I can now use VBA (Macro) to simplify complex job. The training content is proper for person without programming knowledge – Wang Zheng, Bayer

“Very interactive trainer to show real examples & troubleshooting during all hands-on practice session for VBA class – Sherene, Abbott Laboratories

The VBA instructor is very knowledgeable and follows up closely with slow learners. The examples are easy to follow up & understand, concepts are clearly demonstrated & explained – Hui Hong, CTS Singapore Pte Ltd

VBA training will enable me to automate job functions. There is a good explanation on basics of programming variables, arguments, etc. – Chong, BNY Mellon

The topics from the VBA class were very interesting & very useful. The strength of the workshop is the usefulness of the subject & the instructor’s knowledge on the subject and she had no problem communicating with the participants – Marilie Yu, Marina Bay Sands

I especially liked that the training has a book so that I can always go back and refer something better than my notes. This training will help me a lot as about 50% of my job is in excel, some of which is regular reporting. I plan to use the VBA to automate more & improve existing macros – Steve L, IM Flash, Singapore