Excel 2007 VBA (Macro)

Automate Excel With VBA

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

VBA Macro Programming Course is also available for Excel 2010 (VBA Macro) and Excel 2013 (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.

We also have

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

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.

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

 

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.

Automate Routine Tasks With Excel Macros
Write Pratical, Step-by-Step &
Blazing Fast Code!
Request For a Course Brochure
Training For Your Entire Department?
We offer Customized Solutions For Training at Your Office or Our Training Centre
Get Corporate Training Quote
3 Day Hands-on Workshop
Learn To Code in Excel With VBA Macros.

Follow Step-by-Step Instructions & Automate Your Work!
Join the Next VBA Programming Training

How To Register

Register for the 3 Day Excel VBA Macros 2007 today. Simply Register Online, and book your seat today. Or send an online enquiry if you have any questions. You can call us at +65 6296-2995.

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 us at +65 6296-2995 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!

SkillsFuture Ready

Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.

Contact us for advise on how to go about claiming your SkillsFuture.

Get Started Today!

Learn By Doing

You learn best when you Do It Yourself.

We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!

Microsoft Training at Intellisoft

Claim SDF Grant

Companies sponsoring their staff for training can claim from the Skills Development Fund.

Some of the companies that experienced our trainings

"What I love about this training is that the trainers make sure we learn the steps and are able to do it on our own. This is a real advantage and I will definitely come back for more practical training"
Joy Tan
HR Manager
“The training was everything I hoped for, and more. Intellisoft Systems really makes a difference, I would have never discovered the hidden features of the sotftware on my own. Thanks a lot Intellisoft !"
Michele Martin
Project Engineer

Accelerate your Career With the Most Effective Training!

Free Tips, Tutorials & Training Grants Info

Learn from expert tips, tricks and resources for Excel, PowerPoint, Photoshop, Project Management, IT, Soft Skills & more with our Email Newsletter.
Plus get the latest news on Grants. Join Today!