Why use macros?

To automate repetitive tasks, you can quickly record a macro…in Excel 2007 so that you don't have to repeat the same set of commands or steps over and over and over.…So this is a real timesaver, especially if you're going to be doing this often…to the same worksheet or sets of workbooks.…Now, to set up or to record a macro, you need to set up Excel to allow you to see the Developers tab. Now there's different ways…that you could record macros in Excel, and…again, because we're working in the essential things that you need to know about Excel, we're going to use the simplest way of doing…that. And that's to record our movements on the screen.…

First of all though, we need to see the Developers tab, which is not visible at the moment. So what we have to do is we…need to go up to our Microsoft Office button…and select it,…and go back over to our Excel options button that we were looking at at the very beginning of our set of movies.…And in doing that, on our very first screen here,…we are going to enable the Show Developer tab in the ribbon. So I want you to select that…