Excel VBA training

Microsoft Excel 2007/2010 VBA

Class timetable | Course outline

Course Description

This Excel VBA course is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, creating user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code. Find out more about our other Microsoft Excel classes.

Target Audience

This Excel VBA course is aimed at experienced Excel users looking to automate many of the repetitive tasks that are part of spreadsheet development by applying the Visual Basic for Applications (VBA) programming language to Excel tasks. Students are expected to have completed Excel Level 3 or have equivalent experience prior to attending this class. Suitable for Excel 2003, 2007 and 2010 users.

Excel VBA course facts
Money Back Guarantee

For added peace of mind, Training Connection’s Microsoft Excel training comes with a 100% Money Back Guarantee.
If by lunchtime you don't feel that the program is for you, then you can leave the course at this point and receive a full refund of your course fees.

Excel VBA Class Timetable

Chicago May 24 * Register
Los Angeles Jun 14 ! Register
Chicago Jul 19 ! Register
Los Angeles Aug 16 Register
Chicago Sep 14 Register
Los Angeles Oct 11 Register
Chicago Nov 15 Register

*  Class almost full    !  Class guaranteed to run    †  Class is full

Book Excel VBA Training
 
Detailed Course Outline

Visual Basic Editor

  • Visual Basic Termimology
  • Start the Visual Basic Editor
  • Work with Object properties and methods
  • Attach code to events and buttons
  • Use Object Browser to get information about Objects

Programming Basics

  • Use Variables of various Data Types
  • Manipulate Data using Expressions
  • Declare and use Variables of correct Scope
  • Declare and use Procedures of correct Scope
  • Create Sub and Function Procedures
  • Call one Procedure from other

Control Structures

  • Use Decision Structures to create procedures that execute code
  • Use Loop structures to execute code repeatedly

Custom Dialog boxes

  • Add a User Form to your project
  • Add Controls to User Form
  • Attach Handle Events to Controls
  • Validate Data entered

Debugging and Error Handling

  • Identify compile-time, run-time and logical errors
  • Use the Debugging Tools
  • Write Error-handling code to trap errors
Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.
 

What's included

Microsoft Excel Training Manual
Certificate of Course Completion
6 Months FREE Repeat Policy
2 AMC Movie Vouchers

Related Courses

Excel Level 1 course Excel Level 1
Excel Level 2 course Excel Level 2
Excel Level 3 training Excel Level 3

Register for Excel VBA Training
Excel Training Testimonial
"I can not wait to implement what I learned today. Rich worked with each of us on real world situations we encounter in our working lives. What a great way to learn!"
Megan Gurney - LKQ Corporation
Excel Training Testimonial
"Great class and wonderful instructor. I feel like I learned a lot in a short time. Almost wish the class was longer than 1 day...it really made me want to learn more."
Jeff Krauss - Woman's Life Insurance
Excel Training Testimonial
"Rich was very knowledgeable in the subject matter and is a great teacher. We spent almost the entire time on real-world examples from each of our backgrounds - which I think was really helpful for all of us present."
Christopher Aguilar - Northern Trust Global Investments
# # # # # # # # # # # # # # # # # #
Computer and Business Skills Training

Adobe Training

Acrobat Training
After Effects Training
Captivate Training
Dreamweaver Training
Flash Training
Flash Builder Training
Illustrator Training
InDesign Training
Photoshop Training
Premiere Pro Training

Web Development

AJAX Training
CSS Training
HTML Training
JavaScript Training
jQuery Training
PHP MySQL Training

Microsoft Office

Access Training
Excel Training
Outlook Training
PowerPoint Training
Project Training
Visio Training
Word Training

Business Skills

Business Communication
Business Etiquette Training
Business Writing Class
Customer Service Training
Project Management Training
Time Management Training

QuickBooks

QuickBooks Training
 
 
  • HOME
  • TRAINING
  • TIMETABLE
  • ONSITE TRAINING
  • ROOM HIRE
  • ABOUT US
  • CONTACT US

  • SITE MAP
  • TERMS
  • COPYRIGHT 2007 - 2009