Introduction of VBA: VBA Macro Programming, VBA Macros, Apply the VBA Macro, Benefit and limitation of VBA Macro, Type of VBA Macro, Display of Developers Tab and VB Editor, Introduction to Macro Recordings: Using the Excel Macro Recorder, Macro Security, Recording Macro, Naming Macro, Executing Macro, Saving and Editing Macro Various Key Board Short Cuts related to VBA Macros, Working In the Visual Basic Editor: Project Explorer, Properties window, Object Browser, Standard Module and Sheet Module

Defining Variables to Macro, Variable Naming rules, Declaring, Initializing Variables, Option Explicit, Object Variables, Different Types of Variables, Introduction of Message Box in Macro, Input Box in Macro, Use of if, and Else conditions, And /OR conditions,

Writing the Excel Formulas in to the Program, Find out the better solution to write the formulas in VBA, writing of the basic formulas, complex formulas, Logical formulas and Lookup formulas in VBA, Other useful formulas to be write in Class, Types of Errors: Design Errors, Compile Errors, Runtime Errors, Logical Errors, how to Debug the Errors.

Form Control vs Active X control, Accessing Your Macros through the User Interface, VBA User Forms: Discussion on VBA User Forms, What are User Forms, Why to Create User Forms and How to create User Forms.

Scope of VBA Sub, End Sub, and Function Procedures, worksheet Functions Working with Range Objects: Properties and Methods of Ranges – Range referencing, selection, Active cell, cells and offset properties, resize ranges, value, formula and text properties, clear, delete, copy, paste and format ranges, Filters, special cells method, union and intersect ranges, current region property, working with dynamic ranges, last cell, last row and last column Workbooks and Worksheets: The Workbooks Collection, Getting a Filename from a Path, Files in the Same Directory, Overwriting an Existing Workbook, Saving Changes, The Sheets Collection, Worksheets, Copy and Move

Detailed discussion on User Defined Function, What is Use of Defined Function, and How to create any Function OR Formula which is not available in Excel and you want it to work for you by the help of Macro,

Establishing the Connection, Late Binding, Early Binding, Interacting with Outlook: Drafting and sending mails via Outlook, Adding the recipients’ mail address and subject lines, Adding ranges, charts, tables, text in the mail body, Adding attachments.

 

Enquiry form

Claim 100% Job Placement Guarantee. Fill Now!

    Recently Placed Students

    Dharmender
    Dharmender
    Ozdocs India Pvt. Ltd - As a Android developer
     
    Vikas
    Vikas
    PAN India - As a Android developer
     
    Kedarnath
    Kedarnath
    Tata Steel - As a HR executive
     
    Harshit
    Harshit
    Mobulous Technologies - As a Android developer
     
    Gaurav
    Gaurav
    Gaursons India Limited - As a HR executive
     
    Himanshi Dabral
    Himanshi Dabral
    Enthuons Technologies Pvt.Ltd. - As a PHP developer
     
    Gaurav
    Gaurav
    Wing technology pvt. Ltd - as a Digital Marketing executive
     
    Geetanjali
    Geetanjali
    Prakash Pvt. Ltd - as a HR executive
     
    Nitesh
    Nitesh
    Sprax IT solutions - as a PHP developer
     
    Chandan
    Chandan
    Agami technology Pvt . Ltd - as a PHP developer
     
    Shivram Kashyap
    Shivram Kashyap
    Tangle solutions Pvt . Ltd. - as a PHP developer
     
    Anjali
    Anjali
    Wingshield technology pvt. Ltd - Placed as a HR executive
     
    Satyam
    Satyam
    Learnix Education Pvt. Ltd. - Placed as a PHP developer
     
    Uttam
    Uttam
    Mobile Coderz technologies Pvt Ltd . - As a Digital Marketing Executive
     
    Banti
    Banti
    Spark It Solutions - As a Digital Marketing Executive
     
    Komal
    Komal
    Spark It Solutions - As a Digital Marketing Executive
     
    Shahbaz Ali
    Shahbaz Ali
    Tekshapers software Pvt Ltd - As a PHP developer
     
    Manish
    Manish
    Deftsoft - As a PHP developer
     
    Ujwal
    Ujwal
    Magic ED tech iT company - As a PHP developer
     
    Kamal
    Kamal
    Excellence Technologies Pvt Ltd - As a PHP developer
     
    Kamal nagar
    Kamal nagar
    Mobile Coderz technologies Pvt Ltd . - As a PHP developer
     
    Niketa
    Niketa
    Wingshield technology pvt. Ltd - As a HR executive
     
    Abhinav
    Abhinav
    Cumint private limited - As a PHP developer
     
    Harendra
    Harendra
    Mathur Associates - As a HR executive
     
    Sagar
    Sagar
    Theos food pvt Ltd - As a HR executive
     
    Dinesh
    Dinesh
    Sparx IT solutions Pvt Ltd . - As a PHP developer
     
    Pragya pandey
    Pragya pandey
    Fusion Techware Pvt . Ltd . - As a HR executive
     
    Puja Grewal
    Puja Grewal
    Euclion Energy Pvt .Ltd - As a HR executive
     
    Sutosh Prasad
    Sutosh Prasad
    Aibeet Systems Pvt . Ltd - As a PHP developer
     
    Richa Nanda
    Richa Nanda
    DIMR - As a HR generalist
     
    Arvind
    Arvind
    Compass Group - As a HR executive
     
    Rohit
    Rohit
    Codefire technologies Pvt .ltd. - As a PHP developer
     
    Hritik
    Hritik
    Lean port software Pvt Ltd. - As a PHP developer
     
    Govind
    Govind
    Lean port software Pvt Ltd. - As a PHP developer
     
    Muskan
    Muskan
    Lean port software Pvt Ltd. - As a PHP developer
     
    Devendra Gupta
    Devendra Gupta
    Hata services - As a PHP developer
     
    Poonam
    Poonam
    Aresedge Technology Pvt Ltd . - As a PHP developer
     
    Tasadqd Hussain
    Tasadqd Hussain
    Ahlawat innovation labs Pvt ltd. - As a PHP developer
     
    Urvashi
    Urvashi
    Spotcodes technologies - As a HR executive
     
    Seema
    Seema
    Future soft solutions - As a HR executive
     
    Vishnu
    Vishnu
    RGP Project & Consultant's - As a PHP developer
     
    Manmohan
    Manmohan
    As a HR executive - Gaursons India Limitedseema
     
    Kamal
    Kamal
    Excellence Technologies Pvt Ltd - As a PHP Developer
     
    Bagwati
    Bagwati
    Future soft solutions - As a HR executive
     
    Pankaj verma
    Pankaj verma
    Sunworld Residency Pvt. Ltd - As a HR manager
     
    Menu