Excel macros are a powerful way to automate your work. In simple terms, Microsoft Excel macros are a way to record your actions within the program and play them back at the touch of a key. Macros can also be written to perform customized actions, creating what amounts to a miniature application within Excel.
Recording Excel Macros
The simplest way to learn Excel macros is to record one. Let's say that you are in charge of collecting a sales spreadsheet from your coworkers, gathering a few cells from each copy and compiling them into a single reporting spreadsheet. You could tediously cut and paste the information from each sheet, or you could record the steps in a macro. Once the macro was created, you could harvest the data from each sheet with a few key clicks. To record a macro, follow these steps:
To access saved macros, click Tools, Macro, Macros. The macro dialog box lets you run, delete, edit or change the options of saved macros.
Under The Hood
Microsoft has created a more powerful macro creation tool by incorporating the Visual Basic Editor. Visual Basic is a full-blown programming language that allows you to create macros that are essentially fully functional programs. There are many resources to learn macro programming available on the Internet and at Microsoft's Office Web site. To create a programmable macro:
Spreadsheet software, a useful tool for financial and other types of calculations, is offered by a number of different software manufacturers, both as a part of application "suites" and as stand-alone programs.