ADVANCED MS EXCEL: MACROS-VBA

DESCRIPTION

VBA Macros course is very important in financial industry, because its integration into Microsoft Office especially excel. You will probably need to use Advanced excel VBA macros if you go into a financial or insurance company. Therefore, knowing how to use VBA is a definite advantage for your future career.

With Microsoft Excel one can build powerful automated business tools quickly and minimum cost. If you sit in front of a computer screen all day creating reports in Microsoft Excel, you know the power of this VBA software package. But if you aren't using macros yet, you don't know the half of it. Macros automate common and repetitive keystrokes that can be use Excel to create and edit spreadsheets. By reducing the number of keystrokes required to perform common commands, macros speed up your production and reduce the time you have to spend staring at an electronic spreadsheet each day.

At the end of the course the participant would be able to write your own functions and procedures, design forms and working with add-ins, fit Excel for your professional use, process data (input, sort, filter, group and subtotals), activate advanced functions, make use of charts, build routines, produce shortcuts and buttons, optimize work and shorten the response time for complex tasks.

OBJECTIVE

• Write macros to automate routine work.
• Create user defined functions and procedures.
• Design and use forms for data entry and maintain database.
• Create add-ins to deploy at client machines.
• Create reports.

PARTICIPANT

• Any Graduates who is looking better career in this field.
• Experience professionals who wants to upgrade their knowledge.
• Undergraduates, Graduates, M.com, MBAs and working professionals aspiring for a Career.

LEARNING PROCESS

Concept Learning

Practical Implementation

Practical Assessment

COURSE OUTLINE

Intro Of VBA Macros

Recordings Macro

Working With VBA Editor

• Understanding Editor's components

VBA Program Concept

Variable Type And Declaration

ï‚· Declaring Variables

ï‚· Data Types

ï‚· Constants

ï‚· Simple Input and Output with VBA

ï‚· Collecting User Input with Input Box ()

ï‚· Output with Msg Box ()

ï‚· Manipulating Strings with VBA Functions

ï‚· Fun with Strings

Decisions Making With Operator

ï‚· Logical Operator

ï‚· Arithmetic Operator

ï‚· Relational Operator

ï‚· Assignment Operator

Repeating Actions With A Loops

• Loops and Arrays

o    Arrays

o    One-Dimensional Arrays

o    Multi-Dimensional Arrays

o    Dynamic Arrays

• Looping with VBA

o    Do Loops

o    For Loops

Procedures And Events

• VBA Procedures
• Event Procedures
• Private, Public, and Procedure Scope
• Sub Procedures
• Simple If
• If. Else
• ladder if
• Nested. If
• Select Case
• Date and Time Functions

User Defined Functions

Developing Add In

User Forms And GUI

ï‚· Designing Forms with VBA

ï‚· Adding a Form to a Project

ï‚· Components of the User Form Object

ï‚· Adding ActiveX Controls to a Form

ï‚· Showing and Hiding Forms

ï‚· Modal Forms

ï‚· Designing Custom Dialog Boxes Using Forms

Sort And Filter, Pivot Tables And Pivot Charts

File Handling

Input Validation

Validation with the Input Box () Function

Working With Objects

ï‚· Top-Level Excel Objects

ï‚· The Application Object

ï‚· The Workbook and Window Objects

ï‚· The Worksheet Object

ï‚· The Range Object

Error Handling, Debugging And Basic File I/O

ï‚· Error Handling

ï‚· Using the On-Error Statement

ï‚· Debugging

ï‚· Break Mode

ï‚· File Operations

VBA CHARTS

ï‚· The Chart Object

ï‚· Accessing Existing Charts

ï‚· Manipulating Charts

ï‚· Creating Charts

ï‚· Chart Events

INSTRUCTOR

SOLID CORPORATION TRAINER TEAM

FACILITIES

Facilities of course :

ü  Certificate,

ü  Hand Out,

ü  Quality Training Kit ,

ü  Quality Training Material (Hardcopy And Softcopy)

ü  Convenient Training Facilities At Stars Hotel, Lunch & 2 X Coffee Breaks,

ü  Souvenir.