VBA Training Courses and Workshops

Schools providing training courses, certificates, diplomas or degree programs of VBA




Total 216 training courses and degree programs available around the world.

VBA for Excel

Course Format: Public Course / Instructor-Led / Open Enrollment
School/Trainer: New Horizons Las Vegas
Training Center(s)/Venue(s): Las Vegas, United States
  V

Student will learn to create and run macros, use the VB editor, learn the use of Interface Boxes, variables and Conditional Routines.


Outline :
Lesson 1: Introduction
Applications Interfaces
Options
Setup


Lesson 2: Programming Languages
OOP & The Excel Object Model
Macros vs. Programming


Lesson 3: Creating & Running Macros
Macros in Excel
Using Macros to Learn & Use Code
Using Macros to Learn Objects


Lesson 4: Visual Basic Editor
Application Switching
Menus - View, Tools, Help
Windows - Project, Property, Object, Immediate & Module
Code Conventions
Use Immediate Window
Run & Debug
Modules, Subs, Functions & Scope


Lesson 5: Interface Boxes
Message Boxes
Input Boxes
Forms - Dialog Boxes


Lesson 6: Variables


Lesson 7: Conditional Routines
Immediate IF Statements
IF-THEN Statements
Case Statements
Loops - FOR/NEXT, DO/WHILE, DO/UNTIL


Lesson 8: Introduction to Arrays


Lesson 9: Functions in Excel

VBA for Excel

Course Format: Public Course / Instructor-Led / Open Enrollment
School/Trainer: New Horizons Waltham
Training Center(s)/Venue(s): Waltham, United States
  V

Student will learn to create and run macros, use the VB editor, learn the use of Interface Boxes, variables and Conditional Routines.


Outline :
Lesson 1: Introduction
Applications Interfaces
Options
Setup


Lesson 2: Programming Languages
OOP & The Excel Object Model
Macros vs. Programming


Lesson 3: Creating & Running Macros
Macros in Excel
Using Macros to Learn & Use Code
Using Macros to Learn Objects


Lesson 4: Visual Basic Editor
Application Switching
Menus - View, Tools, Help
Windows - Project, Property, Object, Immediate & Module
Code Conventions
Use Immediate Window
Run & Debug
Modules, Subs, Functions & Scope


Lesson 5: Interface Boxes
Message Boxes
Input Boxes
Forms - Dialog Boxes


Lesson 6: Variables


Lesson 7: Conditional Routines
Immediate IF Statements
IF-THEN Statements
Case Statements
Loops - FOR/NEXT, DO/WHILE, DO/UNTIL


Lesson 8: Introduction to Arrays


Lesson 9: Functions in Excel

VBA for Excel

Course Format: Public Course / Instructor-Led / Open Enrollment
School/Trainer: New Horizons Sioux City
Training Center(s)/Venue(s): Sioux City, United States
  V

Student will learn to create and run macros, use the VB editor, learn the use of Interface Boxes, variables and Conditional Routines.


Outline :
Lesson 1: Introduction
Applications Interfaces
Options
Setup


Lesson 2: Programming Languages
OOP & The Excel Object Model
Macros vs. Programming


Lesson 3: Creating & Running Macros
Macros in Excel
Using Macros to Learn & Use Code
Using Macros to Learn Objects


Lesson 4: Visual Basic Editor
Application Switching
Menus - View, Tools, Help
Windows - Project, Property, Object, Immediate & Module
Code Conventions
Use Immediate Window
Run & Debug
Modules, Subs, Functions & Scope


Lesson 5: Interface Boxes
Message Boxes
Input Boxes
Forms - Dialog Boxes


Lesson 6: Variables


Lesson 7: Conditional Routines
Immediate IF Statements
IF-THEN Statements
Case Statements
Loops - FOR/NEXT, DO/WHILE, DO/UNTIL


Lesson 8: Introduction to Arrays


