Corporate Training in Microsoft Excel VBA , Level 3 (2003, XP, 2003/2007)

Training

In Mumbai

Price on request

Description

  • 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

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

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.

Corporate Training in Microsoft Excel VBA , Level 3 (2003, XP, 2003/2007)

Price on request