top of page

SEPTEMBER 2023 VBA MACROS BATCH

Duration       : 1 Month

Mode            :  Zoom

Fees              : ₹ 2500 or $ 35

Batch Starts : 01 SEPTEMBER 2023

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

googlepay.jfif

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

WHATSAPP.png
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

bottom of page