Visual Basic Online Course Free

I want to so online Microsoft Visual Basic for Applications (VBA) Course from Virtual Training Company (VTC) so can you please provide me the details of this course?

[Shaleen]

Virtual Training Company (VTC ) is a producer of online computer and software training. They supply individuals, businesses, education providers, and non-profit organizations with access to software tutorials.

Online Microsoft Visual Basic for Applications (VBA) Course

The Microsoft Office suite of applications (Word, Excel, PowerPoint, and Access) allows users to customize views or output, but the processing performed by the applications cannot be changed.

Course: Microsoft Visual Basic for Applications (VBA)
Author: Robert Ekblaw
SKU: 34345
ISBN: 978-1-61866-050-3
Release Date: 2012-06-26
Duration: 7.5 hrs / 80 tutorials
Work Files: Yes
Captions: Yes
Subject: Programming

Course Content-

Introduction

What VBA Is

(06:58)

What This Course Is About

(07:21)

VBA vs. Visual Basic

(05:46)

Using the VBA Editor

(04:55)

Data and Variables


Data Types

(05:56)

Storage and Data Sizes

(06:51)

Declaring Variables

(04:29)

Variable Names

(05:09)

Putting Values in Variables

(05:46)

Creating Constants

(06:15)

String Variables

(06:30)

Handy String Functions

(07:43)

What an Array Is

(05:29)

Creating Arrays

(05:24)

Resizing Arrays

(06:00)

2-Dimensional Arrays

(05:16)

Sample Variables

(05:55)

Using Macros


Macro Recording

(05:30)

Recording a Macro

(04:51)

Running a Macro

(03:33)

Editing a Macro

(06:29)

Help in VBA

(06:19)

Application Object

(05:16)

VBA Expressions


Simple Arithmetic Operators

(04:46)

Advanced Arithmetic Operators

(04:39)

Comparison Operators

(04:24)

Logical Operators

(06:08)

Order of Operations

(05:14)

Mathematical Expressions

(08:09)

Using Functions in Formulas

(06:28)

Mathematical Functions

(04:11)

Conversion Functions

(04:21)

String Functions

(06:37)

Finding Words in Strings

(07:56)

Replacing and Comparing Strings

(06:33)

Sample Expressions

(06:34)

Working with Dates

(05:31)

Date Functions

(06:49)

Dialog Boxes


User Interaction

(05:55)

Using Message Boxes

(06:10)

Format Options

(07:14)

Results of Message Boxes

(02:33)

Using Input Boxes

(06:48)

Functions and Procedures


Creating a Subroutine

(03:19)

Understanding Parameters

(04:16)

Parameter Passing

(05:06)

Function vs Procedure

(04:40)

Return Statement

(04:25)

Sample Function AVE

(03:23)

Arrays as Parameters

(03:30)

Conditional Processing


What Conditional Processing Is

(03:54)

IF Block

(06:21)

Complex Conditions

(04:49)

Nested IFs and Elseif

(06:02)

Using IF in Coin Toss

(04:55)

Sample Function MIN

(06:49)

Multiple Outcomes

(05:42)

SELECT Block

(04:53)

Multiple CASE Statements

(05:24)

Conditional Functions

(04:36)

Loops


Parts of a Loop

(04:24)

Infinite Loops

(04:14)

DO WHILE Loop

(04:49)

DO UNTIL Loop

(05:03)

FOR Loops

(05:46)

Running Arrays

(04:55)

Update AVE Function

(07:38)

Sample Array Sort

(06:34)

Sample Swap Routine

(06:15)

Tracing FOR Loops

(05:48)

Step Value in for Loops

(06:35)

EXIT Statement

(06:34)

Testing Your Work


The Debug Environment

(05:10)

Seeing Values

(05:01)

Stepping Through Code

(06:05)

Breakpoints

(06:20)

Finding and Fixing Errors

(05:36)

Conclusion


What We Learned

(04:05)

Planning for your VBA Code