About this Course

Learn Excel VBA 2010 easily with our step by step, practical, hands on workshop in Singapore. After attending the VBA Macro Training course using Microsoft Excel 2010, you will be able to:

• Record and Run Macros Easily
  
• Write VBA Code Manually using Microsoft Excel 2010
  
• Perform Loops, Controls and Error Handling in Excel Macros
  
• Create User forms and Sheet Controls in Excel 2010
  
• Use Events to trigger specific VBA code.
  
• Write Useful Applications That Boost Productivity and Reduce Time on Routine Activities.
  

Course Outline:

Lesson 1: Unleash the Power of Excel 2010 with VBA Programming 

Lesson 2: Understanding the basics of Macro Programming

Lesson 3: Referring to Ranges with Excel 2010 VBA

Lesson 4: User-Defined Functions in Excel 2010 VBA

Lesson 5: Looping and Flow Control in Excel VBA

Lesson 6: Event Programming in Excel 2010

Lesson 7: Introduction to USerForms in Excel 2010 VBA

Lesson 8: Creating Charts with Excel 2010 VBA

Lesson 9: Data Mining with Advanced Filtering 

Lesson 10: Using VBA to Create Pivot Tables in Excel 2010

Optional Topics

Lesson 11: Excel Power

• Combining and Separating Workbooks
  
• Separate Worksheets into Workbooks
  
• Combine Workbooks
  
• Filter and Copy Data to Separate Worksheets
  

Lesson 12: Handling Errors

• What Happens When an Error Occurs?
  
• Basic Error Handling with the On Error GoTo Syntax
  
• Generic Error Handlers
  
• Handling Errors by Choosing to Ignore Them
  
• Suppressing Excel Warnings
  

Target Audience

You must be an Experienced Excel user who wish to automate repetitive tasks or simplify more complex tasks using Excel 2010 Macros and Visual Basic for Applications (VBA) programming language.

Prerequisites

You must have good Excel skills and understand key concepts of spreadsheets or equivalent. It is not necessary to have prior programming knowledge. We cover VBA Macro programming concepts from the very basic level.

Excel 2010 VBA Macro Programming: Course Location & Schedule

This course is scheduled to run at our Microsoft Excel 2010 training room at Golden Mile Complex, Beach Road in Singapore. View our Training Calendar for available dates. Register by filling the Course Registration Form at the top right of this page.

Rate this course:

Log in to submit

Comments