Lesson 9: Functions in Excel

VBA for Excel

Course Format: Public Course / Instructor-Led / Open Enrollment
School/Trainer: New Horizons Jacksonville
Training Center(s)/Venue(s): Jacksonville, United States
  V

Student will learn to create and run macros, use the VB editor, learn the use of Interface Boxes, variables and Conditional Routines.


Outline :
Lesson 1: Introduction
Applications Interfaces
Options
Setup


Lesson 2: Programming Languages
OOP & The Excel Object Model
Macros vs. Programming


Lesson 3: Creating & Running Macros
Macros in Excel
Using Macros to Learn & Use Code
Using Macros to Learn Objects


Lesson 4: Visual Basic Editor
Application Switching
Menus - View, Tools, Help
Windows - Project, Property, Object, Immediate & Module
Code Conventions
Use Immediate Window
Run & Debug
Modules, Subs, Functions & Scope


Lesson 5: Interface Boxes
Message Boxes
Input Boxes
Forms - Dialog Boxes


Lesson 6: Variables


Lesson 7: Conditional Routines
Immediate IF Statements
IF-THEN Statements
Case Statements
Loops - FOR/NEXT, DO/WHILE, DO/UNTIL


Lesson 8: Introduction to Arrays


Lesson 9: Functions in Excel

VBA for Excel

Course Format: Public Course / Instructor-Led / Open Enrollment
School/Trainer: New Horizons Gainesville
Training Center(s)/Venue(s): Gainesville, United States
  V

Student will learn to create and run macros, use the VB editor, learn the use of Interface Boxes, variables and Conditional Routines.


Outline :
Lesson 1: Introduction
Applications Interfaces
Options
Setup


Lesson 2: Programming Languages
OOP & The Excel Object Model
Macros vs. Programming


Lesson 3: Creating & Running Macros
Macros in Excel
Using Macros to Learn & Use Code
Using Macros to Learn Objects


Lesson 4: Visual Basic Editor
Application Switching
Menus - View, Tools, Help
Windows - Project, Property, Object, Immediate & Module
Code Conventions
Use Immediate Window
Run & Debug
Modules, Subs, Functions & Scope


Lesson 5: Interface Boxes
Message Boxes
Input Boxes
Forms - Dialog Boxes


Lesson 6: Variables


Lesson 7: Conditional Routines
Immediate IF Statements
IF-THEN Statements
Case Statements
Loops - FOR/NEXT, DO/WHILE, DO/UNTIL


Lesson 8: Introduction to Arrays


Lesson 9: Functions in Excel

VBA for Excel

Course Format: Public Course / Instructor-Led / Open Enrollment
School/Trainer: New Horizons Denver
Training Center(s)/Venue(s): Denver, United States
  V

Student will learn to create and run macros, use the VB editor, learn the use of Interface Boxes, variables and Conditional Routines.


Outline :
Lesson 1: Introduction
Applications Interfaces
Options
Setup


Lesson 2: Programming Languages
OOP & The Excel Object Model
Macros vs. Programming


Lesson 3: Creating & Running Macros
Macros in Excel
Using Macros to Learn & Use Code
Using Macros to Learn Objects


Lesson 4: Visual Basic Editor
Application Switching
Menus - View, Tools, Help
Windows - Project, Property, Object, Immediate & Module
Code Conventions
Use Immediate Window
Run & Debug
Modules, Subs, Functions & Scope


Lesson 5: Interface Boxes
Message Boxes
Input Boxes
Forms - Dialog Boxes


Lesson 6: Variables


Lesson 7: Conditional Routines
Immediate IF Statements
IF-THEN Statements
Case Statements
Loops - FOR/NEXT, DO/WHILE, DO/UNTIL


Lesson 8: Introduction to Arrays


Lesson 9: Functions in Excel

VBA for Excel

