Professional Training &
100% Projects Based Training

Be Professionals From Professionals               Only Professionals can Make u Professional
  • Part Time
  • Duration           :      6 Weeks
  • Class                :      1.30 Hrs Daily
  • Days                 :      Mon-Fri.
  • Half Time
  • Duration           :      3 Weeks
  • Class                :      3.00 Hrs Daily
  • Days                 :      Mon-Fri.
  • Full Time
  • Duration           :      2 Weeks
  • Class                :      4.30 Hrs Daily
  • Days                 :      Mon-Fri.

Excel VBA MACRO Training courses in West Delhi offers below course content

MODULE 1

What is VBA & HOW VBA WORKS WITH EXCEL

  • Quick Review of Macros
  • Introducing the Visual Basic Editor
  • Uses of record Macros
  • Understanding and creating modules

MODULE 2

PROGRAMMING CONCEPTS

  • VBA Sub and Function Procedures
  • How to create a message box
  • Write a Program to update and retrieve information using Input Box
  • Understanding and using Select Case statement
  • How do I define a variables and Rules for defining a Variables Name and Type
  • Creating And using Variables
  • Working with range Objects
  • How to save and Protect Modules

MODULE 3

Decision Makers

  • If……Then……Else
  • If……Then……ElseIf……If

MODULE 4

Other Kinds of Loops

  • Working with Do While u. Loop Procedure
  • Do…… Until Loop and Do…… Loop Until
  • Do……While loop and Do…… Loop While
  • For each…… Next
  • For……Next

MODULE 5

Workbook Obects Create or Add  Single and Multiple Workbooks

  • Workbook Save and Save AS
  • Open Single and Multiple Workbooks
  • Close Specify and Multiple Workbooks
  • Activate From one workbook to another Workbook
  • Open Workbook from Specific Path
  • Get Workbook Name and Paths
  • Hide and Unhide for Single and Multiple Workbooks
  • Protect and Unprotect Worksheets

MODULE 6

Worksheet Objects insert a single and Multiple Worksheets

  • Delete Specific and multiple worksheets
  • Get Count of Worksheets
  • Select a Specific and all Worksheets
  • Get All Worksheets Name
  • Hide and Unhide  For Single and Multiple Worksheets
  • Rename for Single and Multiple Worksheets
  • Protect and unprotect worksheets
  • Sort and Move worksheets
  • Calculate entire worksheet
  • Using VBA and worksheet Function

MODULE 7

Cell objects insert Single and multiple Row , Column and Cells

  • Delete Single and Multiple row, Column and Cells
  • Get Range or Address of Cell and Selection
  • Navigate from one Cell to another Cell
  • Select specific Range, Cell, Rows and Column
  • Types of Selection and Offset  method
  • Insert Function In cell

MODULE 8

Reading and Writing Arrays

  • Defining Arrays
  • Arrays as Outputs
  • Arrays as inputs
    • The Arrays as a Collection
    • The Array as an Array

MODULE 9

Form Controls and User Forms (Create and Design an user Form)

  • Working With User Forms & User Forms Events Like List Box, Combo Box, Option Buttons, Check Box, Text Box, Labels, Command Button, Toggle Button.
  • How To Create Dynamic Dashboard On User Form With Different Controls
  • How To Link Various User Form With Each Other To Create A Complete Interface Between User And System

MODULE 10

Session – 8 VBA Programming Functions

  • Create a Sum Functions
  • Create Multiply Function
  • Create Count Function
  • Extract Text & Number
  • Proper Function
  • Vlookup Function
  • Square root Function
  • Public or Private function

MODULE 11

Excel VBA Power Programming for VBA Macros

  • Working with Dynamic Ranges. Protecting worksheets, Cells and Ranges. Working with Multiple Files. Opening &saving Files
  • How to Analyze Data On multi Worksheets And Build Summary sheets
  • how to Access the Windows File and Folder System to Open and Close Workbooks
  • How to protect your code Against Errors
  • How to use Excel And VBA to Create Basic Dash Boards
  • How to create Your own custom Business Worksheet Function in VBA
  • How to create Basic Report Generation Tools Using Excel VbA, Microsoft Word and PowerPoint
  • How to use the Excel Visual Basic Macro record Excel Tasks in VBA And then Interpret the code

MODULE 12

Connection between Excel VBA & other platforms

  • How To Establish Connection Between VBA And Power Presentation To Create Power Point Through VBA
  • How To Establish Connection Between Excel Vba And Outlooks Through Vba
  • How To Establish Connection Between Excel Vba And MS Word Through Vba

Vba Training center in West Delhi, Uttam nagar. Best certified computer course curriculum for professional learning institute near Dwarka, Uttam Nagar, Jankapuri, Tilak Nagar, Subhash Nagar, Tagore Garden, Rajouri Garden, Ramesh Nagar, Moti Nagar, Kirti Nagar, Shadipur, Patel Nagar, Rajendra Place, Karol Bagh, Jhandewalan, Ramakrishna Ashram, Connaught Place, vikaspuri, najafgarh, Delhi Cantt, Dhaula Kuan, Palam Colony, Palam Villag, Dabri, Hari Nagar, Fateh Nagar, Raja Garden, Punjabi Bagh, Shivaji Park, Paschim Vihar, Peeragarhi, Inderlok, Netaji Subhash Place, Pitampura, Rohini, Chandni Chowk, New Delhi, East Delhi, North Delhi, West Delhi.

Copyright © Computec Professionals Group