Microsoft Excel Macro VBA Training

Course details

Unit 1
Recording & Running Macros
Creating Button to run the macros
Correct methods of recording macros
Unit 2
Overview of Excel VBA Editor
Adding & Deleting Modules
Sub & End Sub
Unit 3
Protecting your Macro Codes)
Working with Workbooks & Worksheets
Understanding Ranges coding
Declaring Variables
 Unit 4
Using IF & Multiple IF in macro
Unit 5
Understanding Looping
Practically using looping in macro
Unit 6
Taking Backup of Modules
Debugging Code & Break Points
Commenting Codes
 Unit 7
Creating Message Box for interaction
Using different types of Message boxes
Using IF Condition in Message Box
 Unit 8 (Practical Projects)
Formatting regular reports
Auto Filtering & Separating Data
Consolidating Multiple Sheet into one
Consolidating Multiple files into one
  Updated on 09 June, 2019