TypeClassroom Training
REGISTER
VBA for Excel training

Overview

Audience & Prerequisites

Course Outline

Schedule & Fees

Certification

VBA for Excel

VBA stands for Visual Basic for Applications an event-driven programming language from Microsoft that is now predominantly used with Microsoft office applications such as MS Excel, MS-Word, and MS-Access.

It helps techies to build customized applications and solutions to enhance the capabilities of those applications. The advantage of this facility is that you NEED NOT require visual basic installed on our PC, however, installing MS-Office will implicitly help in achieving the purpose.

You can use VBA in all office versions, right from MS-Office 97 to MS-Office 2013 and also with any of the latest versions available. Among VBA, Excel VBA is the most popular. The advantage of using VBA is that you can build very powerful tools in MS Excel using linear programming. VBA Programming is very much useful for the persons Vhuge amount of data and it will be a convenient tool for them to customize an Excel Worksheet. Knowledge in Visual Basic Programming will be an added advantage.

Objectives

  • Understand what VBA and How it Works.
  • Accessing VBA Editor
  • Making Comments in VBA
  • VBA Variables, Operators & Constants
  • Input Box & Message Box Function.
  • Implementing Decisions and Loops
  • String and string Functions
  • Date & Date Functions.
  • VBA Excel Objects
  • Functions & Sub Procedures
  • VBA Text Files
  • VBA Useforms
  • Event Driven Programming

Intended Audience

  • This course is for persons who are using Excel in their office on day to day basis. This Course is going to help them definitely to understand the concepts of VBA Macro. A well-defined course curriculum along with highly experienced faculty members will teach the subject matter as simple as possible.

Pre-requisites

  • Though it is not needed however prior knowledge in Visual Basic is certainly an added advantage. Person should also be quite familiar with Excel features and options.

 

Course Outline                                                  Duration: 2 Days

  1. An Introduction to VBA
  • Understand what VBA and How it Works.
  • Accessing VBA Editor
  • Making Comments in VBA
  • VBA Variables, Operators & Constants
  • Input Box & Message Box Function.
  • Implementing Decisions and Loops
  • Use of Switch case Statement
  1. Using Strings & Date
  • Use of String Functions
  • Handling Date Related Data and useful Date Functions
  1. Arrays
  • Implementation of Array
  • Array Declaration and assigning values in an Array
  • Multi-Dimensional Array
  • Use of Redim & Preserve Keyword
  1. Function and Sub Procedures
  • Implementation of Sub Procedures
  • Implementation of Functions
  • Passing Parameters to a Sub Procedure or a Function
  • Calling and executing the Sub Procedure or the Function
  1. File Handling
  • File System Objects
  • Using Write Command
  • Writing macro implementing File Handling Concepts.
  1. Exception Handling
  • Understanding the Concept of Exception
  • Exception Handling Technique
  • On Error Goto Statement

Please write to us at [email protected] & contact us at +91-9870480053 for the course price & certification cost, schedule & location

Drop Us a Query

For more info kindly Contact Us.

VBA for Excel training courses and certification gurgaon gurugram haryana VBA for Excel training institutes in gurgaon VBA for Excel training and certification VBA for Excel training in delhi VBA for Excel  pmp training VBA for Excel  certification fees VBA for Excel training with exam mercury solutions VBA for Excel training VBA for Excel certification cost VBA for Excel certification path VBA for Excel certification online VBA for Excel certification salary VBA for Excel certification cost in india 2019 who should do VBA for Excel certification VBA for Excel certification quora VBA for Excel certification cost in india 2018 VBA for Excel  certification VBA for Excel training gurgaon VBA for Excel  certification cost VBA for Excel  full form VBA for Excel certification india VBA for Excel certification online VBA for Excel certification training VBA for Excel certification pune VBA for Excel certification in delhi