Microsoft Excel 2007/2010 VBA
Class timetable | Course outline
Course DescriptionThis 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.
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
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
What's included
Microsoft Excel Training Manual
Certificate of Course Completion
6 Months FREE Repeat Policy
2 AMC Movie Vouchers
Related Courses
