MARCH 2024 VBA MACROS BATCH
Duration : 1 Month
Mode : Zoom
Fees : ₹ 2500 or $ 35
Batch Starts : 01 APRIL 2024
Timing : 10 AM IST / 11:30 PM EST / 8:30 AM PST / 8:30 AM Dubai
INR
Google Pay : Scan the QR code
USD
PayPal : arsalan701@gmail.com
100+ Codes Explained
Automate Everything
7+ Real time projects
Access to VBA Premium Video Library
₹ 15,000
or
200 USD
₹ 2,500
or
35 USD
REGISTRATION PROCESS
1) Make the payment either by Google Pay or by PayPal and send a whatsapp to +919985130004 or email us at info@upskilltechnologies.com
2) Please send your preferred mode of contact either email or whatsapp and we will send you the zoom meeting details.
3) Also any working files or projects will be sent in advance
4) Classes will be online and on each weekday for 1 hour between 10:00 AM to 11:00 AM IST
For any further information please whatsapp us
CONTENTS
-
Recording Macros, its limitations
-
VBA Syntax and Shortcuts
-
Excel Objects, Copy-Paste with VBA
-
Automate simple tasks with VBA
-
Variables and their uses
-
Conditional Statements (IF/Case)
-
Loops (For Each, For Next, Do While)
-
Working with Files and Folders
-
Using Formulas (Vlookup, Sumif...) in code
-
Arrays
-
User Forms
-
User Defined Functions
-
Debugging Errors and Calling macros
-
Connecting Excel to Outlook, Ms Word, PowerPoint and Ms-Access
-
VBA Selenium library to grab text from a website
Sample Projects:
Sales Project to consolidate 100 files from a folder
Project to split a huge dataset into 1000 files and send emails
DEMO VIDEOS
Keywords: VBA Macros online training, Excel VBA Macros, Online Classes, Workshop VBA