Excel 2010 VBA (Macro)

 Excel 2010 VBA Macro Programming: Course Objectives

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 speciic VBA code.
• Write Useful Applications That Boost Productivity and Reduce Time on Routine Activities.

3 Day VBA Macro Training (Excel 2010): Detailed Outline

Module 1 Unleash the Power of Excel 2010 with VBA Programming

• The Power of Excel 2010
• Knowing Your Tools: The Developer Tab
• Macro Security
• Adding a Trusted Location
• Overview of Recording, Storing, and Running a Macro
• Understanding the VB Editor

Module 2 Understanding the basics of Macro Programming

• Examining Recorded Macro Code: Using the VB Editor and Help
• Optional Parameters
• Defined Constants
• Properties Can Return Objects
• Using Debugging Tools to Figure Out Recorded Code

Module 3 Referring to Ranges with Excel 2010 VBA

• The Range Object
• Named Ranges
• Use the Cells Property to Select a Range
• Using the Cells Property in the Range Property
• Use the Offset Property to Refer to a Range
• Use the Resize Property to Change the Size of a Range
• Use the CurrentRegion Property to Select a Data Range

Module 4 User-Defined Functions in Excel 2010 VBA

• Creating User-Defined Functions
• Sharing UDFs
• Useful Custom Excel Functions

Module 5 Looping and Flow Control in Excel VBA

• Using Variables in the For Statement
• Variations on the For...Next Loop
• Exiting a Loop Early After a Condition Is Met
• Nesting One Loop Inside Another Loop
• VBA Loop: For Each
• VBA Loop : Do Loops
• Flow Control: Using If...Then...Else
• Flow Control: Using Select Case

Module 6 Event Programming in Excel 2010

• Levels of Events
• Using Events
• Event Parameters
• Enabling Events
• Workbook Events
• Worksheet Events

Module 7  Introduction to USerForms in Excel 2010 VBA

• User Interaction Methods
• Input Boxes
• Message Boxes
• Programming the Userform
• Userform Events
• Programming Controls
• Using Basic Form Controls

Module 8 Creating Charts with Excel 2010 VBA

• Charting in Excel 2010
• Referencing Charts and Chart Objects in VBA Code
• Creating and modifying the Chart.

Module 9 Data Mining with Advanced Filtering

• Replacing a Loop with AutoFilter
• Using New AutoFilter Techniques
• Selecting Visible Cells Only
• Advanced Filter in VBA

Module 10 Using VBA to Create Pivot Tables in Excel 2010

• Introducing Pivot Tables
• Understanding Versions
• Building a Pivot Table in Excel VBA

Optional Topics

• Module 11 Excel Power
• Combining and Separating Workbooks
• Separate Worksheets into Workbooks
• Combine Workbooks
• Filter and Copy Data to Separate Worksheets

Module 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 users who wish to automate repetitive tasks or simplify more complex tasks using Excel 2010 Macros and Visual Basic for Applications (VBA) programming language.

Excel VBA Course Duration: This is a 3 full day Excel 2010 VBA Course. Course starts at 09:00 and runs until 17:00, with a one hour break for lunch, and two short snack breaks.

Miminum Requirements: You must have good Excel skills and understand key concepts of spreadsheets, or equivalent. It is not necessary to have 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. Enquire or Register by filling the Enquiry Form at the top right of this page.

Custom In-House / Corporate Training for VBA Macro Programming
The VBA Macro course can also be run as a Corporate Training, at your office, at your convenience.

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

Call our Corporate Training Hotline at (65) 6296-2995 if you have a group of 5 or more participants  interested in learning Microsoft Excel 2010 VBA Macro Programming.

You can email to training@intellisoft.com.sg for Corporate Training Rates.