PRODUCT INFO
 
Shipping Information
Product Guarantee
Testimonials
 
MAIN LINKS
 
Training Categories
New Titles
In Development
Free Online Demos
Multi User Training CDs
Contact Us
 


This Week's Special Offer

NEW TITLE DISCOUNT!
Final Cut Pro 7 Tutorial


Quicktime is required for the movies,
click here to download if needed.

Please Note: The online FREE lessons have been compressed for faster downloads. Purchased CD ROMs/DVDs load almost instantly and have higher sound and video quality.

Please allow a few seconds for the FREE online tutorials to load. If you have any difficulties downloading these FREE online tutorials. Please do not hesitate to contact us for download help.


- See right for full details on this Microsoft Visual Basic for Excel Tutorial

- See far right to purchase this Microsoft Visual Basic for Excel Training CD

Microsoft Visual Basic for Excel Tutorial

 Professionally created, self-study video training.

About this Tutorialshow details
If you want to learn Visual Basic for Excel in the shortest time possible then you can't go far wrong with this comprehensive beginners VB for Excel tutorial. All essential concepts and principles are demonstrated using step by step video training movies, which include macros, the development environment, functions, accessing and saving code, labels and a whole lot more! You can start learning right now, click any blue linked lesson below for FREE Visual Basic for Excel tutorials...
Learn this Software - See below for FREE TUTORIALS

Each Course on 1 or 2 CDs
For Mac and PC


FREE Shipping on all Orders


Microsoft Visual Basic for Excel Tutorial Info

CLICK HERE TO BUY THIS CD
Tutor: Pravah Pugh
Duration: 8 hrs / 104 video lessons
Cost for UK: £79.95 + VAT
Cost for EU: €84.95 + VAT
Cost for US & Canada: $124.95
Product Code: 33286
Delivery: Please allow 2-3 days for UK & Europe, 3-5 days US & rest of world

IN STOCK

- All CDs Shipped Carriage FREE -
Compatibility: MS Windows 7, Vista, XP, 2000, 98, NT, Mac OS X, OS 9
 

Benefits of this Software Training
  Tuition by expert tutors.
  Narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter.
  Learning is fast as the trainers use simplistic terms and minimal jargon.
  Step-by-step video training from your own desktop. Delivered via CD training or online tuition.
  The tutor transfers knowledge to you quickly and effectively.
  All the concepts of each application are explained clearly and precisely.
  Every course works on PC and Mac.
  Alternative to a boring book or manual and expensive training courses & classes.
  Jump to and from lessons - learn at your own pace.
  The visual and practical nature shortens the learning curve compared to standard training manuals.
Customer Testimonials
Associated Training CDs:
Microsoft Visual Basic for Access 2002 | Microsoft Visual Basic for Access | Microsoft Visual Basic.NET | Microsoft Visual Basic 2008 | Microsoft Visual Studio 2005 | Visual Studio 2005 & .net 2.0 | Complete Range of Microsoft Visual Basic Tutorials | Complete Range of Microsoft Excel Tutorials | Microsoft Visual Basic 2005 | Complete Range of Advanced Excel Tutorials | Complete Range of Microsoft Visual Studio Tutorials
 
CD CONTENTS & FREE VIDEO TUTORIALS
Click on any linked lesson below for a FREE demo
Purchased CD tutorials load almost instantly and have higher sound & video quality. For tutorial support see left

VBE Introduction
Course Overview
Macros and VBA - A Demonstration
Using Excel Online Help
Using Visual Basic Online Help
Locating Information Across Help Files

Macros - the Quick Solution to a Macro
Overview
Macro Virus Protection
Recording a Macro
Running a Macro
Reviewing and Organising Recorded Code
Changing a Macros Functionality
Controlling Access to Macros
Simplifying Access to Macros
Summary

The VBA Programming Language
Overview
Objects and Collections
Methods; Properties and Events
Procedures and Functions
Executable Statements
Assignment Statements
Declaration Statements
Variables and Constants
Scope
Lifetime and Data Type
Summary

We hope you enjoyed the FREE lessons above. To view the complete contents, including ALL the lessons below, please purchase the CD.
CLICK HERE TO BUY THIS CD


The MS VBA Development Environment
Overview
Windows
Command Bars
The Code Window
Margin Indicator Bar
Code Interpretation
Type and Status Formatting
Entering Keywords
Syntax Assistance
The Project Explorer
The Properties Window
The Object Browser
Using the Object Browser
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
Application Modes
Exploring Application Modes
Design Mode & Running Mode Demonstrations
Run Time Editing and Compiling
Summary

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
Summary

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

VB 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
Summary

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
Summary


CLICK HERE TO BUY THIS CD