Outline subject to change without notice.
Please contact us with any questions.

EXCEL MACROS USING VBA

Upcoming Classes
  • April 26, 2012
  • May 29, 2012
  • June 27, 2012
  • July 30, 2012

COURSE DESCRIPTION
The student will learn to create, edit, record & run macros. You will learn
to insert additional steps to existing macros.  Exploring the difference
between using absolute and relative references in macros will be
covered. You will discuss the concepts of a macro and the Visual Basic
language for Applications (VBA).   

Pre-requisite: Excel Advanced and/or equivalent experience

Full Day Class Only $195.00 (Unless otherwise specified full-day
classes are weekdays from 9am to 4pm)

COURSE HIGHLIGHTS
  • Macro Basics
  • Running a macro
  • Recording a macro
  • The Visual Basic Editor
  • Macro Layout
  • The Visual Basic Toolbar
  • Relative & Absolute Recording
  • Macro Playback Variations
  • Macro Creation Techniques
  • Working With Modules
  • Keyboard Movement Keys
  • The Procedure List
  • Adding, Removing & Renaming Modules
  • Writing Macro Code
  • Understanding Visual Basic Statements
  • User Defined Functions
  • Decision Making Macro Code
  • Loops
  • Creating Variables
  • Interactive Macros
  • Message Boxes
  • Input Boxes
  • Add-Ins
  • Creating Add-ins
  • Debugging
  • UserForms
  • Create, Edit & Test
  • Add Controls
  • Procedure Calls
CALL
(330) 262-2343
or
CLICK HERE TO
REGISTER NOW!
Copyright 2012
Computer Sense, LLC