Corporate Training By Zack Academy - Excel Power Programming with VBA Phase I

Why Should You Take This Excel Power Programming with VBA Phase 1 Course?

The Excel Power Programming with VBA Phase 1 class concentrates on how to practically automate repetitious Excel tasks and reports. By the end of the Excel training course, you will feel confident in writing macros to automate your Excel tasks, even if the data is not consistently formatted, creating custom Excel applications and environments, and creating custom Excel Add-ins to increase the functionality of the program. This Excel class is perfect for those consistently working with Excel and will need to automate repetitious tasks.

The Following Topics Will Be Covered:

Macros:

• What are macros
• How to record macros
• How to run macros
• How Macros are related to VBA

VBA Editor:

• What is VBA
• How to edit VBA Code
• What is a “sub” routine
• What is Project Explorer
• How to turn on Project Explorer
• Excel Objects and Modules
• What are Excel Objects
• What are Modules
• Making a sheet hidden

Properties:

• What are Properties and their purpose
• Renaming Modules
• Renaming Sheets

Watch Window:

• What is a watch window and how to use it

Comments:

• What are comments
• How are comments marked
• The importance of comments

Debugger:

• What is the debugger
• How is it used
• Step into
• Step over
• Step Out
• Play
• Breakpoint
• Reset
• Monitoring values

Declaring Variables:

• What are Variables
• How to declare variables
• Using “Option Explicit”
• Declaring multiple variables
• Requiring variable declaration
• Types of Variables
• String
• Integer
• Single
• Double
• Boolean
• Date
• Time
• Variant
• Why to avoid variant declaration
• When to use variant

Referencing and Manipulating:
     Cells

• Selecting a specific cell
• Selecting the active cell
• Setting the value of a cell
• Deleting cell contents

     Rows

• Selecting a specific row
• Selecting the active row
• Selecting the last row
• Insert a row
• Deleting row contents

     Columns

• Selecting a specific column
• Selecting the active column
• Selecting the last column
• Insert a column
• Deleting the column contents

     Worksheets

• Selecting a specific Worksheet
• Selecting the active worksheet
• Adding a new worksheet
• Naming a worksheet

     Range

• Selecting a range of cells

Strings:

• How to Reference a string
• Concatenating strings

If Statements:

• If Then Statements
• If Then Else Statements

Loops:

• Do While Loop
• For Next Loop
• For Next Loop with Step
• Do Until Loop
• For Each Loop

Activating Script when Workbook Opens:

• Workbook_Open
• Auto_Open