Course Format: Public Course / Instructor-Led / Open Enrollment
School/Trainer: New Horizons Loveland
Training Center(s)/Venue(s): Loveland, United States
  V

Student will learn to create and run macros, use the VB editor, learn the use of Interface Boxes, variables and Conditional Routines.


Outline :
Lesson 1: Introduction
Applications Interfaces
Options
Setup


Lesson 2: Programming Languages
OOP & The Excel Object Model
Macros vs. Programming


Lesson 3: Creating & Running Macros
Macros in Excel
Using Macros to Learn & Use Code
Using Macros to Learn Objects


Lesson 4: Visual Basic Editor
Application Switching
Menus - View, Tools, Help
Windows - Project, Property, Object, Immediate & Module
Code Conventions
Use Immediate Window
Run & Debug
Modules, Subs, Functions & Scope


Lesson 5: Interface Boxes
Message Boxes
Input Boxes
Forms - Dialog Boxes


Lesson 6: Variables


Lesson 7: Conditional Routines
Immediate IF Statements
IF-THEN Statements
Case Statements
Loops - FOR/NEXT, DO/WHILE, DO/UNTIL


Lesson 8: Introduction to Arrays


Lesson 9: Functions in Excel

VBA for Excel

Course Format: Public Course / Instructor-Led / Open Enrollment
School/Trainer: New Horizons Colorado Springs
Training Center(s)/Venue(s): Colorado Springs, United States
  V

Student will learn to create and run macros, use the VB editor, learn the use of Interface Boxes, variables and Conditional Routines.


Outline :
Lesson 1: Introduction
Applications Interfaces
Options
Setup


Lesson 2: Programming Languages
OOP & The Excel Object Model
Macros vs. Programming


Lesson 3: Creating & Running Macros
Macros in Excel
Using Macros to Learn & Use Code
Using Macros to Learn Objects


Lesson 4: Visual Basic Editor
Application Switching
Menus - View, Tools, Help
Windows - Project, Property, Object, Immediate & Module
Code Conventions
Use Immediate Window
Run & Debug
Modules, Subs, Functions & Scope


Lesson 5: Interface Boxes
Message Boxes
Input Boxes
Forms - Dialog Boxes


Lesson 6: Variables


Lesson 7: Conditional Routines
Immediate IF Statements
IF-THEN Statements
Case Statements
Loops - FOR/NEXT, DO/WHILE, DO/UNTIL


Lesson 8: Introduction to Arrays


Lesson 9: Functions in Excel

VBA for Excel

Course Format: Public Course / Instructor-Led / Open Enrollment
School/Trainer: New Horizons Broomfield
Training Center(s)/Venue(s): Broomfield, United States
  V

Student will learn to create and run macros, use the VB editor, learn the use of Interface Boxes, variables and Conditional Routines.


Outline :
Lesson 1: Introduction
Applications Interfaces
Options
Setup


Lesson 2: Programming Languages
OOP & The Excel Object Model
Macros vs. Programming


Lesson 3: Creating & Running Macros
Macros in Excel
Using Macros to Learn & Use Code
Using Macros to Learn Objects


Lesson 4: Visual Basic Editor
Application Switching
Menus - View, Tools, Help
Windows - Project, Property, Object, Immediate & Module
Code Conventions
Use Immediate Window
Run & Debug
Modules, Subs, Functions & Scope


Lesson 5: Interface Boxes
Message Boxes
Input Boxes
Forms - Dialog Boxes


Lesson 6: Variables


Lesson 7: Conditional Routines
Immediate IF Statements
IF-THEN Statements
Case Statements
Loops - FOR/NEXT, DO/WHILE, DO/UNTIL


Lesson 8: Introduction to Arrays


Lesson 9: Functions in Excel

MS Excel with Macros and VBA

Course Format: Public Course / Instructor-Led / Open Enrollment
School/Trainer: AFCKS Technologies
Training Center(s)/Venue(s): Pune, India
  V

