Austin - Excel: Marco Basics 10/14/2019

Length

7 hours (2 days)

Time

8:30 a.m. – 4:30 p.m.

One-hour break for lunch and a 15-minute morning and afternoon break.

Location:

Sleep Inn - Austin
8410 E Hwy 290
Austin, TX, 78724

Course Description

This class is designed for the intermediate to advanced Excel user who wants to expand their knowledge of Excel, specifically in macros. In this class we will learn the ways to record and debug macros. We will work with variables and learn how to write VBA code such as loops and input boxes. In the class you will learn:

MACRO BASICS

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

MODIFYING YOUR MACRO

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

WRITING A MACRO IN THE VBA WINDOW

  • Learning the InputBox and MsgBox command
  • Using Variables in a Macro

WORKING WITH LOOPS

  • Learn how to write Loops
  • Include variables in Loops

Who Should Attend

Intermediate to Advanced Excel users who would like to expand their knowledge of Excel macros.

Prerequisites

Students must have an Intermediate to Advanced understanding of Microsoft Excel.

Class Information

Class date: 10/14/19
Class end date: 10/14/19
Seats Remaining: 9
Cut off date: 10/14/19
Individual Price: $199.00
Location: Sleep Inn - Austin

Group Rate

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