What is Macro in Microsoft Excel ?

If you are Microsoft excel user for sure you are interested in this topic because by using Macro you can :

• Perform a task repeatedly(You can perform same task again and again with single click).
  
• The task perform automatically(You can sit down and see your task being perform).

Very interesting...?

Now take a look at the defination :
A macro is a series of commands and functions that are stored in a Microsoft Visual Basic module and can be run whenever you need to perform the task.
For example :
If you often enter long text strings in cells, you can create a macro to format those cells so that the text wraps automatically.

Note:
a) function:
A prewritten formula that takes a value or values, performs an operation, and returns a value or values. Use functions to simplify and shorten formulas on a worksheet, especially those that perform lengthy or complex calculations.

b) module:
A collection of declarations, statements, and procedures stored together as one named unit. There are two types of modules: standard modules and class modules.

c) Visual Basic :
High level programming language evolved from the earlier DOS version called BASIC. BASIC means Beginners' All-purpose Symbolic Instruction Code. It is a fairly easy programming language to learn. The codes look a bit like English Language. Different software companies produced different version of BASIC, such as Microsoft QBASIC, QUICKBASIC, GWBASIC ,IBM BASICA and so on.

If you do not know anything about Visual Basic, don't worry about that because in Microsoft excel we don't have to write, we can record the step with with formula and trick.
Let Move On....