There are an estimated 400 million Excel users. Lesser amongst them are Excel power users and even lesser are those who has figured out how to effectively use the power of Automating Excel through Macros & Visual Basic for Application (VBA).

VBA education and development will help people to distinct themselves from others in any corporate world. Their theory of multiple intelligences by learning and ongoing development will put people always in a pivotal place of their career. Being able to transform New and Huge Amount of Data into Valuable Information’s with a Minimum Effort & Greater Accuracy is achievable using VBA & Macros for Microsoft Excel.

VBA EXCEL MACROS Workshop

Course Format: Public Course / Instructor-Led / Open Enrollment
School/Trainer: Microlines-Way to knowledge world
Training Center(s)/Venue(s): Bangalore, India
  V

Advance Excel & VBA/Macros Training in Excel
Learn in Professional way
Learn Concept with project oriented and small assignments.
Learn how to automate your excel routine jobs
Learn Reporting concepts
Learn Industry Exposure
Training by Real Time Experts
Our Training Includes:
Advance Excel
1. Data analysis and data management using Excel 2003/2007.
A) Advanced Data Analysis: - Pivot tables & Reports, Solver function, Scenarios, Data tables Data Analysis, Data validation, Formatting and conditional formatting
B) Data Management: - Organizing Data, Sorting and Filtering, Grouping and outlining data, Data subtotaling, Subtotaling, grouping and filtering data, advanced functions in Excel, Lookup functions, Mathematical functions, Text, database functions and Data consolidation.
VBA/Macros Training in Excel
Introduction to VBA, VBA Procedures, User Forms, Creating Multiple Pivot Table, Modifying Pivot Table, Excel’s Events, Interacting with Other Applications, Etc.
Course Benefits:
?Improve the existing skill sets of pr... [Read More]

Advance Excel and VBA Workshop

Course Format: E-learning
School/Trainer: Arsalan
Training Center(s)/Venue(s): Hyderabad, India

This opportunity is for those who are busy with their job and want a quick grasp of excel 2007 and VBA. Get an online sreencast session and be ahead in your corporate environment.

Advance Excel and VBA Workshop

Course Format: Public Course / Instructor-Led / Open Enrollment
School/Trainer: epaathshaala
Training Center(s)/Venue(s): Hyderabad, India

Advance tips and tricks in excel.
Customizing excel environment
Using advance features like pivots, advance filter, conditional formatting, 3d lookups, nested ifs.....

Word 2007: VBA Programming

Course Format: E-learning
School/Trainer: ComputerPREP
Training Center(s)/Venue(s): Tempe, United States

This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, is designed to give experienced Word users proficiency in using the Visual Basic Editor (VBE). Students will learn how to build applications, debug code, automate data entry, and merge data files. They will also learn how to create forms, build tables, secure information, and share data.

Excel 2007: VBA Programming

Course Format: E-learning
School/Trainer: ComputerPREP
Training Center(s)/Venue(s): Tempe, United States

This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.

Access 2007: VBA Programming

Course Format: E-learning
School/Trainer: ComputerPREP
Training Center(s)/Venue(s): Tempe, United States

This ILT Series course, rated 4.9/5.0 in overall quality by ProCert Labs, is designed for experienced Access 2007 users who want to learn ActiveX Data Objects, control structures, and the basics of VBA programming.

VBA

Course Format: E-learning
School/Trainer: ComputerPREP
Training Center(s)/Venue(s): Tempe, United States
  V

This ILT Series Microsoft VBA Programming is designed for the beginning programmer to write procedures using the VBA language. The procedures students will create with this book will allow them to customize the applications included in Microsoft Office so that the applications work the way you want them to work. The manual is designed for quick scanning in the classroom and filled with interactive exercises that help ensure student success.

Objectives:

Create event and macro procedures
Use the Object Model in different Office Applications
Use the Select Case and Msgbox functions
Use advance repetition structures like Do Loop, Left, Right, Mid, and Instr functions
Use advance automation and error trapping

