Microsoft Visual Basic for Excel Tutorial Video

Details

This Visual Basic for Excel tutorial offers users an cost effective way to master this application it days. Presented using narrated QuickTime videos that work on both PC and Mac platforms. This training CD uses practical examples and easy to follow step by step instructions to convey knowledge and accelerate the learning process, users of this training product will benefit from a degree of clarity and retention that other forms of training fail to match. Most of the tutorials are suitable for beginner to intermediate users.
Close

Visual Basic for Excel Video Training

Contents

All the topics covered by this Visual Basic for Excel Training CD are listed below. The blue links are FREE Demos. Suitable for use on PC or MAC.

Try for FREE - NOW

QuicktimeInformation on the free demos.
So you can sample the high quality of this training product we have made available the first free chapters for free. On the purchased product the entire listing below is included. Please note the sound and video quality of the free demos has been compressed for faster internet delivery, the audio and video on the purchased CDs is much higher. In order to play the free demos Apple QuickTime 7 or above is needed if required

Click here to Buy This Video DVD

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

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

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


If you purchase the CD all the contents listed below are also included.

The 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

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

Visual Basic for Excel Tutorial Video Information

Product Title: Visual Basic for Excel
Trainer: Pravah Pugh
Other Training courses by this author
Movie Details: 104 Lessons- Video run time: 8 Hours
Price North America $99.95
Price for Europen Sales £79.95 ( + Vat )
Delivery: 3 working days ( UK / USA and Canada )
Suitable for: Win 95, 98, 2000, NT, XP, Mac OS, OSX

137 In Stock

BUY THIS VIDEO

Benefits of this training method
  • Unique accelerated learning, master Visual Basic for Excel in days.
  • All training courses are taught by leading experts
  • Highly informative with an unmatched level of retention
  • Easy to follow step-by-step instructions
  • Ideal for single of multi users,
  • Users control the pace of the training, lessons can be stopped, rewound or fast-forwarded at any time.
  • More cost effective than a classroom training course, learn when it suits you.

Associated Titles:

Microsoft Excel 2007 Tutorials | Microsoft Access 2007 Training Video | Microsoft Visual Basic for Access Tutorials | Microsoft Word 2007 Training CD

Unrestricted Access to every training video - $30.00

Not sure which training CD to purchase? Why not have unlimited access to the entire range of training videos featured on this site for an unbelievable price of just $30 per month, that’s a massive 4,500 hours worth.

online people

Over 4000 hours of high quality training videos covering more than 350 of the most sort after software experts, accessible right from your own desk top, and all for just $30 per month.
No minimum sign up period
For Companies and Schools we offer a Multi User version complete with control panel, monitor usage, download reports, grant access and more.

Once signed up access is granted instantly to over 350 different titles with totally no restrictions, you can view as many different titles as you wish, there are no limits on how long you can log in for, you can even access from any computer.

This is without a doubt the most comprehensive source of high quality training on the web, and all at an unbelievable low price.

Learn even the most complex applications without having to read a manual or attend expensive classroom type training, learn when it’s convenient to you.

New titles are added each month, and as a member you will also have unlimited access to these as well.l.

Most of the training titles also have exercise files, these are included at no extra charge.

On completion of each course users can obtain a certification to verify the training.

Free Training Newsletter

Sign up for our free newsletter and get updated on when new titles are realised, and or when special offers are available
Your details are secure we never traded, sell or otherwise exchange your data with any third parties.

Best Selling Titles - Groups:

Access Tutorials | Microsoft Word |Excel Tutorials | FileMaker Pro | Microsoft Outlook 2000 | Microsoft Project 2000 | Microsoft Visio 2002 | Online Visual Basic for Excel Training Courses