Excel VBA Training

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

Lesson 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

Lesson 3: Referring to Ranges with Excel 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

Lesson 4: User-Defined Functions in Excel VBA

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

Lesson 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

Lesson 6: Event Programming in Excel 

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

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

Lesson 8: Creating Charts with Excel VBA

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

Lesson 9: Data Mining with Advanced Filtering

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

Lesson 10: Using VBA to Create Pivot Tables in Excel 

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

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