This training contains the essential of VBA knowledge.  It prepares the user to explore more advanced techniques in VBA. There will be several exercises to apply the new skills learned every chapter.

Participants will be able to automate reports to improve efficiency, lessen errors, and lessen the impact to productivity when a skilled person resigns.

Part 1.  Macro Recording

• Creating Macros
• Exploring Macro Security
• Recording and Running a Macro
• Using Relative Reference
• Assigning a Macro to Buttons
• Using Macro Recording to Create VBA Codes

Part 2.  Introduction to VBA 

• Exploring the VBA Interface (Overview)
• VBA Terminologies
• Exploring the Properties Window
• Exploring the Code Window

Part 3.  Programming Basics

• Essential VBA Codes
• Different Ways of Calling Cells
• Creating Basic Modules
• Objects, Properties, and Actions
• Dealing with Rows, Columns, and Sheets

Part 4.  Control Structures

• Applying Decision Structures
  • If, Then, Else Statement
  • If, Then, ElseIf Statement
• Solving Repetitive Tasks with Loop Structures
  • For, Next Loop
  • For Each, Next Loop
  • Do Until, Loop
• Applying Control Structures in Excel Programs

Part 5.  Creating Your Own Functions 

• Using IF to Create Functions
• User-Defined Functions
• Using MS Excel Functions in VBA

Part 6.  Creating Userforms and Userform Events

• Adding UserForms
• Adding Form Elements

Part 7.  Error Handling

Part 8.  Creative Automation Exercises in VBA

Public Schedule