Microsoft Excel has many tricks up its sleeve to make your lives easier, but there is one particular function in Excel is the function of Macro. This feature is one of the most powerful but rarely used functions of Excel owing to its ability to create automated tasks and customize logic. Macro in Excel is the ultimate solution to those repetitive and predictable tasks that is enough to drive you up the wall every single day. With Macro, you can standardize and format documents and save time considerably by being able to create these many times without having to type out a single line of code. Now that's convenience.

Here is a walk through of the entire process of creating a Macro in Excel as well as knowing what a Macro is.

What is a Macro?

Macro is a function in MS Excel that is simply a (VBA) Visual Basic for Applications saved in a document. If you think of a document as HTML and a Macro as Javascript it'll be a more comprehensive and easier to understand analogy. Just like the Javascript can manipulate HTML on a web page, the Macro can manipulate a document on your Excel spreadsheet. Macros are one of the most active software inventions that functions on innumerable levels. They are extremely powerful and can do almost anything that you can imagine. Here is a short list of everything that the Macro can do:

     * Manipulate multiple data and texts

     * Application of a variety of formatting and style.

     * Creation of wholly new documents.

     * Communicate with text files, database and other data sources.

     * Multitask in any of the following combinations and a variety of other combinations.

How To Create a Macro?

When your aim is to produce a well formatted and presentable data sheet that has summary totals for each row. Start with your CVS file and a ten to twenty set of numbers having different combinations between 0 and 100 with headers for both the column and row. In order to make a repetitive task automatic, all you need to do is record a Macro in Microsoft Excel. You can also use the Visual Basic for Application in MS Excel (VBA) to create your own Macro script, write your own macro or copy all or a part of a Macro to a new Macro. After having created a Macro, you can assign it to an object such as control or toolbar button so you can run the Macro each time you click on the button. You can also delete a Macro, if you no longer need to use it. So You can do many things with the Macro but you have to decide you're requirements with a Macro. You can create a Macro by using VBA, record a Macro and assign it to any object or bar for speedy use each time you need, you can copy an entire Macro or a part of it to create another Macro or you can delete a Macro that you no longer need. When you record a Macro, the recorder records all the steps needed to complete the actions that youwant the Macro to perform. Its really that easy and convenient.

So using Macro to complete those length and monotonous tasks are a breeze.