What is macro in MS Excel application?

Dear azhariqbal73,

Macro is a series of instruction to be run (again and again) to gain the result that we may not achieve with normal function/formula in Excel application.

It's a very useful feature in Excel. It enables the record to repetitive actions and then repeat the actions at the click of button. You can make macro easily via the Macro Recorder option under Tools--->Macro--->Record New Macro.

We all know that MS Excel application is a very helpful program in many different industries. A macro in MS Excel performs a unique and helpful function.

The main feature of this is to automatically present to you what you are usually doing in an Excel file, meaning that you do not have to do a repetitive job formatting or charting every time you open MS Excel. In short, macro is like a bookmark in MS Excel that records or saves what you have done before to come out in just a click away.

This is how to use macro:

1.     Select Tools
2.     Click macro
3.     Select Record New Macro
4.     Proceed in recording. The macro records every actions that you are doing in the Ms Excel
5.     Lastly, click Stop Recording once you are done.

Watch this video for a tutorial on how you can download and install JitBit Macro Recorder:

http://youtu.be/mYc6T1tGmlY

Regards,

Ghen