Email: [email protected] | WhatsApp: +91 9910060442
Microsoft VBA Training by Ashwani Goel
Do you want to automate daily Excel work? Take advantage of MS Excel automation skills with our training by Ashwani Goel.
New weekend batch starting from 06 Jan 2024.
The Trainer is a software developer and have more than 12 years of experience in VBA, Excel, Macros,
Microsoft office automation and data visualization.
He is founder and author of MYCODETRICKS blog.
Click Here to check Trainer's Profile
Course Content:
- Understanding Excel Macros - 30 Mins
- Excel Macro Recorder Tool - 45 Mins
- How to Record a Macro
- Why to use a Recorder
- Save Excel file that contains macro
- Project Running a Macro
- VBA Concepts - 120 Minutes
- What is VBA Editor
- What are VBA Modules
- What are VBA Procedures
- Understanding VBA Variables
- Understand Range, Sheet, Workbook Objects
- Working with IF Condition and VBA Loops
- VBA - Interacting with Users - 40 Mins
- How and where to use Message and Input box
- How to write comments
- How to use VBA input box
- How to alert user with Errors
- VBA Data Clean with Project - 60 Mins
- Understand the recorded Macro
- How to leverage the recorded macro
- How to loop to use the macro to different sheets
- How to Copy and paste data
- VBA - Working with VBA Forms - 70 Mins
- How to create a form
- How to add different controls in user form
- How to work with events in user form controls
- How to link user form with other VBA codes
- Project on VBA Form
- VBA - Working with Text Files - 60 Mins
- How to open text files
- How to read text files
- How to save data to Excel files
- Queries/ Questions - 50 Mins
Duration: 4 days, 2 hours each (Weekend Batch)
Batch Strength: Max 5- 10 Students
Mode of Language: English
Timings: 8 AM to 10 AM IST or 09 PM to 11 PM IST
Platform: Zoom
Fee: 60 USD or INR 4,999 only
Payment through Paypal
Register Now
Paypal Payment Link
(After payment please share the payment screen shot on Email or Whatsapp)In case of any queries, please contact us at: [email protected] or WhatsApp: +91 9910060442 Website: https://www.mycodetricks.com
