Visual Basic for Excel Video Tutorial Course

CareerVision Training

£70 - (R$269)

Informação importante

  • Training
  • Beginner
  • A distância
  • Duração:
  • Quando:
    à escolha
  • Envio de material didático

• Format: DVD-ROM
• Duration: 8 Hours (90 lessons)
• Instructor: Guy Vaccaro
• Platform: Windows PC or Mac


Take your skills to the next level. This Learning Visual Basic for Microsoft Excel Tutorial Video is the ultimate in comprehensive instruction for the discerning professional.

These training classes use broadcast quality audio and video to deliver concise and informative training right to your desktop. The course is presented via an intuitive, easy-to-use interface, allowing you to learn at your own pace.

These Learning Visual Basic for Microsoft Excel Tutorials break even the most complex subjects down into easy to follow segments, following along is simple. Practical working files further enhance the learning process and provide a degree of retention that is unmatched by any other form of training.

Informação importante

Requisitos: This is a DVD Video Tutorial Course which is shipped to you. Work through the video tutorials at your own pace. If you have the software you can practice along with the instructor using the same exercise files as the instructor which are included on the DVD. The narrated training videos demonstrate the key tools and professional techniques helping you to work faster and smarter. All the concepts of each application are explained clearly and precisely. The DVD works on PC and Mac. You can jump to and from lessons and work at your own pace.


Instalações e datas

Início Localização
à escolha
Distance Learning

O que se aprende nesse curso?

Graphs and Charts
Conditional Formatting
Excel Features
VBA Programming


Getting Started
What Will I Get Out Of This Course
About The Author
The Working Files Explained
What Is VBA?
Excel 2010 Security Settings And Macro Files
The Developer Ribbon

Recording And Running A Simple Macro
Editing An Existing Macro In The Visual Basic Editor
The New Macro Enabled File Type
Quick Tour Of The Visual Basic Editor
Watch A Macro Write Your VBA

Procedures And Functions
What Is A Module?
Creating A Sub Procedure Manually
How To Call A Sub Procedure
Creating A Function Procedure
How To Call A Function

Getting Started With VBA Programming
Using Comments Within Your VBA Code
Declaring Variables And Data Types
The Scope Of A Variable
The Static Declaration And Variable Expiry
Constants Instead Of Variables
An Intrinsic Constant
String And Date Types Expanded
VBA Operators
Multi-Dimensional Arrays
Dynamic Arrays

Manipulating Excel Objects
Referencing Cells Using The Range Object
The CELLS Property
The OFFSET Property
The VALUE Of Ranges
The TEXT Object Of The RANGE
A Number Of Read Only RANGE Properties
The FONT Property And Colors
Formatting Numeric Values
Add Formulas To Cells Through VBA Code
Common METHODS Of The RANGE Object

Working With Excel VBA Functions
What Is A Function?
Built In VBA Date Functions
Text Manipulation With VBA Functions
Determining File Sizes Using FILELEN
Using Worksheet Excel Functions In VBA Code
User Defined Functions

Controlling Program Flow And Execution
Using GOTO And Labels
Controlling The Program Flow With IF THEN ELSE
Multiple Criteria Plus Nested IFs
Adding ELSEIF To Speed Up Execution
SELECT CASE As An Alternative To IF
FOR NEXT With A VBA Collection

How To Create An Event
WorkBook Events - Open
Workbook Events - Closing And Saving
Workbook Triggers - Activate And Deactivate
Worksheet Triggers - Activate And Deactivate
Other Useful Worksheet Triggers
Using Application Events

Debugging And Error Handling
Error Trapping the Easy Way
Make The VBA Ignore Errors
Interact With The User When An Error Occurs
Making Use Of The ERR Object
Debugging Techniques
Using Breakpoints To Help Debug
Setup And Use A Watch
Speeding Up The VBA Tips

Interacting With Users Through Forms
Using MSGBOX To Interact With Users
Use INPUTBOX For Accepting Values From Users
Selecting A Range With The INPUT Box
An Introduction To UserForms
Creating A UserForm
Using Command Buttons
Adding Option Buttons In A Frame
Adding The Code That Makes The Form Work
Calling Your UserForm And Validating Content
UserForm Controls - The CheckBox
UserForm Controls - ListBox And/Or Combo Box
Images On UserForms
Labels And Text Boxes
Multiple Tabs On A UserForm
Allowing The User To Highlight A Range
Scrollbar And Spin Controls
Controlling Tab Order And Aligning Controls

Running And Storing VBA Code
Trigger A Procedure From The Quick Access Toolbar
Customizing The Ribbons
Adding Buttons To Sheets
Adding A Keyboard Shortcut Trigger
Where To Store Your VBA Code
Adding Code To The PERSONAL File

So What's Next?