Microsoft VBA Visual Basic for Excel Video Tutorial - Training CD

Affordable Training you can depend on. Learn from an Expert from the comfort of your own desk, at a pace that suits you.

Benefits

• Works on PC or Mac
• Professional Tutition by Experts
• Self-Paced Learning Interface
• Builds Practical Skills Quickly
• Rapid Learning - High Retention
• Free Certificate with each Tutorial

Client Testimonials

• '... This CD is the best investments I've ever made. I attended a computer school to get started with the Mac, and after paying $1,100 for hands-on training, I found it impossible to remember everything we'd covered. Your CD included more information, in an easier-to-understand presentation, than the many weeks of school I attended. It also gives me an instant reference for all the things I am trying to learn ... It's like having a private tutor built right into my computer.'
  James T. Axworthy
  Woodridge Press Inc., Anaheim, CA ;

Just Released Training

Just Released this week.
• 
Poser 8 Tutorial Video

Topics covered on this Tutorial Video
are Listed Below:-

Introduction to Visual Basic for Excel

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

VBA Macros - the Quick Solution

• Overview
• Macro Virus Protection
• Recording a Macro in Visual Basic for Excel
• Running a Macro
• Reviewing and Organizing Recorded Code
• Changing a Macros Functionality
• Controlling Access to Macros
• Simplifying Access to Macros
• Tutorials Summary

The VBA Programming Language

• Overview
• Objects and Collections
• Methods; Properties and Events
• Procedures and Functions
• Visual Basic for Excel Executable Statements
• Assignment Statements
• Declaration Statements
• Variables and Constants
• Scope in Visual Basic for Excel
• Lifetime and Data Type
• Tutorials Summary

The purchased version of this product contains all the movies listed below as well as all the featured samples above. US$ 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

An effective training video that teaches using practical based examples and easy to follow instructions.

A self-paced learning interface that simplifies learning and breaks even the most complex topics down into easy to follow step-by-step instructions making it ideal for users of all levels

A proven video training product that's created by professionals and used by companies, schools, government and individuals the World over.

A verifiable Certificate Proving your Skills

Microsoft VBA Visual Basic for Excel Training - INFO

TitleMicrosoft Visual Basic for Excel

TutorPravah Pugh

Duration8 hours - 104 Movies

Price US$ 99.95

OSWin Vista XP, 2000, 98. Mac OS X

Delivery Ground / 2 day / Next Day

Product Code33286