VBA Training

  • Advanced Excel

    Smiley face

    Advanced Excel Course Microsoft Excel is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It features calculation, graphic tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office. GITA's Microsoft Excel Advanced Training is suitable for those who wish to progress to the most complicated functions and features of Excel enhance their Spreadsheet Skills for the best jobs in corporate with a sound working knowledge of Excel.

  • Course Content

    Duration : 1 Months | Classes: Mon-Fri, 1½ Hrs./day

    • Introduction to VBA

      • Introduction to Programming.
      • VBA Overview and the IDE.
      • Quick Review of Macros.
      • Working with Macros.
      • How to use Visual Basic Editor (Programming Environment).
      • Advantages of VBA
      • An easy-to-use and versatile language.
      • Integrated with off-the-shelf products.

      • Understanding The VBA Editor, Module and Procedures
      • The Visual Basic Editor.
      • Parts of the VBA Editor.
      • Modules and Macros.
      • About VBA Forms, Sub Procedures & Modules.
      • Creating Forms.
      • Using Controls and their Properties.
      • Running VBA Forms in Excel.

      • VBA Syntax and Grammar
      • Objects – The Grammar.
      • Using Properties and Methods.
      • Understanding Parameters.
      • The Object Browser.
      • Understanding object hierarchy.
      • Tools for better coding.
      • Moving to Other Cells.
      • Editing Specific Cells.

      • Variables, Arrays & Constants
      • Using the Immediate Window.
      • Gaining greater control through the immediate window.
      • Formatting Cells.
      • Using Variables.
      • Constants.
      • Object Variables.
      • Dimensioning and usage of variables.
      • Displaying data and obtaining data from the user.

      • Storing data in variables
      • How and when to declare variables.
      • Selecting data types.
      • Fixed and dynamic arrays.
      • Constants.

      • Control Structure and Program Flow
      • IF (ElseIf, Else).
      • Select Case().
      • For Next Loop.
      • Each Loop().
      • Do Until Loop and Do While Loop.
      • With, End With.
      • Nesting Code.
      • Building procedures & User Interface
      • Creating Sub and Function procedures.
      • Calling procedures.
      • Passing arguments to procedures.
      • Communicating with the user through the message box.
      • Gathering user information with the input box.
      • Utilizing the File Dialog object and Dialogs collections.

      • Creating customized dialogs with User Form objects
      • Command buttons & List and Combo boxes.
      • Labels, Option buttons, Check boxes, Text boxes, Frames.
      • Adding more functionality with advanced ActiveX control.

      • Fonts & Background
      • Using Font Property in cells.
      • Using Various Background Properties in Excel VBA.
      • Creating a Counter & String Handling.
      • Using Left, Right, Instr, Mid and Len Functions in VBA.
      • Range Selection and Manipulation.

      • Objects and Collections
      • Workbook and Worksheet Object.
      • Range Object and Cell Properties.
      • Methods and Properties.
      • Assigning Objects.
      • Using Name Arguments.

      • Array
      • What is Array & why use array.
      • Declaring an Array.
      • Sorting Data in Array.
      • 2-Dimention Array, Dynamic Array, UBourd.
      • Storing Data in a range of an Array Elements.
      • Using various array functions.

      • Functions
      • Using Excel Worksheet Functions in VBA.
      • VBA Functions.
      • User-Defined Functions.
      • Adding Help to User Defined Functions.
      • Declaring Variables in User Defined Functions.
      • Using Ranges in User Defined Functions.
      • Creating and Managing an Add-in for User Defined Functions.

      • Advanced Techniques
      • Internet and Excel. Copy Hyperlinks and Text from a webpage to Spreadsheet Interacting with Other Office Applications. Communicating with Word and PowerPoint using Excel VBA Running SQL Queries within Excel Environment | Modifying Menus and Toolbars. Simplifying user interaction with the Command Bar object. Adding and removing CommandBarControl objects.

        Unique Features

        • Real Time Training with experienced, qualified and friendly trainers
        • Job Oriented training will help you in companies.
        • Free PD Class & Placement Offer for various courses.
        • Fully WiFi enabled Campus and Class Rooms.
        • Weekend Batch Facility for working persons.
  • Scope and Opportunities

    Excel VBA (Visual Basic for Applications) is the name of the programming language of Excel. By Creating a VBA Script you can automate tasks in Excel. The Functons created in VBA are also called Macros. There is a huge demand of VBA Programmers in industry. Various Job options in this course are:

    • Sr. MIS Executive
    • Data Analyst
    • VBA Developer
    • Sr. VBA Developer
    • Programmer