Financial Analysis Systems, using VBA for Excel

Course Format: Public Course / Instructor-Led / Open Enrollment
School/Trainer: UTS Continuing Professional Education
Training Center(s)/Venue(s): Sydney, Australia
  V

An Excel short programming course for professionals in the finance and accounting professions looking for better automation and control over important financial information in an increasingly complex environment. VBA macro and programming techniques are taught from the ground up. On completion students should be able to:

* write macros, menus and programs in VBA to intermediate level
* construct robust macro-driven models
* construct macros that interact with an end user via dialog boxes, message boxes and standard VBA input commands
* construct macros that can access, modify and transfer data within workbooks
* construct macros that import data from external sources
* write programs for the automatic validation of inputs to a menu driven financial Data Bank and extract management reports automatically
* design debugging, error trapping and preventative error controls
* deal with catastrophic occurrences and plan for recovery

This course builds programming skills from the ground up. Macros and menus are introduced and simple progr... [Read More]

Advanced Excel Macros VBA Workshop

Course Format: Public Course / Instructor-Led / Open Enrollment
School/Trainer: GITS Academy
Training Center(s)/Venue(s): Bangalore, India
  V

We take this opportunity to introduce ourselves as ‘GITS Academy?a Leading name in Corporate IT Training.
We provide training for analytical software like Advance Excel and SAS for Analytics.
Our Advance Excel Training Includes:

1. Data analysis and data management using excel.
A) Advanced Data Analysis: - Pivot tables & Reports, Goal seek, Solver function, Scenarios, Data tables Data Analysis, Data validation, Formatting and conditional formatting
B) Data Management: - Organizing Data, Sorting and Filtering, Grouping and outlining data, Data subtotaling, Subtotaling, grouping and filtering data, advanced functions in Excel, Lookup functions, Mathematical functions, Text, database functions and Data consolidation.

2. VBA/macros training in Excel.

Introduction to VBA, VBA Procedures, User Forms, Creating Multiple Pivot Table, Modifying Pivot Table, Excel’s Events, Interacting with Other Applications, Etc.

3. MS Access.
OOPS, Advanced programming Concepts, Active X Controls, Conversions, Automations, ActiveX Dat... [Read More]

MS Excel And VBA

Course Format: Public Course / Instructor-Led / Open Enrollment
School/Trainer: GITS Academy
Training Center(s)/Venue(s): Bangalore, India
  V

We take this opportunity to introduce ourselves as ‘GITS Academy?a Leading name in Corporate IT Training.
We provide training for analytical software like Advance Excel and SAS for Analytics.

Our Advance Excel Training Includes:

1. Data analysis and data management using excel.

A) Advanced Data Analysis: - Pivot tables & Reports, Goal seek, Solver function, Scenarios, Data tables Data Analysis, Data validation, Formatting and conditional formatting
B) Data Management: - Organizing Data, Sorting and Filtering, Grouping and outlining data, Data subtotaling, Subtotaling, grouping and filtering data, advanced functions in Excel, Lookup functions, Mathematical functions, Text, database functions and Data consolidation.

2. VBA/macros training in Excel.
-
Introduction to VBA, VBA Procedures, User Forms, Creating Multiple Pivot Table, Modifying Pivot Table, Excel’s Events, Interacting with Other Applications, Etc.

3. MS Access.
-
OOPS, Advanced programming Concepts, Active X Controls, Conversions, Aut... [Read More]

Pages: ...4 5 6 7 8 9 10 11


Find VBA training courses, certificates, diplomas and degrees in Countries:



Australia - Canada - India - Indonesia - Ireland - Malaysia - Pakistan - Philippines - Singapore - South Africa - United Arab Emirates - United Kingdom - United States



Tips:
Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.



Visual Basic
VBA
- Online/E-learning -
VBA
Ask for Training
Add Courses