Corporate Training in Microsoft Excel VBA , Level 3 (2003, XP, 2003/2007)
Training
In Mumbai
Price on request
Description
-
Type
Training
-
Location
-
Duration
1 Day
Facilities
Location
Start date
Mumbai
(Mahārāshtra)
See map
Chinoy Mansion, First Floor, Block #2, Opp. St.Stephen's Church, Warden Road,, 400036
Start date
On request
Mumbai
(Mahārāshtra)
See map
OPriya Bldg.,1st Floor, Dr. Peter Dias Road, Near Mehboob Studio,, 400050
Start date
On request
Reviews
Have you taken this course?
Course programme
This course will help to write macros in Excel using programming
language Visual Basic Application (VBA). Recorded macro can edited to
customize it to fulfill our requirement and one can directly go for
coding to accomplish the required tasks. One can write his own functions
and procedures, design forms and working with add-ins.
Program Objectives
After completion of this program, the participants will be able to the following
Write macros to automate routine work
Create functions and procedures
Design and use forms for data entry
Create add-ins to deploy at client machines
Create simple reports
Audience
Program is scheduled for Advanced Microsoft Excel users. VBA is a programming language, requires aptitude for programming.
Prerequisites
Participants attending this training should be familiar with the advanced operations in Microsoft Excel.
Day-wise Break-up
Day
Module
Topic
Day 1
Module 1
Understanding Security Levels
Day 2
Module 2
Functions
Module 3
Recording Macros
Module 4
The Visual Basic Editor
Module 5
Programming Fundamentals
Module 6
Excel Object Model
Module 7
User Forms
Module 8
Working with other applications
Module 1: Understanding Security Levels
Why security
Security levels and its meaning
Module 2: Functions
What is Function and Subroutine
Writing Functions using VBA Editor
Calling function in other workbook
Module 3: Recording Macros
Recording and running macro
Storing macro in different books
Creating buttons and assigning macro to it
Creating My Menu
Module 4: The Visual Basic Editor
Editing macros using VBA Editor
Understanding the project explorer
Exploring windows properties
Modifying code in code window
Debugging code
Module 5: Programming Fundamentals
Variables, data types and constants
Arrays
Object Variables
Conditional structures (If .... Then, Select Case)
Logical Operators
Looping constructs (For loops, Do loops, while... Wend)
Built-in functions
Creating Subroutines
Module 6: Excel Object Model
Working with objects - properties, events and methods
Application objects
Workbook objects, Worksheet objects and Range objects
Charts objects
Pivot table objects
Module 7: User Forms
Creating forms
Form events
Creating custom menus and toolbars
Creating Add-ins
Module 8: Working with other applications
Working Word, PowerPoint and other applications.
Program Objectives
After completion of this program, the participants will be able to the following
Write macros to automate routine work
Create functions and procedures
Design and use forms for data entry
Create add-ins to deploy at client machines
Create simple reports
Audience
Program is scheduled for Advanced Microsoft Excel users. VBA is a programming language, requires aptitude for programming.
Prerequisites
Participants attending this training should be familiar with the advanced operations in Microsoft Excel.
Day-wise Break-up
Day
Module
Topic
Day 1
Module 1
Understanding Security Levels
Day 2
Module 2
Functions
Module 3
Recording Macros
Module 4
The Visual Basic Editor
Module 5
Programming Fundamentals
Module 6
Excel Object Model
Module 7
User Forms
Module 8
Working with other applications
Module 1: Understanding Security Levels
Why security
Security levels and its meaning
Module 2: Functions
What is Function and Subroutine
Writing Functions using VBA Editor
Calling function in other workbook
Module 3: Recording Macros
Recording and running macro
Storing macro in different books
Creating buttons and assigning macro to it
Creating My Menu
Module 4: The Visual Basic Editor
Editing macros using VBA Editor
Understanding the project explorer
Exploring windows properties
Modifying code in code window
Debugging code
Module 5: Programming Fundamentals
Variables, data types and constants
Arrays
Object Variables
Conditional structures (If .... Then, Select Case)
Logical Operators
Looping constructs (For loops, Do loops, while... Wend)
Built-in functions
Creating Subroutines
Module 6: Excel Object Model
Working with objects - properties, events and methods
Application objects
Workbook objects, Worksheet objects and Range objects
Charts objects
Pivot table objects
Module 7: User Forms
Creating forms
Form events
Creating custom menus and toolbars
Creating Add-ins
Module 8: Working with other applications
Working Word, PowerPoint and other applications.
Corporate Training in Microsoft Excel VBA , Level 3 (2003, XP, 2003/2007)
Price on request