VBA Course

SETTING UP ENVIRONMENTSetting up VBA IDE Interactive Development Environment
 Saving as Macro Enabled workbook - 2 types
 Personal Macro Workbook
 Recording Macro - 2 windows
  
  
WRITING FIRST CODEWriting first code
 Where to save - Module, Sheet, Workbook 
 Declaration
 Option Explicit
 Comment and Indent
 Variable Types
 Intellisense
  
EXAMPLESExamples:
 Sheet - Go to Specific Cell
 Workbook - Greeting
  
  
TYPES OF REFERENCESAbsolute vs Relative
 What can / cannot be recorded
 Assign to buttons - conditional formatting Top 3 Bottom 3
 Assign to buttons - present a dashboard
  
  
EXAMPLESHow to Search online - Dos and Donts
 Breaking down the code - Table of Content
 Breaking down the code - Unhide all Sheets
 Breaking down the code - List all Files in a Folder
 Breaking down the code - Delete Blank Rows
  
  
CREATE FUNCTIONSCreate UDF - user defined function
  
EXAMPLESCreate UserForm
 Connect UserForm to Cells

Practical Learning

Practice Sheets

Recording

Certification by Edu4Sure

Any Payment Method (Please pay as per discussion with the team for the required course)

1) Net Banking

TestFormula Education Pvt. Ltd.        
Account Number: 33729473635            
State Bank of India, Delhi           
IFSC: SBIN0001573

2) Paytm/ Google Pay
+91 - 9643749760 (Deepak)

3) Paypal at  deepak@edu4sure.com 

After making payment, eMail us at partner@edu4sure.com / Call at +91-9555115533

4) Pay through Payment Gateway (International transactions acceptable)