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:
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 |