Microsoft Visual Basic for Excel Tutorials

Details

Highly Effective Visual Basic for Excel tutorials on video CD, learn from your own desk at a pace that suits you. Low cost high quality training at an affordable price. Works on 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
Close
Visual Basic for Excel Training CD / DVD Contents
Professionally created, comprehensive training that's easy to follow at an unbelivable price.

See the quality for yourself. Try a FREE Demo.

The blue links below are Free Visual Basic for Excel Tutorial Videos.

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.

Read before watching the free videos
The sound quality and frame rate of free online tutorials has been reduced to allow for faster streaming. The quality on CD / DVD is far higher.
Quicktime
*QuickTime is needed to view the videos. Some titles have been converted to play via Flash.
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
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
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 Training CD Information

Title : Visual Basic for Excel
Tutor : Pravah Pugh
Other tutorials and training by this author
Movies : 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

197 In Stock

Add to Cart

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.
  • Unique teaching method that offers accelerated learning and high retention.
  • Used by many large companies, schools, universities,
  • Learn from your own desk at a speed that suits you
  • Cost effective tuition from leading experts
  • You control the pace, training can be stopped, rewound or fast forwarded as required.
  • This title also has sub titles, which add clarity and help with retention. it also benefits users who are deaf / hearing impaired.

Associated Titles:

Free Certificate. Prove your credentials
online people


We now offer all customers a free certificate to verify they have undertaken a Visual Basic for Excel 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.

Online University Access all our Training for only $30.00

Not sure which training CD titles to purchase ? Why not join our Online University and have unlimited access to all our titles for one low price ?

online people

over 4000 hours of high quality online training for only $30.00. Unlimited access

learn from your own desk -expert tutorials - affordable tuition.
No minimum sign up period.
Want to see how good our online university is? - Why not try a free Demo

For low monthly fee you have unlimited access to all the 300+ training titles in our range, that's over 35,000 tutorials covering 4000 hours+! Watch when ever you like, from any computer - NO LIMITS.

Join Today and learn quicker and cheaper than you ever thought possible.

Become a expert without having to read a book or attend expensive training courses.

Where else can you find step-by-step training for over 300 software applications delivered to your own desk, from a leading expert, for less then a Dollar a day ?

Want to see how good our online university is? - Why not try a free Demo, and if all that's not enough, we add new video tutorials each month for no extra charge!

Free Newsletter

If you would like to be notified as we release new video tutorials, run special offers, or promotions.
Sign up now. Your details are kept secure and never sold rented or used by any other 3rd parties.

Visual Basic for Excel Related Product Groups:

Access Tutorials | Microsoft Office for the Mac | Apple iWork Tutorials | Microsoft Word |Excel Tutorials | FileMaker Pro | Microsoft Outlook Training | Microsoft Project 2007 | Microsoft PowerPoint | Microsoft Visio | Online Visual Basic for Excel Training Courses