Request Call Back
Please Contact Us
  • +91-80-42188793
  • enquiry.itas@gmail.com

FLAT Rs 45,000 OFF ON DIPLOMA IN BUSINESS ANALYTICS & DATA ANALYTICS FOR JUST Rs. 65,000* includes SQL Server, R Programming and Python | 20% OFF on all Courses | 15% OFF on all Packages | On Registering any Courses | Batches Starting From September 2019 | Register Before 30th August |

>

VBA Macros

Fees : Rs 9,000 Only

Duration : 24 Hours

Enroll Now

We offer a detailed course of Excel Macros, which is very predominant in the Analytic Industry. Low development cost and extensive flexibility in building and maintaining complex Excel Tools is the major highlight of this language. Knowledge of VBA Macros is one of the sought-after skills in the current industry.

Prerequisites:

Basic Knowledge of Computers and Basic Excel skills. No need of any previous Programming Knowledge

Course Objectives:

After the course, you will be able to:

  • Use the essential tools and operations for VBA
  • Develop custom worksheet functions and user-oriented applications

Course Contents

  • What is VBA?
  • What can you do with VBA
  • Advantages
  • Disadvantages

  • Components of VBE
  • Customizing the VBA Environment

  • Object hierarchy
  • Referring to Objects
  • Object Properties and Methods

  • Understanding Sub v/s Functions
  • Writing Simple VBA Macros
  • Working with Subs and Functions

  • Using Comments in VBA Macros
  • Variables, Constants and Datatypes
  • Understanding Scope of Variables
  • Assignment Statements Using Labels and Go to Statements

  • Introduction to Arrays
  • Static Arrays
  • Dynamic Arrays
  • One Dimensional Arrays
  • Two Dimensional Arrays
  • Multi-dimensional Arrays

  • If
  • If End If
  • If Else EndIf
  • Elseif Ladder
  • Nested If Conditions
  • Select Case Statements

  • For Loops
  • Do Loops

  • Using Built-In VBA Functions
  • Using Worksheet Functions in VBA
  • Using Custom Functions

  • Working with Worksheet Events
  • Working with Workbook Events

  • Creating A UserForm
  • Using Controls in UserForms
  • Understanding Events used in UserForms
  • Modifying the UserForms
  • Inserting & Modifying of the Data from UserForms

  • Types of Errors
  • Using Breakpoints
  • Debugging Techniques

  • UsingMsgBox Function
  • UsingInputBox Function
  • Working with FileDialog
  • Working GetOpenFilname Method
  • Working GetSaveAsFilename Method

  • Working with Charts in VBA
  • Working with Pivot Tables and Charts in VBA

iTAS (iTech Analytic Solutions) is a complete Analytics Solution provider with. unparalleled value-optimizing Information Insight to client organizations through the use of cutting-edge, customized reporting systems, analytical models, and database applications

iTAS (iTech Analytic Solutions) provides data driven business decisions with quantitative modeling expertise & deep understanding of business needs and state-of-the-art technologies to solve complex problems.

Useful Links

Support

Contact Us

  • +91-80-42188793
  • enquiry.itas@gmail.com
  • Branch 1:No. 9, 1st Floor, 8th Main, 9th Cross, SBM Colony, Brindavan Nagar,Mathikere, Bengaluru, Karnataka, India - 560054
  • Branch 2:#403, 11th Cross,19th Main, 1st Block, Rajajinagar, Bengaluru - 560 010

Copyright ©2018 iTAS. All Rights Reserved

Brochure download