Visual Basic for Excel Tutorial - Beginners VBA Training CD

Self Study, Visual Basic for Excel Tutorial Video on CD - DVD. The tutor guides you using step-by-step examples. Learn directly from your own desk high quality training videos at an affordable price. Works on both PC and Mac.

These Microsoft Visual Basic for Excel tutorials offer the user an ideal way to utilize macros and using VBA programming in Excel. Using easy to follow step-by-step instructions and narrated QuickTime videos learning is both simple and enjoyable, even the absolute novice will have no problems following along with the lessons. Related titles: VBA for Access tutorials .

Visual Basic for Excel Tutorial CD / DVD

Creates the perfect self-paced learning environment
on your own desktop.

Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Try for FREE - NOW. To help you evaluate this training CD / DVD the first 3 chapters are available for free, click on any of the links below for a FREE DEMO.

Problems Playing the Demos?

Benefits

Professional Tuition by expert
Free Certificate with each Tutorial
Works on PC or Mac

Topics Covered on this Training Video Include:

Introduction to Visual Basic for Excel

VBA Macros - the Quick Solution

The VBA Programming Language

We hope you enjoyed the free videos above. To watch all this course including the chapters below please purchase the CD.

$99.95

The VBA Development Environment

Overview
Windows
Command Bars
The Code Window
Margin Indicator Bar
Visual Basic for Excel Code Interpretation
Type and Status Formatting
Entering Keywords
Syntax Assistance
The Visual Basic for Excel Project Explorer
The PropertiesWindow
The Object Browser
Using the Object Browser
Tutorials Summary

Development and Troubleshooting

Overview
Running Code and Debug Printing
Step Into, Break Mode and the Call Stack
Step Over, Step Out and Run to Cursor
Breakpoints
Variable Values and the Data Tips Window
The Quick Watch Dialog Box and Watch Window
The Locals Window
Tracking Object Variables
Visual Basic for Excel Application Modes
Exploring Application Modes
Design Mode & Running Mode Demonstrations
Run Time Editing and Compiling
Tutorials Summary

Visual Basic for Excel Using Functions

Overview
Using User Defined Functions
Changing Function Categories
Creating New Function Categories
Formulae and the Worksheet Function Object
VBA and Excel Function Differences
Tutorials Summary

Code Production and Management

Overview
Automated Placement of Statements
Accessing Code
Using Project References
Saving Code
Password Protection
Summary

Visual Basic for Excel Cell Referencing

Overview
The Range Property and Selecting Cells
Specifying Multiple Cell Ranges
Qualifying Ranges Returned and Offsets
Other Range Returning Properties
Labels and Names
Ranges in Other Workbooks
Shorthand Notation and 3-D Ranges
Tutorials Summary

VBA Control Structures

Overview
With Control Structure
IF...Then...Else Control Structure
Select Case Control Structure
For...Next Loops
For Each... Next Loops
Do While...Loop and Do Until...Loop
Do...Loop While and Do...Loop Until
Summary

Interacting With Users

Overview
The Message Box
The Message Box Constants
The Input Box
Object Positioning
Quiz Example
Protecting Users
Tutorials Summary

About this Visual Basic for Excel Training CD

Title :	Visual Basic for Excel
Tutor :	Pravah Pugh Other tutorials by Pravah Pugh
Videos :	104 Lessons- Video run time: 8 Hours
Availability :	Immediate Dispatch
Compatibility:	Vista, 98, 2000, NT, XP, Mac OS, OSX
Released	2001-12-17
Price US / Canadian Sales	$99.95

516 In Stock

Purchase Orders: from Schools, Colleges, Government and Military accepted

Multi User Network Version Available

This training is also available in Multi User format for Schools and Corporate users.

10 Multi User $500

Why use this method of video training ?

Learn Visual Basic for Excel from an accredited expert in days.
Ideal for beginners, easy to follow videos that offer visual clarity.
Master a full application for a fraction of the cost of classroom based training, and faster than with a manual.
Unique teaching method that offers accelerated learning and high retention.
Used by many large companies, schools, universities,
click to see some of our customers.
Learn from your own desk at a speed that suits you
Cost effective tuition from leading expert tutors
You control the pace, training can be stopped, rewound or fast forwarded as required.
High Quality Tutorial Videos on CD / DVD or Online. PC / Mac Compatible. Great tuition at an affordable price
This title also has Closed Captions, which add clarity and help with retention. it also benefits users who are deaf / hearing impaired.

Want to hear what our customers say about our products?

Associated Tutorials:

Visual Basic for Excel Related Training Videos:

Free Certificate. Prove Your Credentials

We now offer all customers a free certificate to verify they have undertaken a Visual Basic for Excel training course, the unique certification number allows third parties to check the authenticity of your certificate online. After your purchase you can download your Visual Basic for Excel certificate without delay.

Instant Online Access all the Training Videos for only $30.00

Unlimited Accesss to 60,000 Training Video only $30.
Not sure which training CD titles to purchase ? Why not join our Online University and have unlimited access to all our tutorial videos for one low price of $30 per month.

No contract , No minimum period, and no commitment on your part.

You can have access to every title we list on this site for just $30 per month. When you sign up you get instant access with absolutely no restrictions or limits. Log on from any location and watch as much as you like.

When your finished cancelling is easy, just click the cancel button, that's it, no questions, your in total control.