Lubbock Macros 11/6-7/2017 (2 Day Class)

Class time: 8:30am - 4:30pm

Lubbock County Training Center
916 Main Street 10th Floor
Lubbock, TX 79401

Macros – Automating Tasks in Excel

This class is designed for intermediate to advanced Excel users who want to learn how to discover the power of using macros in their workbooks. In this class you will learn different ways to record and write macros. You will also work in VBA and learn how to write loops and work with variables to make decisions in macros.

Macro Basics

• How to Record a Macro
• Recording Absolute vs. Relative
• Understanding Macro Security Options
• Running the Macro
• Use Macro Option
• Distinguish Options for Storing the Macro

Modifying your Macro

• Navigating the VBA window
• Editing VBA
• Debugging and Stepping Through a Macro
• Using Break Points
• Deleting a macro

Running the Macro

• Run a Macro Using the Ribbon
• Run a Macro Using Keystrokes
• Assigning the Macro to a button
• Modify the Ribbon and Quick Access Toolbar to add buttons
• Creating a Custom Macro Button in the Workbook.

Writing a Macro in the VBA Window

• Learning the InputBox and MsgBox command
• Using the Workbook_Open Command
• Using Variable in a Macro
• Writing If, Then, Else statement
• Turning the Screen on or off

Working with Loops

• Learn how to write Loops
• Include variable in Loops

Class Information

Class date: 11/06/17
Class end date: 11/07/17
Seats Remaining: 12
Cut off date: 11/06/17
Individual Price: $279.00
Location: Lubbock County Training Center

Group Rate

No Number registrants Rate/Person($)
1 3 259.00
Share this class: