About this Course

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
  

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
  

• Explore Range Objects
  

Lesson 5:

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

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.

Rate this course:

Log in to submit

Comments