EXCEL macro : Introduction

We are using EXCEL to do our daily data managements and report.

Actually we can do more than this and do some automation for
our data analysis, generating auto reports, sending mail ,zipping file,and etc using EXCEL. We can do this using EXCEL macro (VBA language scripting in EXCEL).

To start doing macro
Open your EXCEL.
Press ALT+F11,
Microsoft Visual basic for application window will appear
as below

to start coding,
go to INSERT tab, and select Module.
Module window will appear. This is where you do the coding.