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 
 Option Explicit
 Comment and Indent
 Variable Types
 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


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) Pay through Payment Gateway (International transactions acceptable)