Training Course:Excel VBA Introduction (Certificate)School/Trainer:NobleProg
Birmingham, London, United Kingdom
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' Macros
Recording and Modifying Macros
Assigning Macros to Toolbar, Buttons, Shortcut key
Visual Basic for Applications Environment
Visual Basic Editor and its options
Component Management
Shortcuts
Environment Optimization
Introduction to Procedural Programming
Procedures: Functions and Sub-routines
Data Types
Control Flow
If ...Then....Elseif....Else....Endif
Case
Do...Loop , While
For... Next
Exit
Arrays and Loops
Strings
Visual Basic
VBA and Sheet Data Exchange (Cells, Range Methods)
Getting and Printing Data from Users (InputBox, MsgBox)
Variable Declaration
Scope and LifeTime of Variables and Objects
Operators and Their Priorities
Modules Options
Creating Worksheet Functions
Objects, Classes, Methods and Properties
Locking Project for Viewing
Debugging
Run Time, Design Time, and Break Mode
Brakes and Watches
Local Window
Immediate Window
Call Stack
Error Handling
Errors Types
On Error GoTo
On Error Resume Next
Excel Model Object
Application Object
Workbook Object and Workbooks Collection
Worksheet Object and Worksheets Collection
ThisWorkbook, ActiveWorkbook, ActiveCell, ....
Selection Object
Range Collection
Cells Collection
Using Status Bar
Screen Updating and Optimizing
Timer and Time Measuring
Events Handling in VBA
VBA Forms
Creating and Using Forms
Invoking Forms in VBA Code
Using VBA Forms in Worksheet
...''
Please go to the school's official website for training price and schedule:
http://www.nobleprog.co.uk/
Phone:+44 20 7558 8274
School Address:
Dephna House
112/ 114 North Acton Road
NW10 6QH
London
UK
ul. Księcia Józefa 355/8
30-243 Kraków
Poland
Jobs & Resumes: Birmingham, London
Houses & Roommates: Birmingham, London
Travel Agencies: Birmingham, London
Search other schools for Excel VBA Introduction training resources.
Other training courses offered by NobleProg:
Building Social Networking Application in Drupal
Drupal for Developers
Drupal 6 for Developers
Drupal 5.x Optimization
Drupal Views Module
Drupal Applications in UML
Drupal Integration with SOAP
Excel Introduction
Excel Advanced
Excel Advanced with VBA
Excel VBA Advanced
Analysing Financial Data in Excel
Excel For Statistical Data Analysis
MDA (Model Driven Architecture) development with AndroMDA
Sun Certified Java Programmer (SCJP)
Linux Installation and Configuration
Linux System Administration
Linux Networking
C# Language in Visual Studio .NET
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
Try the search form on top of each page to find the latest course information, using course topic and location as keywords. Keep the course topic keyword short to get more results. |
|
|
