An Introduction To

Using macros enables you to repeat tasks much more efficiently than tediously performing each step over and over. A macro is a set of instructions that you use to automate a task. For example, if you want to take each column of numbers, convert them to currency, and then add them together, you can create a simple macro to perform this task. The typical Excel user has a series of tasks that they perform frequently. By creating a macro to perform those tasks, you only require a simple keystroke to repeat the tasks.

You can create macros to perform a task as simple as adding two numbers, or as complex as creating a whole user interface within Excel. To do so, you can employ one, or a combination, of two different methods: You can use the Macro Recorder, or you can manually write a macro

0 0

Post a comment