Webinar on

VBAS - Macros

on

7th October 2023

11:00 am to 04:30 pm

Ü  Introduction to Macros/VBA

·   Introduction to Macros

§  What is a Macro?

§  Introduction to Macro Window

§  How to Run a Macro

§  Assigning Shortcut Keys

§  How to Recoard a Macro

·   Types of Macros/programs

§  Functions

§  Subroutines/Procedures

o   Public, Private

·   Objects/Methods/Actions in VBA/Excel

·   Differeance between Writing and Recoarding Coades

·   Knowing differaent parts of VBA coding

·   Editing already recoarded Macros

·   Limitations of Macro Recoarding

 

Ü  Understanding Cell Referencing in VBA

·   Using Excel Formulas in Macros

·   Understanding R1C1 reference concept

·   What is Variable and type of Variables

·   Using Variables

·   Using for each ….loop for formatting

·   Using with selection option for formatting

·   Fetching data from Excel

·   Selecting Cells, & Selecting a Range

·   Working with Rows/Columns

·   Working with differaent Worksheets /Workbooks

 

Ü  Working with Loops / Conditions / Arrays

·   Understanding concepts of loops

§  Using various types of loops

o   For..Next Loop

o   Do..While Loop, Until Loop

·   Understanding concepts of Conditional Structures

§  If..Then..Else, Select..Case

·   Using various types of Conditional Structures

·   Using Excel functions / Formulas / Tools of Excel in VBA

·   Handling Errors

·   Debugging Program/Errors in real time environment

·   Calling other programs

 

Ü  Working with User Forms

·   Creating User-forms

·   Format a user form

·   Creating User-form tools like List Box/Labels/Text Box etc.

·   Format tools like list box/combo box etc

·   Adding/modifying Items in user form tools used in the forms

·   Activating/Deactivating user forms

Pre-requisites

You should have good internet connection and good quality headphone/speaker set with Laptop / Desktop.

You should have notepad/pen to note down important points.

How to Register:

Fees: Per person

Rs. 4000 /-

USD 811

18% GST is applicable

> Mode of Payment: NEFT /Paytm / Credit Card/ GPAY

> Fees include certificate of participation & Course Material.

*Terms & Conditions apply

Best regards

For GFORD Institute of Management Pvt Ltd

Piyush Verma

For Booking seats Email : gfordseminar@outlook.com 

Mob. : 9711114779 / 9315556407

For Query and nominations – 9540012349 only Whatsapp

For unsubscribe from the mailing list, please mail us on deletemailgford@gmail.com