Self Study, 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

Associated Tutorials: Microsoft Excel 2007 | Microsoft Visual Basic for Access | Microsoft Excel Automation | Microsoft Visual Basic 2008 | Microsoft Word 2010 | Microsoft Excel 2010

Visual Basic for Excel Tutorial CD / DVD

When you order this Visual Basic for Excel Video Tutorial CD You'll Receive...
Over 8 hours of high quality video-based training that walks you through the program in easy to follow stages.

A training video that focuses on real life examples and teaches you
real life skills. These tutorials are structured to increase not only your skills but also your earning potential.

With this Training Video you will...
Learn Visual Basic for Excel from a leading expert and quickly master the skills required to work in a commercial environment.

Learn how to simplify your workflow and increase your productivity using tips and techniques of the pros. Ideal training for Beginners and Advanced users alike

Customer Comments
" i'm a web designer and coder and i didn't think much of video training...the free demos convinced me to go ahead and buy and i have not looked back. "Rene Figueroa, California

Visual Basic for Excel Tutorial CD / DVD

Create the best self-paced learning environment right on your own desktop.
Professionally created, comprehensive video based training that's easy to follow. At an unbelievable price.

Topics Covered on this Training Course

This Training is 8 Hours in Duration and Covers 104 Lessons.
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

Select Playback Format for the Free Demos:

Quicktime
Flash

Did You Know ?

We offer more than 700 video-based courses, and you can watch the first three chapters of every listed course for FREE with no obligation to buy.

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
Compatibility Vista, XP, Windows 7, Mac OSX
Released 2001
Availability Immediate Dispatch
Price US / Canadian Sales Only $99.95
Closed Captions Closed Captions are available to Online Users only
602 in stock
Purchase Orders from Schools, Colleges, Government and Military Accepted

Mutli User Training Options

This training video is also available in Multi-user format, ideal for Schools, Universities, or Corporate users where training multiple delegates is the most cost effective way of training.

10 Multi User $500

Not Sure Which Titles to Buy? Unlimited Access to all -$30

Need to learn more than one topic? Get Unlimited Access to all the courses listed on this site for just $30!
Unlimited Access to over 70,000+ Training Videos

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.
No commitment on your part.

Within minutes you'll have instant, unlimited access to over 700 courses covering over 6000+ hours of training, all from the comfort of your own desk.

Need to learn from more than one location? Not a problem, you're free to access the training from anywhere you wish. It's highly cost effective learning with no limits. We also offer Multi User accounts for companies and schools who need to train multiple users.
Online Learning with No Limits

Why Is This Training Format So Effective?

  • Learn Visual Basic for Excel from an accredited expert in days.

Want to hear what our customers say about our products?

Related Training Videos

FileMaker Tutorials | Excel Tutorial Videos | Microsoft Word Tutorials | Online Visual Basic for Excel Training Courses

Prove your Knowledge - Free Certificate

Prove Your Credentials!
Free Certificate.