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

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