| MS Excel is an excellent application that allows you to | | | | able to save time and effort. |
| compute and organize numerical data. You can also | | | | As mentioned, the macros are easy to create. All |
| tabulate the data that you have without difficulty. | | | | you have to do is to instruct Excel to start the |
| Excel is very user friendly that most of the computer | | | | recording session and then you can perform the |
| users today know how to operate the program. | | | | actions that you typically do. After that, you will |
| There are many helpful features here that enable the | | | | inform Excel that everything is finished. To automate |
| users to perform various tasks. Among them are the | | | | job with macros, Excel makes use of Visual Basic for |
| Excel macros. Now, you can automate job with | | | | applications or commonly known as the VBA |
| macros in this application. | | | | programming language. Now, do not panic because |
| You will surely see the need to automate job with | | | | those who do not know anything about VBA can still |
| macros in Excel if you have common tasks that you | | | | make use of the Excel macros. |
| have to accomplish in this application. For example, if | | | | If you would like to learn how to begin the process, |
| you often execute the same arrangement of | | | | all you have to do is to follow the easy steps in |
| formats or if you take delivery of data each and | | | | recording the macro. Go to the Tools menu and then |
| every week or monthly, you know that you will have | | | | point to Macro. This is were you can find five |
| to organize them and analyze them every time you | | | | different options namely Macros, Record a New |
| receive them. Now, you can automate job with | | | | Macro, Security, Visual Basic Editor and Windows |
| macros because they allow you to combine all of the | | | | Script Editor. Choose Record a New Macro and then |
| steps in your task. This is through the use of a single | | | | a dialog box will appear. Give a name for the macro |
| command. | | | | that you will record and then click OK. A toolbar that |
| Recording macros is easy and in addition to that, | | | | allows you to stop the process will appear. |
| they are also simple to create. When you speak of a | | | | Once everything is set, the macro will record all of |
| macro, you refer to the tool that allows you to | | | | the keystrokes and the mouse clicks that you have |
| record keystrokes as well as mouse clicks as you | | | | performed. After you are done with it, you can click |
| work on your Excel document. Now, as you have | | | | on Stop to halt the recording. Now, you can run the |
| recorded them, you can play them back later so that | | | | macro by going to Tools and then select the macro |
| you do not have to perform the same old task | | | | that you have created. You can also make a toolbar |
| every now and then. When you play them, they will | | | | button for the macro or you can choose to give it a |
| execute the same commands that you have | | | | certain keystroke if you will be using the macro |
| recorded in the same exact order. This way, you are | | | | often. |