ONLINE- Excel Macros Basics 9/30/2020

Length/CPE Hours

7 hours

Class Time

8:30 a.m. –4 :15 p.m. Central Time
Start Time: 9:00 AM
Break: 10:00 – 10:15 AM
Lunch: 11:30 to 12:15 (45 minutes)
Break: 1:45 PM – 2:00 PM
Class Time 4:15 PM

Method of Delivery

This class will be held online using GoTo Metting.  Class participants will receive a PDF of the book and will be able to access the class files online.

When you register, be sure to use the email that you would like your GoTo Metting invitation sent to.  The meeting invitation will be sent no later than 1 hour prior to the class. Check your junk mail if you do not receive an invitation, especially if you have a Gmail or Hotmail account.  You do not have to have a GoTo Metting subscription to participate.  

The web browser client will download automatically when you start or join your first GoTo Metting meeting and is also available for manual download here.

https://www.gotomeeting.com/

It is a good idea to download this prior to the online meeting.

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

Prerequisites

Students must have a beginner level knowledge of Microsoft Excel.

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.

Cancellation Deadline

For class fees paid directly to Cloud Training Services a person must cancel by the class deadline to receive a full refund. The cancellation deadline varies based upon location but it usually 5 to 10 days prior to the class. The cancellation deadline is stated at the top of this page.

If you are unable to attend and do not cancel prior to the class, you may send a substitute. Cloud Training Services will consider emergency situations such as a death in the family, illness and weather, and will make every attempt to work with the person in the event of an emergency.

Note

Cloud Training Services partners with other training vendors such as Odessa College and New Mexico Junior College and has no control over payment and registration process. When the registration fees are paid to another agency or vendor, the cancellation and refund policy will be those of that agency or vendor.

Event Properties

Event Date 09-30-2020 8:30 am
Event End Date 09-30-2020 4:15 pm
Capacity 14
Registered 1
Available place 13
Cut off date 09-30-2020 8:00 am
Individual Price $189.00
Location ONLINE

Group Rate

#Registrants Rate/Person($)
3 169.00